Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.Create a table called tblActor. The tblActor should have the following fields (name, description, dob, country, image).Populate the table tblActor with information about your favorite

1.Create a table called tblActor. The tblActor should have the following fields (name, description, dob, country, image).Populate the table tblActor with information about your favorite four actors. Write a PHP code that read the data from the tblActor table, and generate a JSON response similar to the following format.

{"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.

Name the PHP file ViewAllActors.php. Create a table called tblTempActor. The tblTempActor should have the following fields (name, description, dob, country, image).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.

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

Spatio Temporal Database Management International Workshop Stdbm 99 Edinburgh Scotland September 10 11 1999 Proceedings Lncs 1678

Authors: Michael H. Bohlen ,Christian S. Jensen ,Michel O. Scholl

1999th Edition

3540664017, 978-3540664017

More Books

Students also viewed these Databases questions

Question

=+country competitive advantages? Why? Support your point of view.

Answered: 1 week ago