Question : php pdo connection
Answered by : stefano-romeo
$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();
}Source : | Last Update : Tue, 21 Apr 20
Question : php PDO database connection
Answered by : testy-tarsier-urhlow4r4m1u
$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 : https://stackoverflow.com/questions/52342329/pdoexception-pdo-construct-php-network-getaddresses-getaddrinfo-failed | Last Update : Mon, 24 May 21
Question : php how to connect to db using PDO
Answered by : khaled-hayek
<?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*/Source : | Last Update : Mon, 21 Jun 21
Question : php pdo sql server connect
Answered by : mobile-star
$db = new PDO("sqlsrv:Server=YouAddress;Database=YourDatabase", "Username", "Password");Source : | Last Update : Wed, 12 Feb 20
Question : database connection in pdo php
Answered by : muddy-mink-pf43cnwkf78m
$connect = new PDO("mysql:host=$host;dbname=$db", $user, $pass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));Source : https://stackoverflow.com/questions/4361459/php-pdo-charset-set-names | Last Update : Sat, 24 Jul 21