Question

Create a table called "tblActor". The tblActor should have the following fields (name, description, dob, country, image) Paste the SQL commands you wrote to create the table: Paste a screen shot shows the created table in MyPHPAdmin: Populate the table "tblActor" with information about your favorite four actors. Paste a screen shot shows the data you added to the "tblActor": 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

Answer 1

1.

SQL> CREATE TABLE tblActor(
   name VARCHAR (20),
   description VARCHAR (40),
   dob DATE,
   country VARCHAR (15),
   image BLOB 1M,
);

You can use the above SQL query to create the table.

Notice that BLOB can be used to store binary data thereby it can store an image.

The size is specified as 1 Megabytes. Hope this helps.