Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:qstr [2016/01/17 00:28] – ↷ Page moved from v5:reference:qstr to v5:reference:connection:qstr mnewnham
+++ v5:reference:connection:qstr [2021/01/25 02:59] (current) – mnewnham
@@ Line 3: / Line 3: @@
 <WRAP right box>
 == See Also ==
-[[reference:addQ()]]\\
+[[v5:reference:connection:addq|addQ()]]\\
 == Syntax ==
   string qStr(
-         string $unquoted,
+         string $unquotedText
-         optional bool $dontFixQuotes=false
          )
 </WRAP>
@@ Line 14: / Line 13: @@
   - 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]]. The second parameter, ''$dontFixQuotes'' stops any internal quoting happening, This parameter was mostly used in older versions of PHP when the now removed ''magic_quotes'' parameter was enabled, and the 2 methods were in conflict.
+  - 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]].
 ------------------------------
@@ Line 23: / Line 22: @@
 $SQL = "SELECT * FROM names WHERE name='$string'";
-$result = $db->Execute($SQL);
+$result = $db->execute($SQL);
 /*
@@ Line 37: / Line 36: @@
 $SQL = "SELECT * FROM names WHERE name=$qString";
-$result = $db->Execute($SQL);
+$result = $db->execute($SQL);
 /*
- * Execution Succeeds
+ * Execution succeeds
  */
 </code>