Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started