文字

MysqlndUhConnection::getSqlstate

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::getSqlstateReturns the SQLSTATE error from previous MySQL operation

说明

public string MysqlndUhConnection::getSqlstate ( mysqlnd_connection $connection )

Returns the SQLSTATE error from previous MySQL operation.

参数

connection

Mysqlnd connection handle. Do not modify!

返回值

The SQLSTATE code.

范例

Example #1 MysqlndUhConnection::getSqlstate() example

<?php
class  proxy  extends  MysqlndUhConnection  {
 public function 
getSqlstate ( $res ) {
  
printf ( "%s(%s)\n" __METHOD__ var_export ( func_get_args (),  true ));
  
$ret  parent :: getSqlstate ( $res );
  
printf ( "%s returns %s\n" __METHOD__ var_export ( $ret true ));
  return 
$ret ;
 }
}
mysqlnd_uh_set_connection_proxy (new  proxy ());

$mysqli  = new  mysqli ( "localhost" "root" "" "test" );
var_dump ( $mysqli -> sqlstate );
$mysqli -> query ( "AN_INVALID_REQUEST_TO_PROVOKE_AN_ERROR" );
var_dump ( $mysqli -> sqlstate );
?>

以上例程会输出:

proxy::getSqlstate(array (
  0 => NULL,
))
proxy::getSqlstate returns '00000'
string(5) "00000"
proxy::getSqlstate(array (
  0 => NULL,
))
proxy::getSqlstate returns '42000'
string(5) "42000"

参见

  • mysqlnd_uh_set_connection_proxy() - Installs a proxy for mysqlnd connections
  • mysqli_sql_state()
上一篇: 下一篇: