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();                         
}

Pdo db connection

<?php
$pdo = new PDO('mysql:host=localhost;dbname=databasename', 'username', 'password');
?>

Source: php-einfach.de

Php PDO database connection

$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();
    }

Source: stackoverflow.com

Php pdo sql server connect

$db = new PDO("sqlsrv:Server=YouAddress;Database=YourDatabase", "Username", "Password");

Database connection in pdo php

$connect = new PDO("mysql:host=$host;dbname=$db", $user, $pass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

Source: stackoverflow.com

Php how to connect to db using PDO

<?php 
  $db_src    = "mysql:host=localhost;dbname=databasename";
  $db_user   = "root";
  $db_pass   = "";
  try{
    $connect = new PDO($db_src, $db_user, $db_pass);
    $connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  }
  catch(PDOEXCEPTION $err){
    echo "Failed To Connect. Error " . $err->getMessage();
  }
/* Variable $connect will be used to execute DB Statements*/

-1

Similar codes

0 vote170 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP
0 vote174 views1 answer
Php 7.4 extension sqlite ubuntu
PHP
5 votes211 views3 answers
Drop column table in migration if exist in laravel
PHP Laravel
1 vote182 views9 answers
Convert an Integer Into a String in PHP
PHP
3 votes180 views2 answers
Get woocommerce order details
PHP
0 vote186 views1 answer
Laravel not rollback even has error
PHP
0 vote271 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
0 vote216 views1 answer
PaymentIntent::create laravel
PHP Laravel
1 vote218 views1 answer
Display summernonte data with string limit laravel
PHP Laravel
4 votes164 views1 answer
: Unable to locate package php7.4-fpm
PHP