Connection from PHP with MySQL

Sandra Emily 1197 27 Jul 2023

1 Answers

Aryan Kumar 28 Jul 2023

Sure, you can connect from PHP with MySQL using the mysqli extension. The mysqli extension provides a set of functions that allow you to connect to a MySQL database and execute queries.

To connect from PHP with MySQL, you can follow these steps:

Include the mysqli extension. The mysqli extension is not enabled by default, so you will need to include it in your PHP code. You can do this by adding the following line to the top of your PHP file:

PHP

require_once 'mysqli.php';

Create a new mysqli object. The mysqli object represents a connection to a MySQL database. You can create a new mysqli object by calling the mysqli_connect() function. The mysqli_connect() function takes three arguments: the hostname of the MySQL server, the username, and the password. For example, the following code creates a new mysqli object and connects to a MySQL database on the local host with the username root and the password password:

PHP

$mysqli = new mysqli('localhost', 'root', 'password');

Check the connection. After you have created a new mysqli object, you should check the connection to make sure that it is successful. You can do this by calling the mysqli_connect_errno() function. The mysqli_connect_errno() function returns the error number if the connection failed, or 0 if the connection was successful. For example, the following code checks the connection to the MySQL database and displays an error message if the connection failed:

PHP

if ($mysqli->connect_errno) {
    echo 'Error connecting to MySQL: ' . $mysqli->connect_error;
    exit;
}

Execute a query. Once you have checked the connection, you can execute a query by calling the mysqli_query() function. The mysqli_query() function takes one argument: the SQL query. For example, the following code executes a query that selects all rows from the products table:

PHP

$result = $mysqli->query('SELECT * FROM products');

Free the result. After you have executed a query, you should free the result by calling the mysqli_free_result() function. The mysqli_free_result() function frees the memory that was used to store the results of the query. For example, the following code frees the result of the query that was executed in the previous step:

PHP

mysqli_free_result($result);

Close the connection. Once you have finished using the mysqli object, you should close the connection by calling the mysqli_close() function. The mysqli_close() function closes the connection to the MySQL database. For example, the following code closes the connection to the MySQL database:

PHP

mysqli_close($mysqli);

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Connection from PHP with MySQL

Can you answer this question?

1 Answers