Php/docs/mysqlnduhconnection.getsqlstate

提供:Dev Guides
< Php
移動先:案内検索

MysqlndUhConnection::getSqlstate

(PECL mysqlnd-uh >= 1.0.0-alpha)

MysqlndUhConnection::getSqlstateReturns the SQLSTATE error from previous MySQL operation


説明

public MysqlndUhConnection::getSqlstate ( mysqlnd_connection $connection ) : string

Returns the SQLSTATE error from previous MySQL operation.


パラメータ

connection
Mysqlnd connection handle. Do not modify!


返り値

The SQLSTATE code.


例1 MysqlndUhConnection::getSqlstate() example

<?phpclass 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"

参考