How to connect Mysql database using pdo in php || DN-SPACE

PHP

How to connect Mysql database using pdo in php

Before we use the PDO, we will know why we will use PDO.
PDO Only supports object-oriented.It has many advantages and disadvantages.But the benedits are more.

If we compare with Mysqli, I will see then Mysql only supports Mysql Database. But On the other hand PDO can supports many Databases.If we want to use any others database with PHP then we must work PDO.

Another advantage of the PDO, Suppose you are using Mysql Databas but after some time I thought I would use Oracel database. In This case, The PDO can be easily accessed from others database.

<?php
    class Database
    {
    private static $dbname='databasename';
    private static $dbhost='localhost';
    private static $dbusername='user';
    private static $dbuserpassword='password';
   
    private static $cont= null;
   
    public function __construct(){
        die('init function not access');
       
        }
       
        public static function connect(){
            if(null== self::$cont)
            {
            try
            {
            self::$cont= new PDO("mysql:host=".self::$dbhost.";" ."dbname=".self::$dbname,
            self::$dbusername,self::$dbuserpassword);   
            }
           
            catch (PDOException $e)
            {
                die($e->getMessage());
            }
            }
            return self::$cont;
           
            }
           
            public static function disconnect()
            {
            self::$cont=null;   
            }
   
    }
   
    ?>

See Example

<?php
$pdo= Database::connect();
$sql="select * from table where ID=:UID";

$data= $pdo->prepare($sql);
$data->execute(array(':UID' => $_SESSION['ID']));
$post = $data->fetch();

if($post){

foreach($post as $postdata ){ ?>

<h1><?php  echo $postdata['username'] ; ?></h1>

<?php

}
}
?>