Searching for users

Welcome, insert the username

"; if (isset($_POST['username'])) { $searchby = '%' . $_POST['username'] . '%'; //Connecting to the MySQL $connection = mysqli_connect('localhost', 'root', 'secret'); //Fetching data $fetch = mysqli_query($connection, "SELECT * FROM users_db.login WHERE username LIKE '$searchby'"); //Transforming data to PHP-readable format $result = mysqli_fetch_all($fetch, MYSQLI_ASSOC); //Now we've got multidimentional array, we need to show it correctly foreach($result as $value) { echo "

"; foreach($value as $key => $value1) { echo "" . $key . ": " . $value1 . " " . ""; } echo "

"; } } echo " "; unset($_POST['username']);

Form with mysqli_fetch_all()