Homework 5 CSIT 337 Fall 2018 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 1 Visual Basic 2010 How to Program 2 Visual C# 2010 How to Program 3 Java How to Program 4 C++ How to Program 5 C How to Program 6 Internet& World Wide Web How to Program Programming 7 Operating Systems Programming0132152134 Programming Programming Programming Programming 0132151421 0132575663 0132662361 0136 0132151006 123562 Operating Systems 0131828274 (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". Querying a MySQL database. Select a field to display: ID Title Category ISBN Send (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 Homework 5 CSIT 337 Fall 2018 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 1 Visual Basic 2010 How to Program 2 Visual C# 2010 How to Program 3 Java How to Program 4 C++ How to Program 5 C How to Program 6 Internet& World Wide Web How to Program Programming 7 Operating Systems Programming0132152134 Programming Programming Programming Programming 0132151421 0132575663 0132662361 0136 0132151006 123562 Operating Systems 0131828274 (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". Querying a MySQL database. Select a field to display: ID Title Category ISBN Send (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
