Question: 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

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.

 Using php PDO pelase answer all parts (Do not not use

(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.

SQLi). Please provide explanation what line of codes does do, show outputs

(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

and you code source I am using XAMPP server and mysql on

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

my mac Thank you in advance. Learn to create database on MySql

When user select title

database Learn to create user on MySql database Learn to create PDO

The result screen

and write PHP script to access information from MySql database. In this

When user select ISBN

lab, we will (1) Create a database call it products. (2) Inside

The result

this database, create a table and call it books. (3) Insert 7

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!