Questions and Answers
MySQL is the most popular database platform used with Python.
False
Mysqli_ functions are an improved version from PHP5.
True
The default server when connecting to a MySQL database is 'localhost'.
True
To select a database in MySQL, you use the function mysqli_choose_db().
Signup and view all the answers
Each MySQL database server can only contain one database.
Signup and view all the answers
$db is a variable used in PHP to refer to the connection created with a MySQL database.
Signup and view all the answers
When making queries that return information, such as SELECT statements, the result is stored in the variable $result.
Signup and view all the answers
All queries return TRUE upon success.
Signup and view all the answers
The best practice when handling errors in PHP MySQL queries is to use die(mysql_error()).
Signup and view all the answers
The mysqli_fetch_assoc() function in PHP turns a row of the query result into key-value pairs.
Signup and view all the answers
The mysqli_fetch_array() function in PHP returns the query result as an object.
Signup and view all the answers
To access rows returned by a query using mysqli_fetch_array(), you can use associative keys like $retrieve['lastname'].
Signup and view all the answers