ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace: • Reference Manual
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 [2021/12/18 21:04] – [Table] Add link to ADODB_COMPAT_FETCH mnewnhamv5:reference:reference_index [2025/07/18 03:36] (current) – [Manipulating Dates & Times] mnewnham
Line 16: Line 16:
 | [[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]]          | Deterines the behavior of a record buffer if the pointer is advanced beyond EOF                                                                      |+| [[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 66: 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 118: Line 120:
  
 ==== Manipulating Dates & Times ==== ==== Manipulating Dates & Times ====
-| [[v5:reference:connection:binddate|bindDate()]]               | Creates a portable date field, for use in bind statements        | +^Function^Description^Returns^ 
-| [[v5:reference:connection:bindtimestamp|bindTimeStamp()]]     | Creates a portable timestamp field, for use in bind statements   | +| [[v5:reference:connection:binddate|bindDate()]]               | Creates a portable date field, for use in bind statements        |DateTime| 
-| [[v5:reference:connection:dbdate|dbDate()]]                   | Creates a portable date field, for use in SQL statements         | +| [[v5:reference:connection:bindtimestamp|bindTimeStamp()]]     | Creates a portable timestamp field, for use in bind statements   || 
-| [[v5:reference:connection:dbtimestamp|dbTimeStamp()]]         | Creates a portable timestamp field, for use in SQL statements    | +| [[v5:reference:connection:dbdate|dbDate()]]                   | Returns a date formatted based on the setDateLocae() setting         |Date| 
-| [[v5:reference:connection:offsetdate|offsetDate()]]           | Creates a portable date offset field, for use in SQL statements  | +| [[v5:reference:connection:dbtimestamp|dbTimeStamp()]]         | Returns a date/time formatted based on the setDateLocale() setting    DateTime|| 
-| [[v5:reference:connection:setdatelocale|setDateLocale()]]                   | Changes the SQL connection to a specified Locale                 | +| [[v5:reference:connection:offsetdate|offsetDate()]]           | Creates a statement to calculate a past or future date |Embeddable SQL| 
-| [[v5:reference:connection:sqldate|sqlDate()]]            | Returns a portably-formatted date string from a timestamp database column       | +| [[v5:reference:connection:setdatelocale|setDateLocale()]]     | Sets a specified Date Format for a Locale              |Embeddable SQL| 
-| [[v5:reference:connection:unixdate|unixDate()]]               | Uses the database connection to create date strings              | +| [[v5:reference:connection:sqldate|sqlDate()]]            | Returns a portably-formatted date string from a timestamp database column       |Embeddable SQL| 
-| [[v5:reference:connection:unixtimestamp|unixTimeStamp()]]     | Uses the database connection to create date/time strings         |+| [[v5:reference:connection:unixdate|unixDate()]]               | Uses ADODb to create date strings without times              |DateTime| 
 +| [[v5:reference:connection:unixtimestamp|unixTimeStamp()]]     | Uses ADOdb to create date/time strings         |DateTime| 
 +| [[v5:reference:connection:day|day()]]            | Returns portable shortcut SQL to extract the day portion of a date  |Embeddable SQL| 
 +| [[v5:reference:connection:month|month()]]            | Returns portable shortcut SQL to extract the month portion of a date  |Embeddable SQL| 
 +| [[v5:reference:connection:year|year()]]            | Returns portable shortcut SQL to extract the year portion of a date  |Embeddable SQL|
 ==== Row Management ==== ==== Row Management ====
 |[[v5:reference:connection:affected_rows|affected_rows()]]|Returns the number of rows affected by the last operation| |[[v5:reference:connection:affected_rows|affected_rows()]]|Returns the number of rows affected by the last operation|
Line 147: Line 153:
 | [[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 ====
  
-====== The Recordset Object ====== +| [[v5:reference:connection:version|version()]] | ADOdb version number | 
 +| [[v5:reference:connection:serverinfo|serverInfo()]] | Database server version and information | 
 + 
 + 
 +===== 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|
v5/reference/reference_index.1639857872.txt.gz · Last modified: by mnewnham