php database class pdo

database connection in php pdo

<?php
class database{
  private $host = "localhost";
  private $db_name = "php_basic";
  private $username = "root";
  private $password = "";
  private $conn;

  // connect database using PDO
  function connect_pdo(){
    try{
      $this->conn = new PDO("mysql:host=".$this->host.";dbname=".$this->db_name, $this->username, $this->password);
      return $this->conn;
    }
    catch(PDOException $ex){
      echo "Connection Error -->> ",$ex->getMessage();
      echo "<br>Error Code -->> ",$ex->getCode();
      echo "<br>Error occur in File -->> ",$ex->getFile();
      echo "<br>Error occur on Line no -->> ",$ex->getLine();

      $this->conn = null; // close connection in PDO
    }
  }
}
?>
  
//how to use 
<?php
include 'connect_db.php';
$database=new database();
$db = $database->connect_pdo();
?>

Posted by: Guest on May-29-2021

<?php $servername = "localhost"; $username = "username"; $password = "password"; try { $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?>

$hostName = "localhost"; $dbName = "test"; $userName = "test"; $password = "test1"; try { $pdo = new PDO("mysql:host=$hostName;dbname=$dbName",$userName,$password); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); }

Code answers related to "php database class pdo"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Answers for "php database class pdo"

Code answers related to "php database class pdo"

Code answers related to "PHP"

PHP Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us