11111
<p>maxdb_real_escape_string
<p><liNK TITLE="MaxDB PHP Extension" HREF="ref.maxdb.html">
<p><liNK TITLE="maxdb_real_connect" HREF="function.maxdb-real-connect.html">
<p><liNK TITLE="maxdb_real_query" HREF="function.maxdb-real-query.html">
<p><a href="function.maxdb-real-connect.html">Пред.</a>
<p><a href="function.maxdb-real-query.html">След.</a>
<h1><A NAME="function.maxdb-real-escape-string"></a>maxdb_real_escape_string</h1>
<p><A NAME="AEN76727"></a>
<p>(PECL)maxdb_real_escape_string
<p>(no version information, might be only in CVS)maxdb->real_escape_string -- Escapes special characters in a string for use in a SQL statement, taking into account the current charset of the connection
<p><A NAME="AEN76731"></a><h2>Description</h2>
<p>Procedural style:string maxdb_real_escape_string (resource link, string escapestr)
<p>Object oriented style (method):class maxdb {
<p>string real_escape_sring (string escapestr)
<p>}
<p>- This function is used to create a legal SQL string that you can use in a SQL statement. The string escapestr is encoded to an escaped SQL string, taking into account the current character set of the connection.
<p>- Characters encoded are ', ".
<p><A NAME="AEN76757"></a><h2>Return values</h2>
<p>- Returns an escaped string.
<p><A NAME="AEN76760"></a><h2>See also</h2>
<p>- <a href="function.maxdb-character-set-name.html">maxdb_character_set_name()</a>.
<p><A NAME="AEN76764"></a><h2>Example</h2>
<table>
<tr><td><A NAME="AEN76766"></a>
<p>Пример 1. Object oriented style
<table>
<tr><td><code>
<p>&lt;?
<p>$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
<p>/*check connection*/
<p>if (maxdb_connect_errno()) {
<p>printf("Connect failed: %s\n", maxdb_connect_error());
<p>exit();
<p>}
<p>$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
<p>$city = "'s Hertogenbosch";
<p>/*this query will fail, cause we didn't escape $city*/
<p>if (!$maxdb->query("INSERT into temp.mycity VALUES ('11111','$city','NY')")) {
<p>printf("Error: %s\n", $maxdb->sqlstate);
<p>}
<p>$city = $maxdb->real_escape_string($city);
<p>/*this query with escaped $city will work*/
<p>if ($maxdb->query("INSERT into temp.mycity VALUES ('22222','$city','NY')")) {
<p>printf("%d Row inserted.\n", $maxdb->affected_rows);
<p>}
<p>$maxdb->close();
<p>?>
</code>
</table>
</table>
<table>
<tr><td><A NAME="AEN76769"></a>
<p>Пример 2. Procedural style
<table>
<tr><td><code>
<p>&lt;?
<p>$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
<p>/*check connection*/
<p>if (maxdb_connect_errno()) {
<p>printf("Connect failed: %s\n", maxdb_connect_error());
<p>exit();
<p>}
<p>maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
<p>$city = "'s Hertogenbosch";
<p>/*this query will fail, cause we didn't escape $city*/
<p>if (!maxdb_query($link, "INSERT into temp.mycity VALUES ('11111','$city','NY')")) {
<p>printf("Error: %s\n", maxdb_sqlstate($link));
<p>}
<p>$city = maxdb_real_escape_string($link, $city);
<p>/*this query with escaped $city will work*/
<p>if (maxdb_query($link, "INSERT into temp.mycity VALUES ('22222','$city','NY')")) {
<p>printf("%d Row inserted.\n", maxdb_affected_rows($link));
<p>}
<p>maxdb_close($link);
<p>?>
</code>
</table>
</table>
<p>- The above examples would produce the following output:
<table>
<tr><td>
<pre>
Warning: maxdb_query(): -5016 POS(43) Missing delimiter:) &lt;...>
<p>Error: 42000
<p>1 Row inserted.
</pre>
</table>
<p><a href="function.maxdb-real-connect.html">Пред.</a>
<p><a href="index.html">Начало</a>
<p><a href="function.maxdb-real-query.html">След.</a>
<p>maxdb_real_connect
<p><a href="ref.maxdb.html">Уровень выше</a>
<p>maxdb_real_query
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>