ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:reference_index

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:reference_index [2016/04/22 02:40] – [Table] mnewnhamv5:reference:reference_index [2023/06/04 12:39] (current) – Add anchor link to ADODB_vers dregad
Line 6: Line 6:
 See the [[v5:database:feature_comparison|Feature Comparison Matrix]] See the [[v5:database:feature_comparison|Feature Comparison Matrix]]
 ===== Variables ===== ===== Variables =====
-| [[v5:reference:adodb_countrecs|$ADODB_COUNTRECS]]         | In database drivers that do not support native recordset counting, controls whether to emulate the functionality                       | +| [[v5:reference:adodb_countrecs|$ADODB_COUNTRECS]]                | In database drivers that do not support native recordset counting, controls whether to emulate the functionality                                     | 
-| [[v5:reference:adodb_ansi_padding_off|$ADODB_ANSI_PADDING_OFF]]  | Determines whether to right trim CHAR fields                                                                                           | +| [[v5:reference:adodb_ansi_padding_off|$ADODB_ANSI_PADDING_OFF]]  | Determines whether to right trim CHAR fields                                                                                                         | 
-| [[v5:reference:adodb_cache_dir|$ADODB_CACHE_DIR]]         | If using recordset caching, determines the directory holding the cached data                                                           | +| [[v5:reference:adodb_cache_dir|$ADODB_CACHE_DIR]]                | If using recordset caching, determines the directory holding the cached data                                                                         | 
-| [[v5:reference:adodb_cache_class|$ADODB_CACHE_CLASS]]       | If using recordset caching, specifies a class for cached recordset handling                                                            | +| [[v5:reference:adodb_cache_class|$ADODB_CACHE_CLASS]]            | If using recordset caching, specifies a class for cached recordset handling                                                                          | 
-| [[v5:datetime:adodb_date_locale|$ADODB_DATE_LOCALE]]        | Sets a default date and time format for the ADOdb date/time library                                                                    | +| [[v5:datetime:adodb_date_locale|$ADODB_DATE_LOCALE]]             | Sets a default date and time format for the ADOdb date/time library                                                                                  | 
-| [[v5:reference:adodb_force_type|$ADODB_FORCE_TYPE]]        | Changes the behavior of empty and null field handling when updating or creating records                                                | +| [[v5:reference:adodb_force_type|$ADODB_FORCE_TYPE]]              | Changes the behavior of empty and null field handling when updating or creating records                                                              | 
-| [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]        | Sets the global array type (numeric or associative) for returned recordsets                                                            | +| [[v5:reference:adodb_fetch_mode|$ADODB_FETCH_MODE]]              | Sets the global array type (numeric or associative) for returned recordsets                                                                          | 
-| [[v5:reference:adodb_getone_eof|$ADODB_GETONE_EOF]]        | Sets the returned value if a valid SQL statement does not match any record when the method [[v5:reference:connection:getone|getOne()]] is executed.  | +| [[v5:reference:adodb_getone_eof|$ADODB_GETONE_EOF]]              | Sets the returned value if a valid SQL statement does not match any record when the method [[v5:reference:connection:getone|getOne()]] is executed.  | 
-| [[v5:reference:adodb_lang|$ADODB_LANG]]              | Sets the language for error messages                                                                                                   | +| [[v5:reference:adodb_lang|$ADODB_LANG]]                          | Sets the language for error messages                                                                                                                 | 
-| [[v5:reference:adodb_quote_fieldnames|$ADODB_QUOTE_FIELDNAMES]]  | Quotes, and optionally controls the casing of field name in constructed SQL statements                                                 |+| [[v5:reference:adodb_quote_fieldnames|$ADODB_QUOTE_FIELDNAMES]]  | Quotes, and optionally controls the casing of field name in constructed SQL statements                                                               | 
 +| [[v5:reference:adodb_compat_fetch|$ADODB_COMPAT_FETCH]]          | Determines the behavior of a record buffer if the pointer is advanced beyond EOF                                                                     | 
 +| [[v5:reference:connection:version#adodb_vers|$ADODB_vers]]       | ADOdb version and release date                                                                                                                       |
  
 ===== Constants ===== ===== Constants =====
Line 34: Line 36:
 | [[v5:reference:connection:close|close()]]                         | Closes a database connection                                                        | | [[v5:reference:connection:close|close()]]                         | Closes a database connection                                                        |
  
 +
 +**See Also** [[v5:reference:connection:properties|Public Properties Of The Connection]]
  
 ==== Working With Cached Recordsets ==== ==== Working With Cached Recordsets ====
Line 63: Line 67:
 ==== Prepared Statements ==== ==== Prepared Statements ====
  
-| [[v5:reference:connection:inparameter|inParameter()]]    | Sets an input parameter to a stored procedure                    | +| [[v5:reference:connection:inparameter|inParameter()]]            | Sets an input parameter to a stored procedure                    | 
-| [[v5:reference:connection:outparameter|outParameter()]]  | Receives an output parameter from a stored procedure             | +| [[v5:reference:connection:outparameter|outParameter()]]          | Receives an output parameter from a stored procedure             | 
-| [[v5:reference:connection:param|param()]]                | Returns a database specific parameter placeholder                | +| [[v5:reference:connection:param|param()]]                        | Returns a database specific parameter placeholder                | 
-| [[v5:reference:connection:prepare|prepare()]]            | Prepares an SQL statement and returns a handle to use            | +| [[v5:reference:connection:prepare|prepare()]]                    | Prepares an SQL statement and returns a handle to use            | 
-| [[v5:reference:connection:preparesp|prepareSp()]]        | Access a stored procedure and returns a handle to the procedure  |+| [[v5:reference:connection:preparesp|prepareSp()]]                | Access a stored procedure and returns a handle to the procedure  | 
 +| [[v5:reference:connection:releasestatement|releaseStatement()]]  | Releases a previously prepared statement                         |
  
  
Line 144: Line 149:
 | [[v5:reference:connection:fnexecute|fnExecute and fnCacheExecute]]     || A reference to a function that overrides the execute function  | | [[v5:reference:connection:fnexecute|fnExecute and fnCacheExecute]]     || A reference to a function that overrides the execute function  |
    
 +==== Information ====
 +
 +| [[v5:reference:connection:version|version()]] | ADOdb version number |
 +| [[v5:reference:connection:serverinfo|serverInfo()]] | Database server version and information |
 +
  
-====== The Recordset Object ====== +===== The Recordset Object =====
 ==== Returns one field ==== ==== Returns one field ====
 |[[v5:reference:recordset:fields|fields()]]|Returns a single field in a single row of the current recordset| |[[v5:reference:recordset:fields|fields()]]|Returns a single field in a single row of the current recordset|
Line 166: Line 176:
 |[[v5:reference:connection:getarray|getArray()]]|Returns a complete recordset as an array| |[[v5:reference:connection:getarray|getArray()]]|Returns a complete recordset as an array|
 |[[v5:reference:connection:getassoc|getAssoc()]]|Returns an associate key/value array, with other options| |[[v5:reference:connection:getassoc|getAssoc()]]|Returns an associate key/value array, with other options|
-|[[v5:reference:connection:getarray|getRows()]]|This function is a pseudonym for [[v5:reference:connection:getarray|getArray()]], for ADO compatibility|+|[[v5:reference:connection:getarray|getRows()]]|This function is a pseudonym for [[v5:reference:connection:getarray|getArray()]]|
 |[[v5:reference:connection:getrandrow|getRandRow()]]|Returns a random record from a recordset| |[[v5:reference:connection:getrandrow|getRandRow()]]|Returns a random record from a recordset|
 ==== Scrolling ==== ==== Scrolling ====
 | [[v5:reference:recordset:move|move()]]                       || Move to the n<sup>th</sup> record of a recordset                                | | [[v5:reference:recordset:move|move()]]                       || Move to the n<sup>th</sup> record of a recordset                                |
-| [[v5:reference:connection:movenext|moveNext()]]               || Moves the cursor to the next record of the recordset from the current position  |+| [[v5:reference:recordset:movenext|moveNext()]]               || Moves the cursor to the next record of the recordset from the current position  |
 | [[v5:reference:recordset:movefirst|moveFirst()]]             || Moves the cursor to the first record of the recordset                           | | [[v5:reference:recordset:movefirst|moveFirst()]]             || Moves the cursor to the first record of the recordset                           |
-| [[v5:reference:connection:movelast|moveLast()]]               || Moves to the last record of a recordset                                         |+| [[v5:reference:recordset:movelast|moveLast()]]               || Moves to the last record of a recordset                                         |
 | [[v5:reference:connection:currentrow|AbsolutePosition()]]     || absolutePosition() is a pseudonym for currentRow()                              | | [[v5:reference:connection:currentrow|AbsolutePosition()]]     || absolutePosition() is a pseudonym for currentRow()                              |
 | [[v5:reference:connection:currentrow|currentRow()]]           || Returns the current row number of a recordset                                   | | [[v5:reference:connection:currentrow|currentRow()]]           || Returns the current row number of a recordset                                   |
Line 178: Line 188:
    
 ==== Menu generation ==== ==== Menu generation ====
-| [[v5:reference:recordset:getmenu|getMenu()]]    | Creates a string containing a basic HTML select box                                                  | +| [[v5:reference:recordset:getmenu|getMenu()]]    | Creates a string containing a single or multi select HTML select box                                              | 
-| [[v5:reference:recordset:getmenu2|getMenu2()]]  | Creates a string containing a basic HTML select box with alternate comparison criteria to getMenu()  | +| [[v5:reference:recordset:getmenu2|getMenu2()]]  | (deprecated) Creates a string containing a basic HTML select box with alternate comparison criteria to getMenu()  | 
-| [[v5:reference:recordset:getmenu3|getMenu3()]]  | Creates a string containing a grouped HTML muilti-select box                                         |+| [[v5:reference:recordset:getmenu3|getMenu3()]]  | Creates a string containing a grouped (optgroup)  HTML single or muilti-select box                                |
  
 ==== Dates ==== ==== Dates ====
v5/reference/reference_index.txt · Last modified: 2023/06/04 12:39 by dregad