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.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!