php pdo attribute setting method: use [PDO::setAttribute] to set attributes, the syntax structure is [bool PDO::setAttribute (int $attribute, mixed $value)].
php pdo attribute setting method:
Set the method used by PDO to process data
PDO::setAttribute
:Set attribute
PDO::getAttribute
:Get attribute
Syntax:
bool PDO::setAttribute ( int $attribute , mixed $value )
Set database handle properties. Some of the common properties available are listed below; some drivers may use additional specific properties.
Common attributes
PDO::ATTR_AUTOCOMMIT
: Set whether the SQL statement of the client currently connected to the Mysql server is automatically executed. The default is automatic submission
//自动提交属性 var_dump($pdo->getAttribute(PDO::ATTR_AUTOCOMMIT)); //1 $pdo->setAttribute(PDO::ATTR_AUTOCOMMIT,0); var_dump($pdo->getAttribute(PDO::ATTR_AUTOCOMMIT)); //0
PDO::ATTR_CASE
: When pdo obtains data from the result set, how to process the name of the corresponding field
PDO::CASE_LOWER : Display all fields in lowercase letters
PDO::CASE_UPPER: Display all fields in uppercase letters
PDO::CASE_NATURAL: How it was originally How about
$pdo->setAttribute(PDO::ATTR_CASE,PDO::CASE_NATURAL); //或 $pdo->setAttribute(PDO::ATTR_CASE,1); var_dump(PDO::CASE_UPPER); //1 转换为大写 var_dump(PDO::CASE_LOWER); //2 转换为小写 var_dump(PDO::CASE_NATURAL); //0 是怎样就是怎样 $sql = "select * from user "; $stmt = $pdo->query($sql); var_dump($stmt->fetch(PDO::FETCH_ASSOC));
PDO::ATTR_ERRMODE
: Error mode, which mode is used to handle when an error occurs in pdo
PDO::ERRMODE_SILENT: Silent mode, the default is to ignore an error
PDO::ERRMODE_WARNING: Warning mode, if an error occurs, a warning will be reported
PDO::ERRMODE_EXCEPTION: Exception mode, if an error occurs, an exception will be used to handle it (PDOException)
var_dump($pdo->getAttribute(PDO::ATTR_ERRMODE)); var_dump(PDO::ERRMODE_SILENT); //0 静默模式,默认的出错了不管 var_dump(PDO::ERRMODE_WARNING); //1 警告模式,如果出错了就会报出警告 var_dump(PDO::ERRMODE_EXCEPTION); //2 异常模式,如果出错会采用异常来处理(PDOException) PDO::ATTR_PERSISTENT:当前对Mysql服务器的连接是否是长连接
TRUE: It is a long connection ( The use of long connections must be coordinated with: Apache (connection: keepAlive), Mysqld)
FALSE: Default, non-long connection
Related learning recommendations: PHP programming from entry to proficiency
The above is the detailed content of php pdo attribute setting problem. For more information, please follow other related articles on the PHP Chinese website!