ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== qStr ======
~~NOTOC~~
<WRAP right box>
== See Also ==
[[v5:reference:connection:addq|addQ()]]\\
== Syntax ==
  string qStr(
         string $unquotedText
         )
</WRAP>
==== Description ====
The function ''qStr()'' takes an input string, and allows it to be:

  - Wrapped in single quotes.The value can then be used, for example in an SQL statement.
  - Have quotes inside the string escaped in a way that is appropriate for the database. This is done wherever possible using PHP driver functions e.g. [[http://php.net/manual/en/mysqli.real-escape-string.php|MySQL real_escape_string]].

------------------------------
==== Usage ====
<code php>
$string = "Patrick O'Reilly";

$SQL = "SELECT * FROM names WHERE name='$string'";

$result = $db->execute($SQL);

/*
 * Execution fails  due to mismatched ` characters
*/

$qString = $db->qStr($string);

/*
 * function returns 'Patrick O\'Reilly' (The resulting string is database-specific)
*/

$SQL = "SELECT * FROM names WHERE name=$qString";

$result = $db->execute($SQL);

/*
 * Execution succeeds
 */
</code>