<html>
<head>
<title> Movies Search </title>
<style type="text/css">
table{
background-color: #FCF;
}
th {
width: 150px;
text-align: left;
}
</style>
</head>
<body>
<h1> Movie Search </h1>
<form method="post" action="search1.php">
<input type="hidden" name="submitted" value="true" />
<label> Search Category:
<select name="category">
<option value="title">Title</option>
<option value="genre">Genre</option>
<option value="director">Director</option>
</select>
</label>
<label> Search Criteria: <input type="text" name="criteria" /></label>
<input type="submit" />
</form>
}
<?php
if (isset($_POST['submitted'])) {
//connect to the database
include 'connect.php'
$category = $_POST['category'];
$criteria = $_POST['criteria'];
$query = "SELECT * FROM 'movies' WHERE '"$category"' LIKE '"$criteria"'";
$result = mysqli_query($query, $dbcon) or die ('error getting data');}
echo "<table>";
echo "<tr> <th>movie_id</th> <th>title</th> <th>genre</th> <th>director</th> </tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
echo "<tr><td>";
echo $row['movie_id'];
echo "<td><td>";
echo "<tr><td>";
echo $row['title'];
echo "<td><td>";
echo "<tr><td>";
echo $row['genre'];
echo "<td><td>";
echo "<tr><td>";
echo $row['director'];
echo "<td><tr>";
}
echo "</table>";
}
?>
// end of main if statement
</body>
</html>
thanks