<?php
/* Database config /
$db_host = 'localhost';
$db_user = 'root';
$db_pass = '';
$db_database = 'f16';
/ End config */
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_database)
// collect
if(isset($POST['search'])) {
$searchq = $POST['search'];
$searchq = perg_replace("#[0-9a-z]#i", "", $searchq);
$query = mysql_query("SELECT * FROM student WHERE Name LIKE '%$searchq%' OR Address LIKE '%$searchq%'") OR die("could not search");
$count = mysql_num_rows($query);
if($count == 0) {
$output = 'There was no search result!';
} else {
while ($row = mysql_fetch_array($query)) {
$ame = $row['Name'];
$id = $row['ID number'];
$address = $row['Address'];
$output .= '<div>' .$fname.' '.$address.'</div>';
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Search</title>
</head>
<body>
<form action="f1.php" method="post">
<input type="text" name="search" placeholdr="Enter name">
<input type="submit" value=">>">
</form>
<?php print ("$output");?>
</body>
</html>