Podcast
Questions and Answers
MySQL is the most popular database platform used with Python.
MySQL is the most popular database platform used with Python.
False
Mysqli_ functions are an improved version from PHP5.
Mysqli_ functions are an improved version from PHP5.
True
The default server when connecting to a MySQL database is 'localhost'.
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().
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.
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.
$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.
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.
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()).
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.
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.
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'].
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
