Search results
query($sql);
if(!$results) {
echo "
Your SQL:
" . $sql . "
";
echo "SQL Error: " . $mysql->error . "
";
exit();
}
// echo "
You searched for Title: " . $_REQUEST['title'] . " and Rating: " . $_REQUEST['rating'] . " and Genre: " . $_REQUEST['genre'] . "";
// echo "
";
// echo "
(SQL: " . $sql . ")";
// echo "
";
echo "
Your results returned " .
$results->num_rows .
" results.";
echo "
";
if (!empty($_REQUEST["email"])) {
$message = "Movie Search Results\r";
$message .="--------------------------------\r";
while($currentrow = $results->fetch_assoc()) {
$message .= "Movie " . $currentrow["title"] .
" (Rated " .
$currentrow["rating"] .
"), " .
$currentrow["genre"] .
"\r"; // \r is a carriage return in plain text
}
// email $message as body of message. Use $_REQUEST["email"] as "to"
mail($_REQUEST["email"], "Your Movie Results", $message);
echo "
(results emailed to " . $_REQUEST["email"] . ")
";
$results->data_seek(0); // reset results back to row 1
}
while($currentrow = $results->fetch_assoc()) {
echo "
" .
$currentrow['title'] .
"".
" (Rated " . $currentrow['rating'] . ")
" .
"
" .
"
";
}
?>