RSS Feed Twitter Posts RSS Comments RSS

Saturday, October 19, 2013

PDO Connection Boilerplate

$db_server = 'localhost';
$db_port= '3306';
$db_name = 'test';
$db_user = 'user';
$db_pass = 'pass';

$dsn = 'mysql:host='.$db_server.';dbname='.$db_name.';port='.$db_port;
$driver_options = array(
   PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'",
   PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
   PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
);               
$dbh = new PDO( $dsn, $db_user, $db_pass, $driver_options );

0 comments:

Post a Comment