I've encountered a problem where my php code doesn't seem to work, I have looked at it over and over again and I can't figure it out. I am working on a project which requires me to allow a potential user of my product (the website) to search for an event by type such as comedy or live band etc. This should allow a user to view all events of the type they type in to appear.
So far I have created this code:
<?php
//$output= NULL;
if(isset($_POST['submit'])){
//connect db
require_once('connect.php');
$search = $_POST['search'];
//query db
$result = $mysqli->query("SELECT * FROM resit1617_events WHERE type =
'$search'");
if($result->num_rows > 0){
while($rows = $result->fetch_assoc())
{
$event = $rows['name'];
$type = $rows['type'];
$description = $rows['description'];
$day = $rows['day'];
$month = $rows['month'];
$year = $rows['year'];
$recommendations = $rows['recommendations'];
$age = $rows['min_age'];
$output ="Event: $event, Type: $type, Date: $day/$month/$year, Minimum Age: $age, Recommendations: $recommendations, Description:
$description<br />";
}
}else{
$output = "No Results";
}
}
?>
Then I have my HTML code with php included to echo the output values but the code seems to not work
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>The Welders Arms</title>
<link rel="stylesheet" type="text/css" href="css/main.css">
</head>
<body>
<div id="topbar">
<p><img src="img/logo.png" alt="logo"></p>
</div>
<div id="wrapper">
<form method="POST" action="search.php">
<label id="searchheading">Search Events in The Welders Arms</label>
<br>
<input type="text" placeholder="Search by type of event e.g. live band, comedy etc.." id="type" name="search">
<input type="submit" id="searchbutton" value="Search">
<br>
</form>
<?php echo $output; ?>
</div>
</body>
</html>
If anyone knows a solution to why it could not work please let me know as this is holding me back from continuing onward with my project.
Thank You!
PS. All of the code is in one file called search.php