$stmt->fetchColumn

Paste_Image.png

<?php
header('content-type:text/html;charset=utf-8');
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');
    $sql = "SELECT username,password,email FROM user";
    $stmt = $pdo->query($sql);
    echo $stmt->fetchColumn(0), "<br/>";
    echo $stmt->fetchColumn(1), "<br/>";
    echo $stmt->fetchColumn(2), "<br/>";
} catch (PDOException $e) {
    echo $e->getMessage();
}
?>

Paste_Image.png Paste_Image.png

$stmt->debugDumpParams()

<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');
    $sql = "INSERT user(username,password,email) VALUES(?,?,?)";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(1, $username, PDO::PARAM_STR);
    $stmt->bindParam(2, $password, PDO::PARAM_STR);
    $stmt->bindParam(3, $email, PDO::PARAM_STR);
    $username = 'testParam';
    $password = 'testParam';
    $email = 'testparam@imooc.com';
    $stmt->execute();
    $stmt->debugDumpParams();

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

Paste_Image.png

<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');
    $sql = 'SELECT * FROM user WHERE username=:username AND password=:password';
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':username', $username, PDO::PARAM_STR);
    $stmt->bindParam(':password', $password, PDO::PARAM_STR);
    $username = 'testParam3';
    $password = 'testParam4';
    $email = 'testParam@imooc.com';
    $stmt->execute();
    $stmt->debugDumpParams();
} catch (PDOException $e) {
    echo $e->getMessage();
}
?>

Paste_Image.png