Differences

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

--- reference:prepare [2015/12/04 17:29] – mnewnham
+++ v5:reference:connection:prepare [2019/08/09 15:42] (current) – [Usage] Fix execute call per https://github.com/ADOdb/ADOdb/issues/543 dregad
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP info>
-Support for this function is limited. See the feature compatibility matrix
+Support for this function is limited. See the [[v5:database:feature_comparison]].
 </WRAP>
 <WRAP right box 250px>
 == See Also ==
-[[reference:execute()]] for an explanation of parameters
+[[v5:reference:connection:preparesp]]\\
+[[v5:reference:connection:execute]] for an explanation of the bind variables
 == Syntax ==
   mixed prepare (
@@ Line 24: / Line 25: @@
 <code php>
 /*
- * Connection to Oracle database
+* Connection to Oracle database
 */
 $handle = $db->prepare('SELECT * FROM customers WHERE customer_no=?');
-$params = array(0=>100);
+$bindVariables = array(0=>100);
 /*
-* Send an array to execute
+* Execute the prepared statement
 */
-$result = $db->execute(array($handle,$params));
+$result = $db->execute($handle, $bindVariables);
 </code>
 For compatibility purposes, if the database does not support prepared statements, the SQL statement is returned into the ''$handle'' variable. When sent to the ''execute()'' function,  The statement will be parsed to include the variables, and the statement will execute the same as if passed without parameters, and as if the DBMS supported prepared statements.