ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:prepare

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
v5:reference:connection:prepare [2015/12/01 02:56]
mnewnham
v5:reference:connection:prepare [2019/08/09 15:42] (current)
dregad [Usage] Fix execute call per https://github.com/ADOdb/ADOdb/issues/543
Line 2: Line 2:
 ~~NOTOC~~ ~~NOTOC~~
 <WRAP info> <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>
-<WRAP right box>+<WRAP right box 250px> 
 +== See Also == 
 +[[v5:reference:connection:preparesp]]\\ 
 +[[v5:reference:connection:execute]] for an explanation of the bind variables
 == Syntax == == Syntax ==
   mixed prepare (   mixed prepare (
Line 13: Line 16:
  
 ===== Description ===== ===== Description =====
-The function ''prepare()'' prepares an SQL statement. If the statement is valid the function return a resource otherwise it returns false.+The method ''prepare()'' prepares an SQL statement.  
 +  * If the database supports prepared statements and the statement is valid the method return a resource  
 +  * If the database supports prepared statements and the statement is invalid the method returns false
 +  * If the database does not support prepared statements, the method returns a string containing the SQL statement (see below).
  
 ------------------------------------- -------------------------------------
Line 19: Line 25:
 <code php> <code php>
 /* /*
- * Connection to Oracle database+* Connection to Oracle database
 */ */
  
 $handle = $db->prepare('SELECT * FROM customers WHERE customer_no=?'); $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> </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. +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.
  
v5/reference/connection/prepare.1448935015.txt.gz · Last modified: 2017/04/21 11:33 (external edit)