Paste_Image.png

$pdo->getAttribute()

<?php

try {
    $dsn = "mysql::host=localhost;dbname=test";
    $username = "root";
    $password = "";
    $pdo = new PDO($dsn, $username, $password);
    echo "自动提交" . $pdo->getAttribute(PDO::ATTR_AUTOCOMMIT);//1
    echo "<br/>";
    echo 'PDO默认的错误处理模式:' . $pdo->getAttribute(PDO::ATTR_ERRMODE);
    echo "<br/>";
    $pdo->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
    echo "自动提交" . $pdo->getAttribute(PDO::ATTR_AUTOCOMMIT);//1
    
} catch (PDOException $e) {
    echo $e->getMessage();
}

<?php

try {
    $dsn = "mysql::host=localhost;dbname=test";
    $username = "root";
    $password = "";
    $pdo = new PDO($dsn, $username, $password);
    $attrArr = array(
        'AUTOCOMMIT', 'ERRMODE', 'CASE', 'PERSISTENT', 'TIMEOUT', 'ORACLE_NULLS',
        'SERVER_INFO', 'SERVER_VERSION', 'CLIENT_VERSION', 'CONNECTION_STATUS'
    );
    foreach ($attrArr as $attr) {
        echo "PDO::ATTR_$attr:";
        echo @$pdo->getAttribute(constant("PDO::ATTR_$attr")), '<br/>';
    }
    
} catch (PDOException $e) {
    echo $e->getMessage();
}

?>

Paste_Image.png

$options

<?php

try {
    $dsn = "mysql::host=localhost;dbname=test";
    $username = "root";
    $password = "";
    $options = array(PDO::ATTR_AUTOCOMMIT => 0, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
    $pdo = new PDO($dsn, $username, $password, $options);
    echo $pdo->getAttribute(PDO::ATTR_AUTOCOMMIT);//0
    echo "<br/>";
    echo $pdo->getAttribute(PDO::ATTR_ERRMODE);//2
} catch (PDOException $e) {
    echo $e->getMessage();
}

?>