The following steps must be performed in phpmyadmin Please follow each and every step. Do not forget to attach screenshots.

1. Create a table called tblActor. The tblActor should have the following fields (name, description, dob, country, image)

(a)Paste the SQL commands you wrote to create the table:

(b)Paste a screen shot shows the created table in MyPHPAdmin:

2. Populate the table tblActor with information about your favorite four actors.

Paste a screen shot shows the data you added to the tblActor

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 ViewAllActors.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:\\\tors.com\\brad.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.com\\tom.jpg"},{"name":"Angelina Jolie","description":"Angelina Jolie is an American actress, film director, screenwriter, and author. She has received an Academy Award, two Screen Actors Guild Awards, and three Golden Globe Awards.","dob":"December 18, 1963","country":"United States","image":" http:\\Actors.com\\angelina.jpg"}]}

Note: You can use the https://jsonformatter.curiousconcept.com/ website to validate the above JSON response.

(a) Paste the PHP code you wrote inside the ViewAllActors.php to read the data from the tblActor table and to generate the above JSON response

(b)Paste a screen shot shows the browser after calling the ViewAllActors web service. The link to your ViewAllActors web service should be http://localhost:8080/ ViewAllActors.php or http://localhost/ ViewAllActors.php

4. Create a table called tblTempActor. The tblTempActor should have the following fields (name, description, dob, country, image)

(a) Paste the SQL commands you wrote to create the table (b) Paste a screen shot shows the created table in MyPHPAdmin:

5. Write a PHP code called ParseJSONToDB.php. The ParseJSONToDB.php should call the ViewAllActors.php web service. Then it should parse the JSON response that will get from ViewAllActors.php, in addition, The ParseJSONToDB.php should also save the JSON parsed data into the tblTempActor table.

(a) Paste the PHP code you wrote inside the ParseJSONToDB.php.

(b) Paste a screen shot shows the tblTempActor table after calling the ParseJSONToDB.php