PHP学习笔记：PDO连接MySQL

作业要做一个网页系统，临时需要用到PHP，现学一下。PHP+IIS+MySQL的环境配置等会上。

需要开启插件支持。

数据库变量

$servername = "localhost";      //数据库地址$username = "daya";$password = "123456";$dbname="Person";     //数据库名$tbname="Info";     //表名

创建表

try {    //连接数据库，返回连接对象    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);    //设置连接属性    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    //SQL操作语句    $sql_opt = "CREATE TABLE $tbname (    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,  /*无符号自增整形*/    name VARCHAR(30) NOT NULL,     /*非空字符串*/    phone_number VARCHAR(50),    reg_date TIMESTAMP    )";    //执行    $conn->exec($sql_opt);    echo "数据表 $tbname 创建成功<br>";}catch(PDOException $e){    echo $sql_opt . "<br>" . $e->getMessage()."<br>";}//销毁连接对象$conn = null;

插入条目

try {    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    $sql_opt = "INSERT INTO     $tbname (name, phone_number)    VALUES ('John', '1552909***1');";    $sql_opt .= "INSERT INTO     $tbname (name, phone_number)    VALUES ('Mary',  '1552909***2');";    $sql_opt .= "INSERT INTO     $tbname (name, phone_number)    VALUES ('Julie',  '1552909***3')";    $conn->exec($sql_opt);    echo "新记录插入成功<br>";}catch(PDOException $e){    echo $sql_opt . "<br>" . $e->getMessage();}$conn = null;

查询条目

try {    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    $sql_opt = "SELECT *                FROM $tbname";    $res=$conn->query($sql_opt);    // 输出整个条目    // while($row = $res->fetch(PDO::FETCH_ASSOC)){    //     print_r($row);    //     echo "<br>";    // }    //只输出条目关键信息    $res=$res->fetchall(PDO::FETCH_ASSOC);    foreach($res as $row){        echo $row['id']." ".$row['name']." ".$row['phone_number']." ".$row['reg_date']."<br>";    }}catch(PDOException $e){    echo $sql_opt . "<br>" . $e->getMessage();}$conn = null;

整个条目的输出为：

关键信息的输出为：

删除条目

try {    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    $sql_opt = "DELETE                 FROM $tbname                WHERE name='John'";    $conn->exec($sql_opt);    echo "删除成功<br>";}catch(PDOException $e){    echo $sql_opt . "<br>" . $e->getMessage();}$conn = null;