PDO连接数据库

Original 2019-01-08 11:47:29 166
abstract:<?php/** * PDO对象 * PDO($dsn,$user,$password) * dsn: mysql:host = localhost/127.0.0.1;   dbname = userDB; chrset = utf8 (可忽略,默认utf8) */$type = 'mysql';         //数据类

<?php
/**
* PDO对象
* PDO($dsn,$user,$password)
* dsn: mysql:host = localhost/127.0.0.1;   dbname = userDB; chrset = utf8 (可忽略,默认utf8)
*/

$type = 'mysql';         //数据类型

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

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

$charset = 'utf8';      //默认编码

$port = '3306';         //可选;默认值:3306

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


$user = 'root';         //数据库用户名

$password = 'root';     //数据库密码


try{
   //连接
   $pdo = new PDO($dsn,$user,$password);

   //关闭
   $pdo = NULL;

}catch (PDOException $e){
   exit($e->getMessage());
}

Correcting teacher:天蓬老师Correction time:2019-01-08 13:15:55
Teacher's summary:$pdo = NULL; 这个操作, 以后要放在应用中, 记得上线时,从连接文件中删除,否则永远连不上

Release Notes

Popular Entries