Exerscise 8: PHP and MySQL database Access

1. Start with a simple table in a Database


I created a database called Test. I created a table called Employees and entered some values for this particular exercise.





2. Create a Webpage with the given code


The following is the code snippet and output:







3.This is how we add a record and is part of a file to create called add_record.html







4. The corresponding PHP file is add_records.php used with the POST method:




Once Added the following is displayed.




5. The last code example shows how to get multiple records.