============================================================================================== 1. File Name: search-form.php ==============================================================================================
" . $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;