Module 7 Mastery Check

1. What do the acronyms PHP and HTML stand for?

2. What does the following line of code do?

    $link = mysql_connect('localhost', 'ron', 'sc0rp1o'); 

3. What symbol do you add to the beginning of a function name to suppress the warning output?

4. What is the PHP equivalent of the MySQL command SHOW TABLES ?

5. What do the PHP functions for forcing type casting do?

6. What security issue does the mysql_escape_string() function guard against?

7. What two methods in PEAR::DB are used to deal with the results from a query (or prepare/execute)?

8. What is database abstraction?

9. What are the two ways to export data from MySQL and import data into Microsoft Excel?

10. How can Microsoft Access be directly linked to MySQL in order to view its data?