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 [2025/07/11 01:46] – [Manipulating Dates & Times] mnewnhamv5:reference:reference_index [2026/02/06 22:06] (current) – [Table] mnewnham
Line 83: Line 83:
 | [[v5:reference:connection:getinsertsql|getInsertSQL()]]  | Creates a database-specific SQL INSERT statement based on supplied parameters   | | [[v5:reference:connection:getinsertsql|getInsertSQL()]]  | Creates a database-specific SQL INSERT statement based on supplied parameters   |
 | [[v5:reference:connection:ifnull|ifNull()]]              | Replaces a null value with a specified replacement                              | | [[v5:reference:connection:ifnull|ifNull()]]              | Replaces a null value with a specified replacement                              |
 +| [[v5:reference:connection:length|length()]]              | Creates database-specific SQL to obtain the length of data in a column          |
 | [[v5:reference:connection:qstr|quote()]]                 | Is a pseudonym for the function [[v5:reference:connection:qstr]]                | | [[v5:reference:connection:qstr|quote()]]                 | Is a pseudonym for the function [[v5:reference:connection:qstr]]                |
 | [[v5:reference:connection:qstr|qStr()]]                  | Appropriately quotes strings with ' characters for insertion into the database  | | [[v5:reference:connection:qstr|qStr()]]                  | Appropriately quotes strings with ' characters for insertion into the database  |
Line 130: Line 131:
 | [[v5:reference:connection:unixdate|unixDate()]]               | Uses ADODb to create date strings without times              |DateTime| | [[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: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|
v5/reference/reference_index.1752191183.txt.gz · Last modified: by mnewnham