PHP & MySQL

What does PDO stand for in PHP?

• PHP Database Operator

• PHP Data Objects

• PHP Dynamic Object

• PHP Database Output

What is the main purpose of PDO in PHP?

• To handle errors in PHP scripts

• To create HTML pages

• To connect to a MySQL database

• To manage HTTP requests

What is required to create a new PDO object in PHP?

• Database name, username, and password

• Hostname, username, and API key

• PHP version, server, and password

• API token, database name, and version number

Which of the following is a correct way to catch exceptions in PHP using PDO?

• try...finally

• if...else

• try...catch

• while...catch

What does the `catch` block in a try...catch statement do?

• It attempts to connect to the database

• It throws an exception if there is no error

• It executes if an error occurs in the try block

• It handles successful database connections

What method is used in PDO to execute a SELECT query?

• execute()

• query()

• prepare()

• select()

How do you output an error message from a caught exception in PHP?

• $e->outputError()

• $e->getError()

• $e->printError()

• $e->getMessage()

What is the purpose of the `include` statement in PHP?

• To include external PHP scripts or files into the current file

• To define a new function in PHP

• To catch database errors

• To output a database query

What is the recommended method to connect to a MySQL database on XAMPP?

• Use the username "admin" and a strong password

• Use "root" as the username and no password

• Use the username "user" and a password

• Use the PHP default database connection settings

How do you safely handle database connection errors in PHP?

• Use echo to display the error message

• Use error_reporting(1) to print all errors

• Use a try...catch block to catch the exception

• Use a custom error handler