PDO连接数据库

Original 2019-02-19 22:04:23 237
abstract:$type = 'mysql';$host = '127.0.0.1';//数据库主机名$dbname = 'php_edu';//数据库名$charset = 'utf8';$port = '3306';$dsn = $type.':host='.$host.';dbname='.$d

$type = 'mysql';

$host = '127.0.0.1';//数据库主机名

$dbname = 'php_edu';//数据库名

$charset = 'utf8';

$port = '3306';


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

// echo $dsn;

$user = 'root';

$pass = 'root';



// var_dump($pdo);


try {

//连接

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

// echo $pdo ? '连接成功' : '失败';


//操作:CURD


//关闭:并非是必须的,脚本结束会自动关闭,不过还是推荐写上

$pdo = null;//或unset($pdo);


}catch (PDOException $e){

exit($e->getMessage());

}


Correcting teacher:查无此人Correction time:2019-02-20 09:03:16
Teacher's summary:完成的不错,php7版本,都使用pdo操作数据库,所以很重要,多练习。继续加油。

Release Notes

Popular Entries