Question: Use Sakila Database Task 1 1) Create a file titled writeActors.php. This file should query your database to find all the movies that each actor
Use Sakila Database Task 1 1) Create a file titled writeActors.php. This file should query your database to find all the movies that each actor starred in. You need to write to a text file a record for each actor. The record should contain the first and last name of the actor, the number of films they starred in, and a list of the films. You should also write this information to an HTML table with 3 columns. Use the format shown below. (note that Julia Fawcett actually starred in 15 films, below is simply to demonstrate the file format). Both the html table and the text file should be sorted by actor last name. Last Name, First Name:number of films:fiinTitle,, fil Title,iin For example: Fawcott, Julia:2:Berets Agent, Boiled Dares:In You may use any combination of SQL/PHP you wish. You can write a fancy SQL statement to do some processing for you, or you can simply use SQL to "grab" the info from the database, then use PHP to process the info. If you concatenate actor last name and first name you will have a unique value you can use as a key in an associative array
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
