Exam 8: Manipulating Mysql Databases With Php

When you are finished working with query results retrieved with the mysql_query() function, you should use the mysql_free_resultset() function to close the resultset.

To prevent your code from trying to create a table that already exists, use the ____________________ command.

Almost every command sent to MySQL from PHP is executed with the ____ function.

The ___ keyword is often used with the primary key to generate a unique id for each new row in a table.

To delete a database, use the ____ function.

The mysql_info() function only returns query information when you add ___ records with the INSERT keyword.

A result pointer is a special type of ____ that refers to the currently selected row in a resultset.

The mysql_info() function also returns information for LOAD DATA queries.

The mysql_error() function returns a value of FALSE if it detects an error.

To close a database connection, use ____.

You can suppress error messages in PHP using the _________________________ (@).

The ____ package is designed to work with MySQL version 4.1.3 and higher.

Because the ____________________ function exits the script immediately if an error occurs, any further script output is not displayed.

PHP, you use the mysql_send() function to send SQL statements to MySQL.

The _________________________ function returns the fields in the current row of a resultset into an associative array and moves the result pointer to the next row.

One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server.

The mysql_delete_db("dbname"[, connection]); script is used to delete a database.

The ____________________ function returns the number of rows in a query resultset.

The ____________________ function is used to select a database or change to a different database.

The mysql_fetch_assoc() function returns the fields into an associative array and uses each row name as the array key.