Connect PHP to MySQL

Connect PHP to MySQL

Editorial Team
Editorial Team

Follow us on Discord or Telegram to get access to free tutorials and updates.

To access the data stored in a MySQL database, you should first connect to the MySQL database server. There are ways to connect PHP to MySQL database.

  • mysqli – (i stands for improved)
  • PDO – PHP Data Objects.

In this article, we are using mysqli extension because it has several benefits over PDO when using MySQL database.

Syntax

$conn_name=new mysqli("servername", "username","password", "database_name");

Specify the database_name only if you want to use a default MySQL database.

Connect PHP to MySQL – Object Oriented

<?php
//server=localhost, username=root and password=""
$conn = new mysqli("localhost", "root", "");
if ($conn->connect_error) 
{
    //displaying the connection error
    die($conn->connect_error);
} 
echo "Connected successfully";
//closing the connection
mysqli_close($conn);
?>

Connect PHP to MySQL – Procedural

<?php
//server=localhost, username=root and password=""
$conn = mysqli_connect("localhost", "root", "");
if (!$conn) 
{
    //displaying the connection error
    die(mysqli_connect_error());
}
echo "Connected successfully";
?>