How to Connect to MySQL Database Using PHP ?

In this blog, we will discuss (How to Connect to MySQL Database Using PHP)
we will create a connection with MySql DB using 2 methods.

  • mysqli_connect
  • PDO
    We will discuss both connections in details and also discuss which connection more secure and more reliable after a successful connection,

Using mysqli_connect() :

PHP provides mysqli_connect() function to open a database connection. This function takes parameters and returns a MySQL link identifier on success or false on failure.

if(! $connection ) {
            die('Could not connect:Error ' . mysql_error());
         echo 'Connected successfully:Success';

2. Using PDO :

PDO refers to PHP Data Object, which is a PHP extension that defines a lightweight and consistent interface for accessing a database in PHP. It is a set of PHP extensions that provide a core PDO
class and database-specific driver.

There are 3 PDO classes,

PDO – PDO represents a connection between PHP and the database.
PDOStatement – PDOStatement represent the prepared statement and after the execution of the statement,
sets an associated result.
PDOException – PDOException represents errors raised by PDO.


    $dbuser = "root";
    $dbpass = "pass"; //If your Db have a Password


            $dbPDO = new PDO('mysql:host=localhost;dbname=hotelDB', $dbuser, $dbpass);
            $dbPDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $pdo->exec('SET NAMES "utf8"');
            echo "Database connected successfully";

    } catch(PDOException $e){

            print "Error!: " . $e->getMessage() . "<br />";


    //On successful connection.   
    $SuccessResult = "Secure Database Connection established.";


Some Popular Databases supported by PDO :

  • MySQL
  • PostgreSQL
  • Oracle
  • Firebird
  • MS SQL Server
  • Sybase Informix
  • IBM

In this blog, we learned How to Connect to MySQL Database Using PHP, you can connect your database using many ways.

Also Read:

How to copy input value to another form through jquery, Easy Form Validation With jQuery

Hi, My name is Gaurav Pandey. I'm a Laravel developer, owner of 8Bityard. I live in Uttarakhand - India and I love to write tutorials and tips that can help other developers. I am a big fan of PHP, Javascript, JQuery, Laravel, WordPress.

Scroll to Top