The workshop is designed to help you anticipate possible questions, review what you've learned, and begin to put your knowledge into practice.
1: | What is the primary function used to make the connection between PHP and MySQL, and what information is necessary? |
A1: | The mysql_connect() function creates a connection to MySQL and requires the hostname, username, and password. |
2: | Which PHP function retrieves a MySQL error message? |
A2: | The mysql_error() function returns a MySQL error message. |
3: | Which PHP function is used to count the number of records in a resultset? |
A3: | The mysql_numrows() function counts the number of records in a resultset. |
Create a PHP script that displays the contents of the grocery_inventory table that was used in the previous hour.