$pdo->query($sql)

<?php
header("content-type:text/html;charset=utf-8");
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');
    $sql = "select * from user where id>3;";
    $stmt = $pdo->query($sql);
    var_dump($stmt);
    /*
     * object(PDOStatement)[2]
  public 'queryString' => string 'select * from user where id>3;' (length=30)
     *如果錯的返回false
    */
    echo "<hr/>";
    foreach ($stmt as $row) {
        //var_dump($row);
        echo "編號:" . $row['id'] . "<br/>";
        echo "用戶名:" . $row['username'] . "<br/>";
        echo "郵箱:" . $row['email'] . "<br/>";
        echo "<hr/>";
    }

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

?>

Paste_Image.png

添加

<?php
header("content-type:text/html;charset=utf-8");
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');
    $sql = 'INSERT user(username,password,email) VALUES("king17","' . md5('king11') . '","imooc@qq.com")';
    $pdo->query($sql);
    $stmt = $pdo->query($sql);
    var_dump($stmt);//boolean false

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