connect_errno) {
echo "db connection error : " . $mysql->connect_error;
exit();
}
// base query
$sql = "SELECT * from view1 WHERE 1=1";
// ADD ON FILTER
$sql .= " AND title like 'R%' AND rating = 'PG-13' ";
// ADD ON sort order
$sql .= " ORDER BY title";
// submit query to database, store returned data as $results
$results = $mysql->query($sql);
if(!$results) {
echo "SQL error: ". $mysql->error . " running query
" . $sql . "
";
exit();
} else {
// put sql into comment block of webpage
echo "";
}
/*
Note: $results is a database "result set".
It has a property $results->num_rows that is a number (how many rows of data)
*/
// Code to output one sample row with list of columns
$sample = $results->fetch_assoc();
echo "";
$results->data_seek(0); // reset results
// close php block
?>
Horror Movies
Horror Movies
Movie Results:
num_rows ?> Universal Studios Horror films
fetch_assoc() ) { // OPEN/active php loop
// while in repeating loop, back into html mode
?>
|
|
|
|