Differences

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

--- v5:reference:connection:param [2020/01/24 23:48] – [Description] document param(false) call to reset counter dregad
+++ v5:reference:connection:param [2020/01/25 00:33] – [Usage] dregad
@@ Line 18: / Line 18: @@
 ------------------------------
 ===== Usage =====
+This is an example of how to use param() to build SQL queries:
 <code php>
-/*
+$sql1 = 'SELECT * FROM accounts WHERE '
-* Connection to Oracle database
+    . 'name = '  . $db->param('account') . ' AND '
-*/
+    . 'total = ' . $db->param('amount');
-print $db->param('account');
-/*
+$db->param(false); // Reset param count
-* prints ':account'
+$sql2 = 'SELECT * FROM accounts WHERE id = ' . $db->param('id');
-*/
 </code>
-<code php>
-/*
+See below for the code's output with various database drivers.
-* Connection to IBM DB2 database
-*/
+==== MySQL, IBM DB2 ====
-print $db->param('account');
+<code>
-/*
+$sql1: SELECT * FROM accounts WHERE name = ? AND total = ?
-* prints ?
+$sql2: SELECT * FROM accounts WHERE id = ?
-*/
 </code>
-<code php>
-/*
+==== Oracle (oci8) ====
-* Connection to Postgres database
+<code>
-*/
+$sql1: SELECT * FROM accounts WHERE name = :account AND total = :amount
-print $db->param('account');
+$sql2: SELECT * FROM accounts WHERE id = :id"
-/*
-* prints $1
-*/
 </code>
+==== PostgreSQL ====
+<code>
+$sql1: SELECT * FROM accounts WHERE name = $1 AND total = $2
+$sql2: SELECT * FROM accounts WHERE id = $1
+</code>