ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:execute

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
v5:reference:execute [2016/01/17 00:36] – ↷ Links adapted because of a move operation mnewnhamv5:reference:connection:execute [2023/01/15 20:32] (current) mnewnham
Line 10: Line 10:
  
 ===== Description ===== ===== Description =====
-This method executes any provided SQL statement. If the SQL statement should return a recordset, e.g. ''SELECT'' statements, it returns a handle to a recordset or false if the statement execution fails. If the statement does not return a recordset, such as in ''INSERT'' or ''UPDATE'' statement, it returns true on success or false on failure. +This method executes any provided SQL statement. If the SQL statement should return a recordset, e.g. ''SELECT'' statements, it returns a handle to an [[v5:reference:connection:adodb_recordset|ADOrecordset_array]] object or false if the statement execution fails. If the statement does not return a recordset, such as in ''INSERT'' or ''UPDATE'' statement, it returns a handle to an [[v5:reference:connection:adodb_recordset_empty|ADOrecordset_empty]] object on success or false on failure. 
  
  
-The presentation of the returned data can be modified by the variables [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]  and [[v5:reference:adodb_assoc_case|$ADODB_ASSOC_CASE]] and the function [[v5:reference:connection:setfetchmode|setFetchMode()]].+The presentation of the returned data can be modified by the [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]] variable, the [[v5:reference:adodb_assoc_case|ADODB_ASSOC_CASE]] constant and the [[v5:reference:connection:setfetchmode|setFetchMode()]] function.
 ===== Parameters ===== ===== Parameters =====
 ==== Parameter 1 ==== ==== Parameter 1 ====
Line 20: Line 20:
   - A string containing a complete SQL statement. ''SELECT * FROM ACT''   - A string containing a complete SQL statement. ''SELECT * FROM ACT''
   - A string containing an SQL statement with bind variables, ''SELECT * FROM ACT WHERE empno>:emp'', in which case the second parameter is an array containing the bind variables.    - A string containing an SQL statement with bind variables, ''SELECT * FROM ACT WHERE empno>:emp'', in which case the second parameter is an array containing the bind variables. 
-  - A array of SQL Statements. This is only available to internal functions.+
 ==== Parameter 2 ==== ==== Parameter 2 ====
 If set, contains an array of bind variables. If set, contains an array of bind variables.
Line 26: Line 26:
 ==== Result ===== ==== Result =====
 If the execution succeeds, it returns a recordset. This recordset can be used by functions such as [[v5:reference:connection:getupdatesql|getUpdateSQL()]] or [[v5:reference:recordset:fetchrow|fetchRow()]]. If the execution succeeds, it returns a recordset. This recordset can be used by functions such as [[v5:reference:connection:getupdatesql|getUpdateSQL()]] or [[v5:reference:recordset:fetchrow|fetchRow()]].
-if the execution fails, it returns false. You can access errors using [[v5:reference:errormsg|errorMsg()]].+if the execution fails, it returns false. You can access errors using [[v5:reference:connection:errormsg|errorMsg()]].
 ==== Usage ==== ==== Usage ====
 <code php> <code php>
v5/reference/connection/execute.1452987397.txt.gz · Last modified: 2017/04/21 11:35 (external edit)