11111
<p>mysqli_real_escape_string
<LINK TITLE="Improved MySQL Extension" HREF="ref.mysqli.html"><LINK TITLE="mysqli_real_connect" HREF="function.mysqli-real-connect.html"><LINK TITLE="mysqli_real_query" HREF="function.mysqli-real-query.html">
<p><a href="function.mysqli-real-connect.html">Пред.</a>
<p><a href="function.mysqli-real-query.html">След.</a>
<p><h1><a name="function.mysqli-real-escape-string"></a>mysqli_real_escape_string</h1><div><a name="AEN100169"></a>
<p>(PHP 5)mysqli_real_escape_string
<p>(no version information, might be only in CVS)mysqli-&#62;real_escape_string --
<p>Escapes special characters in a string for use in a SQL statement,
<p>taking into account the current charset of the connection
<p></div><div><a name="AEN100173"></a><h2>Description</h2>
<p>Procedural style:string mysqli_real_escape_string (mysqli link, string escapestr)
<p>Object oriented style (method):class <B CLASS="classname">mysqli {
<p>string real_escape_string (string escapestr)
<p>}
<p>- This function is used to create a legal SQL string that you can use in a SQL statement.
<p>The string escapestr is encoded to an escaped SQL string, taking into
<p>account the current character set of the connection.
<p>- Characters encoded are NUL (ASCII 0), \n, \r, \, ', ", and Control-Z.
<p></div><div><a name="AEN100199"></a><h2>Возвращаемые значения</h2>
<p>- Returns an escaped string.
<p></div><div><a name="AEN100202"></a><h2>Смотрите также</h2>
<p>- <a href="function.mysqli-character-set-name.html">mysqli_character_set_name()</a>.
<p></div><div><a name="AEN100206"></a><h2>Примеры</h2><table><tr><td><DIV><a name="AEN100208"></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>$mysqli->query("CREATE TEMPORARY TABLE myCity LIKE City");
<p>
<p>$city = "'s Hertogenbosch";
<p>
<p>/* this query will fail, cause we didn't escape $city */
<p>if (!$mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
<p>printf("Error: %s\n", $mysqli->sqlstate);
<p>}
<p>
<p>$city = $mysqli->real_escape_string($city);
<p>
<p>/* this query with escaped $city will work */
<p>if ($mysqli->query("INSERT into myCity (Name) VALUES ('$city')")) {
<p>printf("%d Row inserted.\n", $mysqli->affected_rows);
<p>} 
<p>
<p>$mysqli->close();
<p>?>
<p>
<p></code></TABLE></div></TABLE><table><tr><td><DIV><a name="AEN100211"></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>mysqli_query($link, "CREATE TEMPORARY TABLE myCity LIKE City");
<p>
<p>$city = "'s Hertogenbosch";
<p>
<p>/* this query will fail, cause we didn't escape $city */
<p>if (!mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
<p>printf("Error: %s\n", mysqli_sqlstate($link));
<p>}
<p>
<p>$city = mysqli_real_escape_string($link, $city);
<p>
<p>/* this query with escaped $city will work */
<p>if (mysqli_query($link, "INSERT into myCity (Name) VALUES ('$city')")) {
<p>printf("%d Row inserted.\n", mysqli_affected_rows($link));
<p>} 
<p>
<p>mysqli_close($link);
<p>?>
<p>
<p></code></TABLE></div></TABLE>
<p>Результат выполнения данного примера:<table><tr><td><PRE>Error: 42000
<p>1 Row inserted.</PRE></TABLE></div>
<p><a href="function.mysqli-real-connect.html">Пред.</a>
<p><a href="index.html">Начало</a>
<p><a href="function.mysqli-real-query.html">След.</a>
<p>mysqli_real_connect
<p><a href="ref.mysqli.html">Уровень выше</a>
<p>mysqli_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>