Using php PDO pelase answer all parts (Do not not use SQLi). Please provide explanation what line of codes does do, show outputs and you code source

I am using XAMPP server and mysql on my mac

Thank you in advance.

Learn to create database on MySql database Learn to create user on MySql database Learn to create PDO and write PHP script to access information from MySql database.

In this lab, we will

(1) Create a database call it products.

(2) Inside this database, create a table and call it books.

(3) Insert 7 records such as shown in the following to the table books. The first column is ID, 2nd column is title, the third is category, and the last one is ISBN. ID is the primary key.

(4) Create a user iw3htp with its password as "password". This user have the all privileges on products databases.

(5) Create an index.html which look like the following. It contains a drop down list with five options. A submit button with face value of Send Query.

(6) Write a php file and call it database.php which will process the web form data when Send Query submit button pressed. The database.php will create a PDO to connect that allows your php script file to connect o database products.

If the user select * from the drop down list

The database.php will response by sending an html like the following

When user select title

The result screen

When user select ISBN

The result

Similar for other ID and category. Please select and catch the screen shots also. Make sure to catch the screen shots for both html select screen shot and its response screen shot.

(7) Use phpMyAdmin to go to books table and modify the title of Operating Systems (the 7th record). Change the title of that book from Operating Systems to yourName Operating Systems. Where yourName is your real name. Copy the screen shot and paste to the result pdf.

1 Visual Basic 2010 How to Program 2 Visual C# 2010 How to Program 3 Java How to Program Programming Programming Programming Programming Programming 0132152134 0132151421 0132575663 0132662361 0136123562 0132151006 4 C++ How to Program 5 C How to Progranm 6 Internet & World Wide Web How to Program Programming 7 Operating Systems Operating Systems 0131828274 1 Visual Basic 2010 How to Program 2 Visual C# 2010 How to Program 3 Java How to Program Programming Programming Programming Programming Programming 0132152134 0132151421 0132575663 0132662361 0136123562 0132151006 4 C++ How to Program 5 C How to Progranm 6 Internet & World Wide Web How to Program Programming 7 Operating Systems Operating Systems 0131828274