Display-Course-Records-PHP-SQL

BACK

Display Course Records with PHP/SQL

A PHP Script to Add and Display Course Records from a MYSQL Database Table

Steps Taken:

1. Create a MySQL database called cmsc340 and create a table called mycourses inside the cmsc340 database.
2. Using PHP PDO, connect to the cmsc340 database by creating a PDO with appropriate connection attributes.
3. The form has an HTML add button that the user can click on, after entering values in the fields of the HTML form, to add a record to the mycourses table using the form’s data
4. Displayed a listing of all records in the mycourses table currently exist along with the total number of credit hours of all courses in the able.
5. When the user enters values in the fields of the HTML form and clicks the add button, the total credit hours of all the retrieved mycourses records is displayed