PDF (US Ltr)
- 6.2Mb
PDF (A4)
- 6.2Mb
HTML Download (TGZ)
- 2.8Mb
HTML Download (Zip)
- 2.9Mb
Copyright 1997-2018 the PHP Documentation Group.
MysqlndUhConnection::getSqlstate
Returns the SQLSTATE error from previous MySQL operation
Description
public string MysqlndUhConnection::getSqlstate(mysqlnd_connection connection);
Returns the SQLSTATE error from previous MySQL operation.
Parameters
-
connection
Mysqlnd connection handle. Do not modify!
Return Values
The SQLSTATE code.
Examples
Example 7.356 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);
?>
The above example will output:
proxy::getSqlstate(array ( 0 => NULL, )) proxy::getSqlstate returns '00000' string(5) "00000" proxy::getSqlstate(array ( 0 => NULL, )) proxy::getSqlstate returns '42000' string(5) "42000"
See Also
mysqlnd_uh_set_connection_proxy
|
mysqli_sql_state
|