php pdo connection
$host = "localhost";//Ip of database, in this case my host machine
$user = "root"; //Username to use
$pass = "qwerty";//Password for that user
$dbname = "DB";//Name of the database
try {
$connection = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}catch(PDOException $e)
{
echo $e->getMessage();
}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();
?>pdo db connection
<?php
$pdo = new PDO('mysql:host=localhost;dbname=databasename', 'username', 'password');
?>php pdo sql server connect
$db = new PDO("sqlsrv:Server=YouAddress;Database=YourDatabase", "Username", "Password");Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
