11111
<p>mysqli_sqlstate
<LINK TITLE="Improved MySQL Extension" HREF="ref.mysqli.html"><LINK TITLE="mysqli_set_opt" HREF="function.mysqli-set-opt.html"><LINK TITLE="mysqli_ssl_set" HREF="function.mysqli-ssl-set.html">
<p><a href="function.mysqli-set-opt.html">Пред.</a>
<p><a href="function.mysqli-ssl-set.html">След.</a>
<p><h1><a name="function.mysqli-sqlstate"></a>mysqli_sqlstate</h1><div><a name="AEN100597"></a>
<p>(PHP 5)mysqli_sqlstate
<p>(no version information, might be only in CVS)mysqli-&#62;sqlstate -- Returns the SQLSTATE error from previous MySQL operation</div><div><a name="AEN100601"></a><h2>Description</h2>
<p>Procedural style:string mysqli_sqlstate (mysqli link)
<p>Object oriented style (property):class <B CLASS="classname">mysqli {
<p>string sqlstate
<p>}
<p>- Returns a string containing the SQLSTATE error code for the last error.
<p>The error code consists of five characters. '00000' means no error.
<p>The values are specified by ANSI SQL and ODBC. For a list of possible values, see
<p><a href="http://dev.mysql.com/doc/mysql/en/error-handling.html" TARGET="_top">http://dev.mysql.com/doc/mysql/en/error-handling.html</a>.
<p><DIV><BLOCKQUOTE>
<p>Замечание:
<p>Note that not all MySQL errors are yet mapped to SQLSTATE's.
<p>The value HY000 (general error) is used for unmapped errors.
<p></BLOCKQUOTE></div></div><div><a name="AEN100623"></a><h2>Возвращаемые значения</h2>
<p>- Returns a string containing the SQLSTATE error code for the last error.
<p>The error code consists of five characters. '00000' means no error.
<p></div><div><a name="AEN100627"></a><h2>Смотрите также</h2>
<p>- <a href="function.mysqli-errno.html">mysqli_errno()</a> и
<p><a href="function.mysqli-error.html">mysqli_error()</a>.
<p></div><div><a name="AEN100632"></a><h2>Примеры</h2><table><tr><td><DIV><a name="AEN100634"></a>
<p>Пример 1. Object oriented style<table><tr><td><code>
<p>&lt;?php
<p>$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
<p>
<p>/* check connection */
<p>if (mysqli_connect_errno()) {
<p>printf("Connect failed: %s\n", mysqli_connect_error());
<p>exit();
<p>}
<p>
<p>/* Table City already exists, so we should get an error */
<p>if (!$mysqli->query("CREATE TABLE City (ID INT, Name VARCHAR(30))")) {
<p>printf("Error - SQLSTATE %s.\n", $mysqli->sqlstate);
<p>}
<p>
<p>$mysqli->close();
<p>?>
<p>
<p></code></TABLE></div></TABLE><table><tr><td><DIV><a name="AEN100637"></a>
<p>Пример 2. Procedural style<table><tr><td><code>
<p>&lt;?php
<p>$link = mysqli_connect("localhost", "my_user", "my_password", "world");
<p>
<p>/* check connection */
<p>if (mysqli_connect_errno()) {
<p>printf("Connect failed: %s\n", mysqli_connect_error());
<p>exit();
<p>}
<p>
<p>/* Table City already exists, so we should get an error */
<p>if (!mysqli_query($link, "CREATE TABLE City (ID INT, Name VARCHAR(30))")) {
<p>printf("Error - SQLSTATE %s.\n", mysqli_sqlstate($link));
<p>}
<p>
<p>mysqli_close($link);
<p>?>
<p>
<p></code></TABLE></div></TABLE>
<p>Результат выполнения данного примера:<table><tr><td><PRE>Error - SQLSTATE 42S01.</PRE></TABLE></div>
<p><a href="function.mysqli-set-opt.html">Пред.</a>
<p><a href="index.html">Начало</a>
<p><a href="function.mysqli-ssl-set.html">След.</a>
<p>mysqli_set_opt
<p><a href="ref.mysqli.html">Уровень выше</a>
<p>mysqli_ssl_set
22222
<div style="text-align:right;position:fixed;bottom:3px;right:3px;width:100%;z-index:999999;cursor:pointer;line-height:0;display:block;"><a target="_blank" href="https://www.freewebhostingarea.com" title="Free Web Hosting with PHP5 or PHP7"><img alt="Free Web Hosting" src="https://www.freewebhostingarea.com/images/poweredby.png" style="border-width: 0px;width: 180px; height: 45px; float: right;"></a></div>