Add an SQL database to your existing HTML website project.

Requirements:

• Create an SQL database
• Use PHP (server code) to connect your website to the database

Some ideas for using an SQL database:

• Store and display user comments
• Store product reviews and display them
• Save high scores for a game
• Save progress in a game
• Save / display the number of visits to a website
• Store information records about a topic and display them
• Save image names
• Save information for an online store (products, user info, orders)
• Store up-votes / down-votes / likes for a forum style page
• Save the score history for a quiz page or a personality test page

Grading:

This will be assessed on the data standard and the programming standard.

Level 4 (advanced)

Collect data for the database from the website using an HTML form or other method of your choice.

Use PHP to execute both INSERT and SELECT queries to add records to your database and display database information on the website.

Level 3 (proficient)

Use PHP to establish a database connection and execute SQL queries on the website.

Level 2 (developing)

Demonstrate ability to use SQL databse text commands to modify and access the database in Bash terminal command line, such as INSERT and SELECT.

Level 1 (basic)

Design and create an SQL database & table related to the website’s topic using phpMyAdmin graphical interface. Insert and display records into the database.