In-depth analysis of PDO::getAttribute (with code examples)

   

      PHP often needs to deal with data, so it is necessary to have a better understanding of some information of the database each time it is connected, and use PHP If you connect to the database using the ##PDO method, you can use the getAttribute() method to obtain some information about the database. This article will take you to take a look. First, let's take a look at the syntax of the getAttribute() method:

getAttribute    ( int $attribute   )

• $attribute: one of the PDO::ATTR_* constants.

• Return value: If called successfully, the requested PDO attribute value is returned. Returns null if unsuccessful.

Code example:

1. Connect to the database

<?php
$servername="localhost";
$username="root";
$password="root123456";
$dbname="my_database";
$pdo=new PDO("mysql:host=$servername;dbname=$dbname",$username,$password);
echo "连接成功"."<br>";

rrree

2. Output information

输出：连接成功

    echo 'PDO 是否关闭自动提交功能：'.$pdo -> getAttribute(PDO::ATTR_AUTOCOMMIT);
    echo &#39;<br>当前 PDO 的错误处理模式：&#39;.$pdo -> getAttribute(PDO::ATTR_ERRMODE);
    echo &#39;<br>表字段字符的大小写转换：&#39;.$pdo -> getAttribute(PDO::ATTR_CASE);
    echo &#39;<br>与连接状态相关的特有信息：&#39;.$pdo -> getAttribute(PDO::ATTR_CONNECTION_STATUS);
    echo &#39;<br>空字符串转换为 SQL 的 null：&#39;.$pdo -> getAttribute(PDO::ATTR_ORACLE_NULLS);
    echo &#39;<br>应用程序提前获取数据大小：&#39;.$pdo -> getAttribute(PDO::ATTR_PERSISTENT);
    echo &#39;<br>数据库特有的服务器信息：&#39;.$pdo -> getAttribute(PDO::ATTR_SERVER_INFO);
    echo &#39;<br>数据库服务器版本号：&#39;.$pdo -> getAttribute(PDO::ATTR_SERVER_VERSION);
    echo &#39;<br>数据库客户端版本号：&#39;.$pdo -> getAttribute(PDO::ATTR_CLIENT_VERSION);

Recommendation:《2021 PHP Interview Questions Summary (Collection)》《php video tutorial》

The above is the detailed content of In-depth analysis of PDO::getAttribute (with code examples). For more information, please follow other related articles on the PHP Chinese website!