<?php
	include 'header.php';
?>

<h1>Search Page</h1>

<div class="equipment-container">
<?php>
	if (isset($_POST['submit-search'])) {
			$search = mysqli_real_escape_string($conn, $_POST['search']);
			$sql = "SELECT * FROM equipment WHERE EquipmentName LIKE '%$search%'OR RoomClasses LIKE '%$search%'OR RoomClassesID LIKE '%$search%' ";
			$result = mysqli_query($conn, $sql);
			$queryresults = mysqli_num_rows($result);

			echo"There are ".$queryresults." results!";

			if ($queryresults > 0){
				while($row = mysqli_fetch_assoc($result)){
				echo "<div class='equipment-box'>
					<h3>".$row['Equipmentid']."</h3>
					<p>".$row['EquipmentName']."</p>
					<p>".$row['RoomClasses']."</p>
					<p>".$row['RoomClassesID']."</p>
					<p>".$row['EDate']."</p>
				</div>";
				}
			} else {
				echo "There are no results matching your search!";
			}
	}
?>
</div>