11111
<p>maxdb_stmt_error
<LINK TITLE="MaxDB PHP Extension" HREF="ref.maxdb.html"><LINK TITLE="maxdb_stmt_errno" HREF="function.maxdb-stmt-errno.html"><LINK TITLE="maxdb_stmt_execute" HREF="function.maxdb-stmt-execute.html">
<p><a href="function.maxdb-stmt-errno.html">Пред.</a>
<p><a href="function.maxdb-stmt-execute.html">След.</a>
<p><h1><a name="function.maxdb-stmt-error"></a>maxdb_stmt_error</h1><div><a name="AEN77578"></a>
<p>(PECL)maxdb_stmt_error
<p>(no version information, might be only in CVS)maxdb_stmt-&#62;error -- Returns a string description for last statement error</div><div><a name="AEN77582"></a><h2>Description</h2>
<p>Procedural style:string maxdb_stmt_error (resource stmt)
<p>Object oriented style (property):class <B CLASS="classname">stmt {
<p>string error
<p>}
<p>- For the statement specified by stmt, maxdb_stmt_error()
<p>returns a containing the error message for the most recently invoked statement function that
<p>can succeed or fail.
<p></div><div><a name="AEN77601"></a><h2>Return values</h2>
<p>- A string that describes the error. An empty string if no error occurred.
<p></div><div><a name="AEN77604"></a><h2>See also</h2>
<p>- <a href="function.maxdb-stmt-errno.html">maxdb_stmt_errno()</a>,
<p><a href="function.maxdb-stmt-sqlstate.html">maxdb_stmt_sqlstate()</a>
<p></div><div><a name="AEN77609"></a><h2>Example</h2><table><tr><td><DIV><a name="AEN77611"></a>
<p>Пример 1. Object oriented style<table><tr><td><code>
<p>&lt;?php
<p>/* Open a connection */
<p>$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
<p>
<p>/* check connection */ 
<p>if (maxdb_connect_errno()) {
<p>printf("Connect failed: %s\n", maxdb_connect_error());
<p>exit();
<p>}
<p>
<p>$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
<p>$maxdb->query("INSERT INTO temp.mycity SELECT * FROM hotel.city");
<p>
<p>
<p>$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
<p>if ($stmt = $maxdb->prepare($query)) {
<p>
<p>/* drop table */
<p>$maxdb->query("DROP TABLE temp.mycity");
<p>
<p>/* execute query */
<p>$stmt->execute();
<p>
<p>printf("Error: %s.\n", $stmt->error);
<p>
<p>/* close statement */
<p>$stmt->close();
<p>}
<p>
<p>/* close connection */
<p>$maxdb->close();
<p>?>
<p>
<p></code></TABLE></div></TABLE><table><tr><td><DIV><a name="AEN77614"></a>
<p>Пример 2. Procedural style<table><tr><td><code>
<p>&lt;?php
<p>/* Open a connection */
<p>$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
<p>
<p>/* check connection */ 
<p>if (maxdb_connect_errno()) {
<p>printf("Connect failed: %s\n", maxdb_connect_error());
<p>exit();
<p>}
<p>
<p>maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
<p>maxdb_query($link, "INSERT INTO temp.mycity SELECT * FROM hotel.city");
<p>
<p>
<p>$query = "SELECT name, zip FROM temp.mycity ORDER BY name";
<p>if ($stmt = maxdb_prepare($link, $query)) {
<p>
<p>/* drop table */
<p>maxdb_query($link, "DROP TABLE temp.mycity");
<p>
<p>/* execute query */
<p>maxdb_stmt_execute($stmt);
<p>
<p>printf("Error: %s.\n", maxdb_stmt_error($stmt));
<p>
<p>/* close statement */
<p>maxdb_stmt_close($stmt);
<p>}
<p>
<p>/* close connection */
<p>maxdb_close($link);
<p>?>
<p>
<p></code></TABLE></div></TABLE>
<p>- The above examples would produce the following output:
<p><table><tr><td><PRE>Warning: maxdb_stmt_execute(): -4004 POS(23) Unknown table name:MYCITY [42000] &#60;...&#62;
<p>Error: POS(23) Unknown table name:MYCITY.</PRE></TABLE></div>
<p><a href="function.maxdb-stmt-errno.html">Пред.</a>
<p><a href="index.html">Начало</a>
<p><a href="function.maxdb-stmt-execute.html">След.</a>
<p>maxdb_stmt_errno
<p><a href="ref.maxdb.html">Уровень выше</a>
<p>maxdb_stmt_execute
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>