Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please read directions carefully. Use Sakila database Use Sakila Database Task 1 1) Create a file titled writeActors.php. This file should query your database to

Please read directions carefully. Use Sakila database image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

More Books

Students also viewed these Databases questions

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago