Differences

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

--- reference:param [2015/08/21 20:58] – created mnewnham
+++ v5:reference:connection:param [2020/01/24 23:48] – [Description] document param(false) call to reset counter dregad
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP right box>
+==See Also==
+[[v5:reference:connection:addq|addQ()]]\\
 == Syntax ==
   string param(
-         string $name,
+         string $name
-         optional type='C'
          )
 </WRAP>
 ===== Description =====
 The function param returns a database-specific placeholder for a prepared query statement.
+This method is used with [[v5:userguide:learn_bind:bind_vars|bind variable SQL statement execution]], to produce injection resistant code.
+On RDBMS with positional (numbered) query parameters such as PostgreSQL, calling ''param(false)'' will reset the parameter counter, allowing to start building a new query.
+------------------------------
 ===== Usage =====
 <code php>
@@ Line 29: / Line 36: @@
 */
 </code>
+<code php>
+/*
+* Connection to Postgres database
+*/
+print $db->param('account');
+/*
+* prints $1
+*/
+</code>