Chattahoochee Technical College MySQL 8 & Workbench to Create a Database ER Diagram

1. If your version of PHP is not currently attached to MySQL 8 (It MUST BE MYSQL 8), then follow the directions shown in the MySQL 8 chapter that was previously provided to make sure your version of PHP is talking to MySQL 8. THIS IS A REQUIREMENT TO BE ABLE TO COMPLETE THE REST OF THE ASSIGNMENT.

2. Once you are sure that your version of PHP is communicating with MySQL 8, do the following.

Create a PHP program that will read in each table of the database you created in Assignment 8 and display the values into a good looking table.

Your tables should have been created by MySQL Workbench already. I will check to make sure they are the same tables by comparing format and content.

The PHP program, therefore, must display ALL the fields and records for all the tables.

DO NOT merge tables via Joins or any other method at this time.

This assignment must be successful for you to complete assignment 10 next week. So make sure it works correctlly,

What to turn in:

1. Your PHP code (compressed) in the proper PHP file format so I can run it.

2. Go into WorkBench and extract the code which creates the tables. This is done by clicking just a couple of buttons (see the MySQL 8 chapter provided or check out YouTube for related videos). Compress this code and drop it in the dropbox. I WILL use this code to create your tables on my system and to run your program against the tables. So you MUST provide this!

2. Screen shots showing each of the tables displaying after the information has been pulled my the PHP program from the database. Remember to make your tables look good.

Questions? Let me know!