How to connect to database in php using oop

Connect to database in php using oop


In this article, you will be learning how to connect database using oop in php (object oriented programming in php).

So, Let's begin with connecting your database in php oop where we will be seeing 2 example to connect database. 1. MySqli Object Oriented 2. MySqli Procedural.


Create a file DBConn.php and give MySqli Object Oriented Database connection in PHP

Example: MySqli Object Oriented in php

<?php

define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASSWORD','');
define('DB_DATABASE','adminpanel');

class DatabaseConnection
{
    public function __construct()
    {
        $conn = new mysqli(DB_HOST,DB_USER,DB_PASSWORD,DB_DATABASE);

        if($conn->connect_error)
        {
            die ("<h1>Database Connection Failed</h1>");
        }
        //echo "Database Connected Successfully";
        return $this->conn = $conn;
    }
}

?>


Example: MySqli Procedural Database Connection in php.

<?php

define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASSWORD','');
define('DB_DATABASE','adminpanel');

class DatabaseConnection
{
    public function __construct()
    {
        $conn = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_DATABASE);

        if (!$conn)
        {
            die ("<h1>Database Connection Failed</h1>". mysqli_connect_error());
        }
        echo "Database Connected Successfully";
return $this->conn = $conn;
    }
}

?>


Thank you.

© Copyright - 2018 - 2022 | All rights reserved at Funda of Web IT