Lab 9

Create a create.txt put your SQL statements into a plain text file named create.txt.

Provide SQL statements that will do the following:

Create a database named lesson09 Create a table named books that has the following structure

ID must auto increment

id

title

author

published_year

Create an insert.txt put your SQL statements into a plain text file named insert.txt.

Provide SQL statements that will do the following:

Insert 3 rows of data into the books table you created Your table should look similar to this

id	Title	author	published_year
1	Book 1	John	2005
2	Book 2	Jane	2010
3	Book 3	Joe	2012

Create a table.php this script will do the following:

Connects to the local database server Make sure your username and passwords are variables that your instructor can change Selects the database lesson09 to use Select all rows from the table. Display all rows selected into an HTML table.