How can we connect to a MySQL database from a PHP script?
- Use the mysqli_connect() function
- Use the mysql_connect() function
- Use the pdo_connect() function
- Use the db_connect() function
To connect to a MySQL database from a PHP script, you can use the mysqli_connect() function. This function establishes a connection to a MySQL database server using the provided credentials (host, username, password, and optional database name). It returns a MySQLi object that can be used to perform database operations such as executing queries and fetching results. It's important to note that the mysqli_connect() function is part of the MySQLi extension, which is the recommended extension for working with MySQL databases in PHP. The older mysql_connect() function is deprecated and should not be used in new code. Additionally, there is also the PDO extension that provides a consistent interface for connecting to various databases, including MySQL. You can use the PDO extension with the appropriate driver to connect to a MySQL database.
Loading...
Related Quiz
- You need to check if a function has been defined in your PHP script. How would you do this?
- What is the purpose of the str_replace() function in PHP?
- You should always close a file in PHP using the fclose() function after you're done with it.
- How can you define a callback function in PHP?
- A constant of a PHP class can be accessed using the class name followed by the scope resolution operator (::) and the constant name.