============================================================================================== 1. File Name: search-form.php ============================================================================================== PHP Live MySQL Database Search

Student Information Search

============================================================================================== 2. File Name: backend-search.php ============================================================================================== 0){ // Fetch result rows as an associative array while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){ echo "

" . $row["username"] . "

"; } } else{ echo "

No matches found

"; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } } // Close statement mysqli_stmt_close($stmt); } // close connection mysqli_close($link); ?> ============================================================================================== 3. File Name: Create Database Table Query ============================================================================================== CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `username` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `college` varchar(100) NOT NULL, `rollno` varchar(100) NOT NULL, `password` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;