1. Create a table called \"tblActor\". The tblActor should have the following fi

Question

1. Create a table called "tblActor". The tblActor should have the following fields (name, description, dob, country image) Answer Paste the SOL commands you wrote to create the table Paste a screen shot shows the created table in MyPHPAdmin: 2. Populate the table "tblActor" with information about your favorite four actors. Answer. orite foue "tblActo Paste ascreen shot shows the data you added tothe .thActor: 9990es 3. Write a PHP code that read the data from the "tblActor table, and generate a JSON response similar to the following format. Name the PHP file “View AllActors.php.. "actors"name."Brad Pitt", "description". "Brad Pitt is an American actor and film producer. He has received a Golden Globe Award, a Screen Actors Guild Award, and three Academy Award nominations in acting categories"."dob": "December 18, 1963","country."United States","image"." http:lItors.comllbrad.jpg", "name". "Tom Cruise","description":"Tom Cruise, is an American film actor and producer. He has been nominated for three Academy Awards and has won three Golden Globe Awards.","dob":"July 3, 1962","country". "United States","image"."http:Actors.comltom.jpg" "name"."Angelina Jolie","description":"Angelina Jolie is an American actress, film director, screenwriter, and

Explanation / Answer

1)Creating the table tblActor:

create table tablActor(name varchar(32),description text,dob date,country varchar(32),image image);

2)Populating or displaying four actors from the table tblActor:

select * from tblActor order by name limit 4;

limit in mysql defines number of records to be displayed on the console.

4)Create table tblTempActor

create table tblTempActor(name varchar(32),description text,dob date,country varchar(32),image image);

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.