pdo 学习01

大家千万不要学我，啥都学，结果啥都搞不定

 

<?php

header("Content-type:text/html;charset=utf-8");

     $servername = "localhost";
     $username = "root";
     $password = "root";
     $dbname = "mydb";
    $dsn =  "mysql:host=$servername;dbname=$dbname";




        $sql = "insert into MyGuests (firstname, lastname, email) VALUES ('dsd','ddd','dsdss@qq.com');";

  
    try{
        $pdo = new PDO($dsn,$username,$password);

    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

       $res =  $pdo->exec($sql);
  
    }catch(PDOException  $e){
        
        echo $e->getMessage();
    }

?>

以上是插入的语句， 

总共分三步， 一，创建pdo 对象， 二， 就是设置 报错模式

三，用 try ... catch 来捕获 错误！

 

获取插入后的记录的id 

 

事务的基本写法：

 try{
        $pdo = new PDO($dsn,$username,$password);

    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


    // // 开始事务
    // $pdo->beginTransaction();
    // // SQL 语句
         $res =  $pdo->exec($sql);
          $res =  $pdo->exec($sql2);
    // // 提交事务
    // $pdo->commit();
    // echo "新记录插入成功";

    
    }catch(PDOException  $e){
        // $pdo->rollback();
        echo $e->getMessage();
    }

 

我重点说的是查询

——————————————————————————

 

<?php

header("Content-type:text/html;charset=utf-8");

     $servername = "localhost";
     $username = "root";
     $password = "root";
     $dbname = "mydb";
    $dsn =  "mysql:host=$servername;dbname=$dbname";


    

    try{
        $pdo = new PDO($dsn,$username,$password);

        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $sql = "select firstname,lastname,email from myguests";

        $stat =   $pdo->query($sql);
        echo "<pre>";
        var_dump($stat);
        echo "</pre>";
    }catch(PDOException   $e){
        echo $e->getMessage();
    }
?>

结果如下：

——————————————————————————————————

 

 

显示结果：

————————————————————————————

----------------------------------------------------------------------------------------------

 

 

---------------------------------------\\

继续：