Chattahoochee Technical College MySql Database Project

Part 2

Use MySql Workbench procedures to create a MySQL 8 database table with the following fields: Name, address, city, state, zip. Place at least three records into the table.

Create a second MySQL 8 table with Occupational information (such a fireman, IT Specialist, …). This will be joined to the first table, so make sure to include a secondary key in the first table.

Create a php 7 file to hold the server, database name, username, and password. (only has this information)

Create an additional php file that does the following:

1) require_once for the file containing the server, database name, userid, and password

2) connects to the mysql 8 environment

3) connects to the database

4) executes a SELECT statement, which includes a join command, to retrieve all records from the database. Make a nice presentation by creating a table for the output.

5) Uses a loop to echo all data

6) closes the connection

What to turn in:

A. All PHP code (compressed).

B. Screen shots of:

1 – Proof that your database is in a MySQL 8 server (not MySQL 5.7).

2 – Proof that your database was created in Workbench (which is part of MySQL 8).

3 – All output of your program.