PDO连接数据库

摘要：<?php //$dsn: mysql:host=>127.0.0.1;dbname=userDB;charset=utf8; $type = 'mysql'; $host = '127.0.0.1'; $dbname = 'userDB'; $charset = 'utf8'; $ds

<?php

//$dsn: mysql:host=>127.0.0.1;dbname=userDB;charset=utf8;

$type = 'mysql';

$host = '127.0.0.1';

$dbname = 'userDB';

$charset = 'utf8';

$dsn = $type.':host='.$host.';dbname='.$dbname.';charset='.$charset;

$user ='root';

$pass = 'root';

try {

//连接

$pdo = new PDO($dsn,$user,$pass);

// 操作 CURD

// 关闭:并非必须，因为脚本结束会自动关闭，不过还是推荐显示的关闭它

$pdo =null;

unset($pdo);

}catch (PDOException $e){

exit($e->getMessage());

}

?>