Result of getActors()"; print_r_html(getActors()); echo "

ID of inserted actor

"; $actor_id = addActor('JUDY','ANDREWS'); echo $actor_id; echo "

ID of inserted actor

"; $actor_id = addActor('SUZY','ANDREWS'); echo $actor_id; echo "

Rows updated in Actor

"; $rowsUpdated = updateActor($actor_id,'Ruby'); echo $rowsUpdated; echo "

Result of getActors()

"; print_r_html(getActors()); echo "

Rows deleted from Actor

"; $rowsDeleted = deleteActor('ANDREWS'); echo $rowsDeleted; ?> query($query); $movies = array(); while ( $row = $result->fetch_object() ) { array_push($movies, $row);; } return $movies; } function getActors() { global $mysqli; $query = 'SELECT * FROM actor'; $result = $mysqli->query($query); $films = array(); while ( $row = $result->fetch_object() ) { array_push($films, $row);; } return $films; } function addActor($fname, $lname) { global $mysqli; $query = "INSERT INTO actor (first_name, last_name)" . "VALUES ('" . $fname . "','" . $lname . "')"; $result = $mysqli->query($query); return $mysqli->insert_id; } function deleteActor($lname) { global $mysqli; $query = "DELETE FROM actor WHERE last_name = '" . $lname . "'"; $result = $mysqli->query($query); /* // Note: the row below will printout all the fields of the $mysqli // object, but it will reset its status! print_r_html($mysqli); */ return $mysqli->affected_rows; } function updateActor($id, $fname) { global $mysqli; $query = "UPDATE actor SET first_name = '" . $fname . "' WHERE actor_id = " . $id; $result = $mysqli->query($query); return $mysqli->affected_rows; } function testSQLprocedures() { echo getMovieTitle(821) . "
"; echo getMovieID('SOUP WISDOM') . "
"; echo getMoviesForActor(152) . "
"; echo getActorID('ADAM','GRANT') . "
"; echo getActorName(55) . "
"; echo getActorsInMovie(1) . "
"; echo isFamilyFriendly(getMovieID('SOUP WISDOM')) . "
"; echo isFamilyFriendly(getMovieID('STONE FIRE')) . "
"; } function getActorName($actorID) { global $mysqli; $query = "call getActorName(" . $actorID. ", @fName, @lName)"; $mysqli->query($query); $result = $mysqli->query("SELECT @fName, @lName"); // printArray($result); $actorName = ''; $row = $result->fetch_object(); // printArray($row); if ($row->{'@fName'} == "") $actorName = 'Actor unknown'; else { $actorName = $row->{'@fName'} . " " . $row->{'@lName'}; } $result->free(); return $actorName; } function getActorID($fname, $lname) { global $mysqli; $query = "call getActorID('" . $fname . "','" . $lname . "', @id)"; $mysqli->query($query); $result = $mysqli->query("SELECT @id"); // printArray($result); $id = 0; $row = $result->fetch_object(); // printArray($row); if ($row->{'@id'}) $id = $row->{'@id'}; $result->free(); return $id; } function getMovieTitle($movieID) { global $mysqli; $query = "call getMovieTitle(" . $movieID . ", @movieTitle)"; $mysqli->query($query); $result = $mysqli->query("SELECT @movieTitle"); $movieTitle = ''; $row = $result->fetch_assoc(); if ($row['@movieTitle'] == "") $movieTitle = 'Movie unknown'; else { $movieTitle = $row['@movieTitle']; } $result->free(); return $movieTitle; } function getMovieID($movieTitle) { global $mysqli; $query = "call getMovieID('" . $movieTitle . "', @id)"; $mysqli->query($query); $result = $mysqli->query("SELECT @id"); $id = 0; $row = $result->fetch_assoc(); if ($row['@id']) $id = $row['@id']; $result->free(); return $id; } function isFamilyFriendly($movieID) { global $mysqli; $familyFriendly = "family unfriendly"; $query = "call isFamilyFriendly('" . $movieID . "', @familyFriendly)"; $mysqli->query($query); $result = $mysqli->query("SELECT @familyFriendly"); $row = $result->fetch_assoc(); if ($row['@familyFriendly']) $familyFriendly="family friendly"; $result->free(); return $familyFriendly; } function getMoviesForActor($actorID) { global $mysqli; $query = "call getMovies(" . $actorID. ")"; $movies = null; if (!$mysqli->multi_query($query)) { echo "Error: " . $mysqli->errno. " " . $mysqli->error; } else { $result = $mysqli->store_result(); // printArray($result); while ( $row = $result->fetch_assoc() ) { // printArray($row); $movies .= $row[Title] . '
'; } } $result->free(); $mysqli->next_result(); // Get the Procedure's (phantom) 2nd result. return $movies; } function getActorsInMovie($movieID) { global $mysqli; $query = "call getActors(" . $movieID. ")"; $actors = null; if (!$mysqli->multi_query($query)) { echo "Error: " . $mysqli->errno. " " . $mysqli->error; } else { $result = $mysqli->store_result(); // printArray($result); while ( $row = $result->fetch_object() ) { // printArray($row); $actors .= $row->{'Actor ID'} . ' '; // Note the curly braces for property with a space in it. } } $result->free(); $mysqli->next_result(); // Get the Procedure's (phantom) 2nd result. return $actors; } function printArray($object) { print_r($object); echo "
"; } /** _PRINT_R_HTML * * Jack Myers, 16-Mar-2012 * Formatted print_r variant. If embedded in php code, will surround print_r statement in 
 tags to preserve line breaks 
	* 
	* @param $array 
	*/ 
	function print_r_html($arr) { 
	 ?>