PDO 代码

最新推荐文章于 2025-09-05 14:24:44 发布

weixin_33724046

最新推荐文章于 2025-09-05 14:24:44 发布

阅读量131

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 php

原文链接：http://www.cnblogs.com/cuikang/p/5200199.html

本文介绍了如何使用PHP的PDO扩展来连接并操作MySQL数据库，包括建立连接、执行SQL查询和预处理语句。

<?php

    try{
    $dsn = "mysql:dbname=mydb;host=localhost";
    $pdo = new PDO($dsn,"root","123");
    }
    catch(PDOException $e)
    {
        echo "连接出错".$e->getMessage();
    }
    
    
    $sql = "select * from Info";
    $stmt = $pdo->prepare($sql);
    $stmt->execute();    
     
    while($row = $stmt->fetch())
    {
        print_r($row);
        echo "<br>";
    }
    
    
    //PDO预处理
    /*//写好SQL语句
    $sql = "insert into Info values(?,?,?,?,?)";
    //把SQL语句放在服务器上等待执行
    $stmt = $pdo->prepare($sql);
    
    //将SQL语句中的?绑定上参数
    $stmt->bindParam(1,$code);
    $stmt->bindParam(2,$name);
    $stmt->bindParam(3,$sex);
    $stmt->bindParam(4,$nation);
    $stmt->bindParam(5,$birthday);
    
    //给参数赋值
    $code = "p11";
    $name = "王五";
    $sex = true;
    $nation = "n001";
    $birthday = "1989-2-3";
    
    //执行
    $stmt->execute();
    
    //执行
    $stmt -> execute(array("p111", '赵六', false, 'n002', '1989-3-4')); */
    
    //$sql = "insert into Info values(:code, :name, :sex, :nation, :birthday)";
    
    //$stmt = $pdo->prepare($sql);
    /*
    $stmt->bindParam("code", $code, PDO::PARAM_STR);
    $stmt->bindParam("name", $name, PDO::PARAM_STR);
    $stmt->bindParam("sex", $sex, PDO::PARAM_STR);
    $stmt->bindParam("nation", $nation, PDO::PARAM_STR);
    $stmt->bindParam("birthday", $birthday, PDO::PARAM_STR);
    
    $code = "p112";
    $name = "王五";
    $sex = true;
    $nation = "n001";
    $birthday = "1989-2-3";
    
    $stmt->execute();*/
    
    //$stmt->execute(array("code"=>"p020","name"=>"随

便","sex"=>true,"nation"=>"n003","birthday"=>"1988-5-6"));
    
    
    
    

?>