PDO连接数据库

$dbms = "mysql";
$host ='localhost';
$dbname = 'db_test';
$user ='root';
$pwd ='123456';
$dsn ="$dbms:host=$host;dbname=$dbname";
try {
    $pdo = new PDO($dsn,$user,$pwd,array(PDO::ATTR_PERSISTENT => true));
    echo "PDO持久连接Mysql成功！</br>";

    $sql ="CREATE TABLE tb_user(
             id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY ,
             name VARCHAR(30) NOT NULL ,
             reg_data TIMESTAMP 
               )";
    $count =$pdo->exec($sql);
    echo "输出:$count";
    $pdo =null;
    echo "关闭连接!";

}catch (Exception $exception)
{
    echo "异常：".$exception->getMessage()."</br>";
    die();
}