Week 7 Activity 2 Modify the getMovieList.php file and include links to display different types of movies: MORE INFO ON THE NEXT PAGE Each link should display a list of movies identified by that link....

1 answer below »
Description and code I need done are in the file(s) I'm linking. This assignment isn't anything long whatsoever and should only take 50-60 minutes. I will also give you some files to help speed up the process by a lot.


Week 7 Activity 2 Modify the getMovieList.php file and include links to display different types of movies: MORE INFO ON THE NEXT PAGE Each link should display a list of movies identified by that link. For example, your code should display an output similar to the following when the Musical Movies link is clicked: _______________________________________________________________ How to Submit back to me Submit the edited getMovieList.php file back to me. Drama Movies Adventure Movies Action Movies $movieGenre); // Obtain data $movieList = getAll($sql, $db, $parameterValues); // Use a table structure for displaying data echo "List of {$movieGenre} Movies"; echo " TitleGenre "; foreach( $movieList as $movie){ /* Each $movie is an associative array. Keys are the same as the field names used in the SQL statement: title and type. */ echo "{$movie['title']}{$movie['type']} "; } echo ""; } catch (PDOException $e) { echo "Error!: ". $e->getMessage() . " "; die(); } } ?> prepare($sql) method returns an object. */ $statement = $db->prepare($sql); /* Execute prepared statement. The execute( ) method returns a resource object. */ $statement->execute($parameterValues ); /* Use the fetchAll( ) method to extract records from the result set. */ $result = $statement->fetchAll(PDO::FETCH_ASSOC); return $result; } ?>
Answered 3 days AfterOct 07, 2021

Answer To: Week 7 Activity 2 Modify the getMovieList.php file and include links to display different types of...

Ketaki answered on Oct 08 2021
118 Votes
$servername = "localhost";
$username = "root";
$password = "";
$dbname="moviedb";
// Create connection
//$conn = mysqli_connect($servername, $username, $password);
    try
    {
        $dbh = new...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here