Database Abstraction Layer for PHP https://www.adodb.org/dokuwiki/ 2026-05-16T22:59:40+00:00 https://www.adodb.org/dokuwiki/ https://www.adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2021-01-25T02:00:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:addq&rev=1611540029&do=diff addQ See Also qStr Syntax string addQ( string $unquotedText ) Description The function addQ() takes an input string, and applies database specific string quoting. Unlike the method qStr, no pre or post quoting is applied. This method is particularly useful when used with text/html 2023-01-15T19:31:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:adodb_recordset_empty&rev=1673811083&do=diff The ADORecordSet_empty Object Description The ADORecordSet_empty Object is the result of the execution of an SQL statement through an ADOdbConnection object. The object is returned as a lightweight placeholder if the statement succeeds, and is of a type that does not return a recordset. Its existence evaluates to true if returned from an text/html 2016-02-28T02:33:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:adodb_recordset&rev=1456626799&do=diff The ADORecordSet_array Object Description The ADORecordSet_array Object is the result of the execution of an SQL statement through an ADOdbConnection object. The Object ADORecordSet_array Object ( [databaseType] => array [_array] => Array ( [0] => Array ( [Order ID] => 30 [Employee ID] => 9 [Customer ID] => 27 [Order Date] => 2006-01-15 00:00:00 [Sh… text/html 2020-12-08T09:39:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:adonewconnection&rev=1607420340&do=diff adoNewConnection Syntax mixed adoNewConnection( optional string $driverType='' ) Description The function adoNewConnection, in the simple form, loads the database driver specific files as specified by the string $driverType. The driver name must match the name of a file text/html 2022-11-06T22:20:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:affected_rows&rev=1667773248&do=diff affected_rows Syntax mixed affected_rows() Description The function affected_rows() returns the number of rows affected (add/change/delete) by the last SQL statement executed, or false if the database does not support the function or the statement is not an update. See the driver documentation for support. Most multi-user databases support the command. Because the method returns text/html 2026-03-11T10:53:48+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:autoexecute&rev=1773226428&do=diff autoExecute See Also $ADODB_QUOTE_FIELDNAMES Syntax ADORecordSet_empty|false autoExecute( string $tables, string[] $arrFields, string $mode, optional mixed $where=false optional bool $forceUpdate=false ) Description The autoExecute() function can automatically generate and execute INSERT and UPDATE statements on a given table. It is a wrapper for text/html 2018-06-11T08:15:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:begintrans&rev=1528704951&do=diff beginTrans Syntax void beginTrans() Descriptions The function beginTrans() starts a new transaction. This function is not part of the smart transaction set. ---------- Usage $conn->beginTrans(); $ok = $conn->execute($sql); if ($ok) $ok = $conn->execute($sql2); if (!$ok) $conn->rollbackTrans(); else $conn->commitTrans(); text/html 2016-01-17T00:11:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:binddate&rev=1452989503&do=diff bindDate syntax string bindDate(){ float $timestamp } Description The function bindDate() accepts a Unix Timestamp value, and returns a database-specific date string suitable for embedding into bind statements. The returned value differs from one database to another. text/html 2016-01-17T02:12:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:bindtimestamp&rev=1452996779&do=diff bindTimeStamp syntax string bindTimeStamp(){ mixed $timestamp } Description The function bindTimeStamp() accepts a number of different types of parameters, and returns a database-specific dateTime string. This can then be used in bind statements. The returned value differs from one database to another. text/html 2026-03-20T00:27:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:blobdecode&rev=1773966479&do=diff blobDecode Syntax mixed blobDecode( string $blob ) Description The function blobDecode() decodes a blob field and returns the value of the field or false if the function fails. ---------- Usage $SQL = "SELECT blob_field FROM table"; $blob = $db->blobDecode($db->getOne($SQL)); file_put_contents('/temp/stored.jpg',$blob); text/html 2016-01-17T02:15:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:blobencode&rev=1452996901&do=diff blobEncode Support for this function is limited. See the Feature Comparison Matrix Syntax mixed blobEncode( string $blob ) Description The function blobEncode() encodes a value using the database specific encoding method and returns the encoded value or false if the function fails. Once inserted, the value cab be inserted into a blob field in the database text/html 2025-06-01T11:21:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cacheexecute&rev=1748776875&do=diff cacheExecute Use of $ADODB_FETCH_MODE and setFetchMode() is incompatible with use of cached result sets as the results of the cached query are stored using the original fetch mode settings. syntax mixed cacheExecute { mixed $cacheTimeInSeconds, optional mixed $sql optional string[] $bindvars } text/html 2025-06-01T11:21:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cacheflush&rev=1748776876&do=diff cacheFlush Syntax void function cacheFlush( optional mixed $sql=false, optional mixed $bindVariables=false ) Description The function cacheFlush() destroys a cached result set described EXACTLY like the combination of the $sql statement and, if neccessary the array of bind variables, or, if the $sql parameter is empty, text/html 2025-06-01T11:21:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cachegetall&rev=1748776876&do=diff cacheGetAll syntax mixed cacheGetAll { mixed $cacheSeconds, optional mixed $sql=false, optional string[] $bindvars=false } Description Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by the first parameter. If an unexpired cache result is not found, the query is cached for the specified period. text/html 2025-06-01T11:21:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cachegetassoc&rev=1748776877&do=diff cacheGetAssoc syntax mixed cacheGetAssoc ( mixed $cacheSeconds optional string $sql=falsse optional string[] $bindvars=false optional bool $forceArray=false optional bool $first2Cols=false ) Description text/html 2025-06-01T11:21:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cachegetcol&rev=1748776877&do=diff cacheGetCol syntax mixed cacheGetCol { mixed $cacheSeconds optional mixed $sql=ffalse optional string[] $bindvars=false optional bool $trimString=false } Description Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by the first parameter. If an unexpired cache result is not found, the query is cached for the specified period. text/html 2025-06-01T11:21:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cachegetone&rev=1748776878&do=diff cacheGetOne See Also $ADODB_GETONE_EOF Syntax mixed cacheGetOne( mixed $cacheSeconds, optional string $sql=false ) Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by the first parameter. If an unexpired cache result is not found, the query is cached for the specified period. text/html 2025-06-01T11:21:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cachegetrow&rev=1748776878&do=diff cacheGetRow syntax mixed cacheGetRow ( mixed $cacheSeconds, optional mixed $sql=false, optional string[] $bindvars=false ) Description Cache functions search for the results of an executed query in the query cache. The results of a query have an expiration time specified by the first parameter. If an unexpired cache result is not found, the query is cached for the specified period. text/html 2022-06-25T10:23:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cachepageexecute&rev=1656152590&do=diff cachePageExecute Syntax obj cachePageExecute( int $secs2cache, string $sql int $rowsPerPage int $pageNumber optional mixed $bindVars=false ) See Also * pageExecute() * atFirstPage() * atLastPage() Description The method cachePageExecute() will select the supplied text/html 2025-06-01T11:21:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:cacheselectlimit&rev=1748776878&do=diff cacheSelectLimit The order of the $rowsToReturn and $startOffset variables may not match the order specified in the underlying PHP function syntax mixed cacheSelectLimit( mixed $cacheSeconds, optional string $sql=-1, optional int $rowsToReturn=-1, optional int $startOffset=-1, optional string[] $bindvars=false } text/html 2016-02-28T16:27:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:charmax&rev=1456676854&do=diff charMax See Also ADODB_STRINGMAX_NOTSET ADODB_STRINGMAX_NOLIMIT textMax() Syntax int charMax() Description The method charMax() returns an integer, describing the maximum length of data that can be inserted into a field with metaType C. Usage /* * Assume MySQL database */ $i = $db->charMax(); /* * Returns: 255; */ text/html 2021-08-23T23:29:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:close&rev=1629761348&do=diff close Syntax void function close() This function closes the Database Connection or the RecordSet. * ADOConnection::close() shuts down the database connection object, which cannot be re-established for the remainder of the script. * ADORecordSet::close() text/html 2021-04-26T12:02:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:committrans&rev=1619438537&do=diff commitTrans Syntax bool commitTrans( optional bool $ok = true ) Descriptions The function commitTrans() commits a granular transaction. This function is not part of the smart transaction set, you must verify that all transactional statements within the transaction scope have completed correctly. text/html 2025-06-01T11:21:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:completetrans&rev=1748776879&do=diff completeTrans See Also startTrans() failTrans() Managing Transaction With ADOdb Syntax bool completeTrans( optional bool $completeTrans=true ) Description The method completeTrans() completes a smart transaction. If the value of parameter $completeTrans is set to false, a rollback is forced. text/html 2016-01-29T20:34:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:concat&rev=1454099697&do=diff concat string concat( string $inputString ) Description The function concat() takes an variable list of strings, and returns a database-specific string of concatenated values. It is important to recognize the difference between concatenating a database field or a string when using the method in an SQL statement text/html 2023-05-07T08:37:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:connect&rev=1683448666&do=diff connect See Also The Connection Matrix Syntax bool connect( optional string $parameter1 = '', optional string $parameter2 = '', optional string $parameter3 = '', optional string $parameter4 = '', optional bool $forceNewConnection=false ) text/html 2016-01-16T23:45:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:createsequence&rev=1452987938&do=diff createSequence See Also Feature Comparison Matrix Syntax bool createSequence( optional string $sequenceName='adodbseq', optional int $startNumber ) Description The function createSequence() creates an auto-incrementing number device. If the database supports it, it uses native sequence handling routines, otherwise it emulates the functionality using a table and an auto-incrementing numbers. text/html 2016-01-16T23:49:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:currentrow&rev=1452988193&do=diff currentRow Syntax int currentRow() Description The function currentRow() Returns the current row number of the recordset. If past end-of-file, the value is set to 0, the same as row zero. Check the EOF flag instead. ---------- Usage /* * Connection to DB2 sample database */ $SQL = "SELECT * FROM act" $recordset = $db->execute($SQL); /* * Go to the End Of File */ $recordset->moveLast; Check the current row $i = $result->currentRow(); print $i; /* * Prints: 17 */ $i = $result->EOF;… text/html 2016-04-10T22:18:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:day&rev=1460326702&do=diff day From Version 5.21.0-beta-2 See Also month() year() Syntax string day( string $fieldName, ) Description The method day() is a helper routine that simplifies the creation of an oft-used SQL statement to obtain just the day of a specified date/time field as a 2 digit number (DD). If the value of the day is less than 10, it is zero padded. This allows for correct sorting. text/html 2025-07-11T01:22:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:dbdate&rev=1752196938&do=diff dbDate syntax string dbDate( string|float|object $timestamp, optional bool $isFieldValue = false ) Description The function dbDate() accepts a either a Unix timestamp value or a PHP DateTime Object, and returns a database-specific date string. This can then be used in SQL statements. The returned value differs from one database to another. text/html 2016-01-16T23:31:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:dbtimestamp&rev=1452987098&do=diff dbTimeStamp syntax string dbTimeStamp(){ mixed $timestamp } Description The function dbTimeStamp() accepts a number of different types of parameters, and returns a database-specific dateTime string. This can then be used in SQL statements. The returned value differs from one database to another. text/html 2016-04-22T01:47:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:dow&rev=1461289656&do=diff dow From Version 5.21.0-beta-2 See Also day() month() year() Syntax string dow( string $fieldName, ) Description The method dow() is a routine that provides a portable Day-Of-Week number from 0 to 6, starting on a Sunday. Normal day of week functions use varying start days, and offset numbers. For more information on the subject, see text/html 2016-01-16T23:38:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:dropsequence&rev=1452987519&do=diff dropSequence bool dropSequence ( optional string $sequenceName='adodbseq' } Description The function dropSequence() drops a previously created sequence. It returns true or false based on the success of the action ---------- Usage /** * Connection assumed */ $success = $db->dropSequence('my_sequence'); text/html 2026-02-23T00:30:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:errormsg&rev=1771806607&do=diff errorMsg See Also errorNo() Syntax string errorMsg() Description The function errorMsg returns an unfriendly message about the last known error. The message may contain database specific notices. ---------- Usage /* * IBM DB2 database connection assumed */ /* * An invalid SQL statement with mis-matched quotes */ $SQL = 'SELECT * FROM ACT WHERE ACT_DESC = "1234'; /* * Execute the statement, suppressing any errors */ $desc = @$db->getOne($SQL); /* * Get the last error message… text/html 2026-02-23T01:56:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:errorno&rev=1771811801&do=diff errorNo See Also errorMsg() Syntax string ADOConnection::errorNo() Description The method errorNo returns an unfriendly error code about the last known error. Note that depending on the DBMS, the message may also contain string identifiers. If there is currently no error, the function returns an empty string text/html 2023-01-15T19:32:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:execute&rev=1673811138&do=diff execute syntax mixed execute { mixed $sql optional string[] $bindvars } 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 an text/html 2025-06-01T11:21:19+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:failtrans&rev=1748776879&do=diff failTrans See Also startTrans() completeTrans() Syntax void failTrans() Description The method failTrans() forces a roll back of a smart transaction. The method can be called anywhere inside a transaction scope, but the rollback actually occurs at the point where completeTrans() text/html 2025-06-01T11:21:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:fetchinto&rev=1748776880&do=diff fetchInto Syntax bool fetchInto( &$recordArray ) Description The PEAR compatible function fetchInto() retrieves a recordset into an array. The array must be passed by reference into the method. ---------- Usage /* * database connection assumed */ $SQL = "SELECT * FROM act"; $result = $db->execute($SQL); while (!$result->EOF){ $arr = array(); $result->fetchInto(&$arr); print_r($arr); } text/html 2016-01-17T01:44:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:fnexecute&rev=1452995054&do=diff fnExecute & fnCacheExecute Syntax string $fnExecute string $fnCacheExecute Description $fnExecute provides a handle to a function that overrides the execute() function. The function should accept 3 parameters * An object containing the connection text/html 2016-03-20T01:11:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:genid&rev=1458436280&do=diff genId int genId( optional string $sequenceName='adodbseq', optional int $startPoint=1 ) Description The function genId() is a useful, portable way of generation sequence numbers. This is not the same as having an auto-increment row on a table text/html 2019-05-08T14:41:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getall&rev=1557326471&do=diff getAll This function and getArray() produce the same output. The functions may be merged in future releases. syntax mixed getAll { mixed $sql optional string[] $bindvars } Description The function executes a statement and returns a the entire recordset in an array or false if the statement execution fails. If no records match the provided SQL statement, an empty array is returned. text/html 2019-05-08T14:40:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getarray&rev=1557326457&do=diff getArray The functions getArray() and getAll() produce the same output. The functions may be merged in future releases. syntax mixed getArray ( mixed $sql optional string[] $bindvars=false ) Description The function executes a statement and returns a the entire recordset in an array or false if the statement execution fails. If no records match the provided SQL statement, an empty array is returned. text/html 2017-05-08T23:09:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getassoc&rev=1494284997&do=diff getAssoc syntax mixed getAssoc ( string $sql optional string[] $bindvars=false optional bool $forceArray=false optional bool $first2Cols=false ) Description The function executes a statement and returns all of the returned rows in an array or false if the statement execution fails, or if only 1 column is requested in the SQL statement. If no records match the provided SQL statement, an empty array is returned. text/html 2021-03-08T17:09:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getcharset&rev=1615223371&do=diff getCharSet Support for this command is limited to MySQL and Postgres databases. Syntax string|false function getCharSet() Description The function getCharSet() retrieves the current client side character set, or false if it can't be determined. text/html 2019-05-08T14:41:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getcol&rev=1557326481&do=diff getCol syntax mixed getCol { mixed $sql optional string[] $bindvars optional bool $trimString } Description The function executes a statement and returns the first column of each row of the the entire recordset in an array or false if the statement execution fails. If no records match the provided SQL statement, an empty array is returned. text/html 2021-01-18T02:58:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getcustommetatypes&rev=1610938704&do=diff getCustomMetaTypes From Version 5.22 See Also setCustomMetaType Syntax array getCustomMetaTypes() Description The function getCustomMetaTypes() returns an array of defined custom meta types Example Using an added custom geometery type print_r($db->getCustomMetaTypes()); /* * Prints array ( 'P' => array('actual'=>255, 'dictionary'=>'POINT', 'handler'=>false, 'callback'=>false ) ) */ text/html 2020-01-05T11:32:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getfetchmode&rev=1578223921&do=diff getFetchMode Syntax From 5.21.0 int getFetchMode() See Also setFetchMode $ADODB_FETCH_MODE Returns the current recordset fetch mode Return Value NameValueDescriptionADODB_FETCH_DEFAULT0The recordset is returned in the default provided by the PHP driver. Use of this value is not recommended if writing cross-database applications text/html 2021-01-25T02:16:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getinsertsql&rev=1611541019&do=diff getInsertSql See Also $ADODB_QUOTE_FIELDNAMES $ADODB_FORCE_TYPE AutoExecute() Syntax string getInsertSql( mixed $recordSet, string[] $fieldArray, optional bool $placeholder=false, optional bool $forceType=null ) Description The function getInsertSql() takes a set of parameters and returns an SQL statement that can be used to insert a record in the database. It can automatically apply any necessary database specific quoting to character fields. text/html 2025-10-06T14:38:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getmedian&rev=1759761539&do=diff getMedian Syntax mixed getMedian { string $table string $column optional string $where } The method getMedian() does not return a true arithmetic median but simply returns the value of a specific column in a specified table closest to the middle of a record set, as specified by WHERE criteria. text/html 2021-03-11T19:15:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getone&rev=1615490153&do=diff getOne Syntax mixed getOne( string $sql, optional string[] $bindvars ) Executes the SQL and returns the first column of the first row. The recordset and remaining rows are discarded for you automatically. If an error occurs, either false or null is returned depending on the value of text/html 2016-01-16T22:49:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getrandrow&rev=1452984597&do=diff getRandRow syntax mixed getRandRow ( mixed $sql optional string[] $bindvars=false ) Description The function executes the function getArray() and returns a single random row from the returned recordset. See that function for more information about the passed parameters. text/html 2025-06-01T11:21:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getrow&rev=1748776881&do=diff getRow syntax mixed getRow ( mixed $sql optional string[] $bindvars ) Description The function executes a statement and returns the first row of the recordset in an array or false if the statement execution fails. If no records match the provided SQL statement, an empty array is returned. text/html 2025-06-01T11:21:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getrowassoc&rev=1748776880&do=diff getRowAssoc Using this function when the fetch mode is set to ADODB_FETCH_ASSOC may produce unpredictable results Currently, after the first call to getRowAssoc, any changes to $upperCase have no effect Syntax mixed getRowAssoc( optional bool $upperCase=true ) text/html 2023-09-26T15:43:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:getupdatesql&rev=1695742995&do=diff getUpdateSql See Also $ADODB_QUOTE_FIELDNAMES Syntax string getUpdateSql( obj $result, string[] $fieldArray, optional bool $forceUpdate=false, optional bool $placeHolder=false, optional bool $forceType=null ) Description The function text/html 2025-06-01T11:21:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:hasfailedtrans&rev=1748776881&do=diff hasFailedTrans See Also Managing Transactions With ADOdb Syntax bool hasFailedTrans() Description The function hasFailedTrans() reports if a smart transaction has failed, or if the failTrans() method has been called. The method must be called before completeTrans(), otherwise it will not report correctly. text/html 2016-01-16T22:34:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:ifnull&rev=1452983692&do=diff ifNull string ifNull( string $fieldToCheck, mixed $replacementValue ) Description The function ifNull() returns a database-specific string providing the means to replace a null value with a specified replacement. If the value in the database is not null, the value is not updated. The two parameters are: text/html 2016-01-16T22:54:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:ignoreerrors&rev=1452984899&do=diff ignoreErrors This page needs expansion to describe all usages of this function Syntax mixed function ignoreErrors( mixed $override ) Description The function ignoreErrors() provides a way of overriding certain aspects of error handling within ADOdb. There are 2 different behaviours based on what parameters are passed. text/html 2016-01-16T21:13:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:index&rev=1452978816&do=diff Connection Reference Manual Pages in this namespace: * addQ * adoNewConnection * affected_rows * autoExecute * beginTrans * bindDate * bindTimeStamp * blobDecode * blobEncode * cacheExecute * cacheFlush * cacheGetAll * cacheGetAssoc * cacheGetCol * cacheGetOne * cacheGetRow * cachePageExecute * cacheSelectLimit * charMax * close * commitTrans * completeTrans * concat * connect * createSequence * currentRow * day * dbDate * dbTimeStamp * dow * dropSequence * er… text/html 2018-06-17T09:24:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:inparameter&rev=1529227484&do=diff inParameter Syntax void inParameter( resource &$statementt, string &$var, string $name, int $maxLen=4000, mixed $type=false ) Description The function inParameter() sets an input parameter for a stored procedure. The $statement variable must be a handle to a stored procedure accessed via the text/html 2023-06-20T07:40:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:insert_id&rev=1687246803&do=diff insert_Id Syntax mixed insert_Id( optional string $tableName = '', optional string $columnName = '' ) Description The function insert_Id() returns the last auto-increment number of any table, generated by an insert on a table with an auto-increment column. If no such insertion has occurred or the database does not support the operation, the function returns text/html 2016-01-16T23:12:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:isconnected&rev=1452985920&do=diff isConnected Syntax bool isConnected() This function tests if a database connection has been established or not. You can use this to provide a controlled response to connection failure. The result of this function is either false, or the connectionId of the database if connected (==true) text/html 2016-01-17T01:32:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:lastpageno&rev=1452994328&do=diff lastPageNo Syntax int lastPageNo() ---------- Description The method lastPageNo() returns the last page number in a paged record set. Usage $p = $db->lastPageNo(); text/html 2026-02-08T09:49:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:length&rev=1770544190&do=diff length Syntax string length(string $columnName) Description The method length() returns a database-specific SQL statement that retrieves the length of data in a field. This happens even when the field is defined as a fixed-length CHAR field, because the field's contents is trimmed before the length of the data is obtained. text/html 2023-12-29T21:46:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:metaerror&rev=1703886401&do=diff metaError Syntax int metaError( optional int $errorNumber ) Description The function metaError() converts a database-specific error number into a portable number. This is done by querying the driver error-handling function and converting the error. text/html 2016-01-17T00:51:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:metaerrormsg&rev=1452991893&do=diff metaErrorMsg See also $ADODB_LANG Syntax string metaErrorMsg( int $errorNumber ) Description The function metaErrorMsg() converts a portable error number, provided by metaError() into a portable, language specific message Usage /* * Connection to MySQL database assumed */ /* * Send MySQL error 1004, 'DB_ERROR_CANNOT_CREATE' */ $m = $db->MetaError(1004); /* * value of $m is -15, send it to metaErrorMessage() */ $s = $db->metaErrorMessage($m); print $s /* * returns 'can… text/html 2022-08-22T10:50:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:month&rev=1661165409&do=diff month From Version 5.21.0-beta-2 See Also day() year() Syntax string month( string $fieldName, ) Description The method month() is a helper routine that simplifies the creation of an oft-used SQL statement to obtain just the month of a specified date/time field as a 2 digit number (MM). If the value of the month is less than 10, it is zero padded. This allows for correct sorting. text/html 2016-01-16T23:01:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:nconnect&rev=1452985298&do=diff nConnect See Also The Connection Matrix Syntax mixed nConnect( optional string $parameter1 = '', optional string $parameter2 = '', optional string $parameter3 = '', optional string $parameter4 = '', ) Description The function nConnect() text/html 2025-08-23T16:21:38+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:offsetdate&rev=1755966098&do=diff offsetDate Syntax string|bool ADOConnection::offsetDate( float $offset optional string $isoDate ) Description The function offsetDate() returns a string with the native SQL functions to calculate future and past dates based on $isoDate text/html 2016-01-17T00:45:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:outparameter&rev=1452991546&do=diff outParameter Syntax void outParameter( resource &$statement, string &$var, string $name, int $maxLen=4000, mixed $type=false ) Description The function outParameter() receives an output parameter from a stored procedure. The $statement variable must be a handle to a stored procedure accessed via the text/html 2022-06-25T09:20:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:pageexecute&rev=1656148843&do=diff pageExecute Syntax obj pageExecute( string $sql int $rowsPerPage int $pageNumber optional mixed $bindVars=false ) See Also * cachePageExecute() * atFirstPage() * atLastPage() Description The method pageExecute() will select the supplied $pageNumber from a recordset, given that it is paginated in pages of text/html 2021-02-26T00:35:08+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:param&rev=1614299708&do=diff param See Also addQ() Syntax string param( string $name ) Description The function param returns a database-specific placeholder for a prepared query statement. This method is used with bind variable SQL statement execution, to produce injection resistant code. On RDBMS with positional (numbered) query parameters such as PostgreSQL, calling text/html 2016-01-16T23:00:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:pconnect&rev=1452985222&do=diff pConnect See Also The Connection Matrix Syntax mixed pConnect( optional string $parameter1 = '', optional string $parameter2 = '', optional string $parameter3 = '', optional string $parameter4 = '', ) Description The function pConnect() text/html 2016-01-17T00:15:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:po_recordcount&rev=1452989707&do=diff po_recordCount See Also Feature Comparison Matrix ADODB_COUNTRECS Syntax int po_recordCount() The function po_recordCount() return the number of records returned by the last select statement. This portable function executes a SELECT COUNT statement based on the last SQL statement to determine the number of records if the database does not natively support row counting in a select statement. text/html 2019-08-09T13:42:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:prepare&rev=1565358125&do=diff prepare Support for this function is limited. See the Feature Comparison Matrix. See Also prepareSp execute for an explanation of the bind variables Syntax mixed prepare ( string $sql ) Description The method prepare() prepares an SQL statement. * If the database supports prepared statements and the statement is valid the method return a resource text/html 2016-11-02T11:45:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:preparesp&rev=1478087113&do=diff prepareSp Support for this function is limited. See the Feature Comparison Matrix. See Also prepare Syntax mixed prepareSp ( string $procedureName ) Description The function prepareSP() accesses an existing stored procedure. If the stored procedure is valid the function return a resource otherwise it returns false. text/html 2021-03-13T00:11:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:properties&rev=1615594267&do=diff Public Properties Of The Connection The Connection Object exposes numerous properties that can be used inside SQL statements to create portable statements. For example, to create a portable SQL statement that will return a column in uppercase no matter which database is in use, use the text/html 2021-01-25T01:59:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:qstr&rev=1611539977&do=diff qStr See Also addQ() Syntax string qStr( string $unquotedText ) Description The function qStr() takes an input string, and allows it to be: * Wrapped in single quotes.The value can then be used, for example in an SQL statement. * Have quotes inside the string escaped in a way that is appropriate for the database. This is done wherever possible using PHP driver functions e.g. text/html 2017-05-17T17:10:45+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:quote&rev=1495041045&do=diff Quote See Also qStr() addQ() The method quote() is a synonym for qStr(). text/html 2018-05-03T12:39:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:recordcount&rev=1525351183&do=diff recordCount See Also Feature Comparison Matrix Syntax int recordCount() The recordCount() method returns the number of records retrieved by the last select statement, or -1 if the database driver does not support the operation. If $ADODB_COUNTRECS is set to true before a query is executed, then the number of records will be retrieved, even if the function has to be emulated by issuing a text/html 2022-01-16T17:10:25+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:releasestatement&rev=1642353025&do=diff releaseStatement Support for this function is limited; it is currently only implemented in the oci8 driver. See the Feature Comparison Matrix. See Also prepare Syntax bool releaseStatement ( mixed $stmt ) Description The releaseStatement() method releases a previously prepared statement, freeing all associated database server resources. text/html 2024-03-04T01:44:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:replace&rev=1709516697&do=diff replace This function does no row-locking, so it is possible that the same record could be inserted twice by two programs. Use in multi-user environments is not recommended. syntax int replace( string $table, mixed $dataFields, mixed $keyColumn, optional bool $autoQuote = false, optional bool $primaryKeyIsAuto=false ) text/html 2016-01-17T00:13:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:rollbacktrans&rev=1452989604&do=diff rollbackTrans Syntax void rollbackTrans() Description The function rollbackTrans() forces a roll back of a granular transaction. Usage /* * Assume database connection */ $db->startTrans(); /* * some reason to rollback transaction */ if ($someError) $db->rollbackTrans(); else $db->commitTrans() text/html 2016-01-17T01:18:24+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:rowlock&rev=1452993504&do=diff rowLock Information regarding whether row and column locking support is only available by reading the driver source code. This needs updating Not all databases support row locking, some implementations of this function enable column locking. See the driver guide for more details text/html 2016-03-17T00:29:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:rsfilter&rev=1458174560&do=diff rsFilter The file rsfilter.inc.php must be manually included in the script Syntax obj rsFilter ( obj &$recordSet, string $functionName ) Description The method rsFilter() applies a callback function given by the string $functionName text/html 2016-01-17T00:19:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:selectdb&rev=1452989952&do=diff selectDb Support for this function is limited. Check the driver documentation to see if it supported Syntax bool selectDb( string $database ) Description In products that allow a database-less connection, or that allow switching databases, this function allows switching. text/html 2023-07-25T10:55:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:selectlimit&rev=1690282510&do=diff selectLimit The order of the $rowsToReturn and $startOffset variables may not match the order specified in the underlying PHP function syntax mixed selectLimit( string $sql, optional int $rowsToReturn=-1, optional int $startOffset=-1, optional string[] $bindvars=false } text/html 2026-02-18T14:40:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:serverinfo&rev=1771425655&do=diff serverInfo Syntax string[] serverInfo() Description The function returns an array with general information about the database server. The array contains 2 mandatory keys, and may also contain additional database-specific information. If writing portable applications, use driver-specific branches if accessing these additional keys. text/html 2022-07-13T01:18:05+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setcharset&rev=1657675085&do=diff setCharSet Support for this command is limited to MySQL and Postgres databases, and as of ADOdb V5.21, this method is deprecated for MySQL databases, use setConnectionParameter() instead. Because Postgres allows the character set to be modified in real-time, it can be used at any point in the script after a connection has been established. text/html 2026-01-30T03:21:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setconnectionparameter&rev=1769743318&do=diff setConnectionParameter Syntax From ADOdb Version 5.21.0 void setConnectionParameter( string $parameterName, mixed $parameterValue ) Description The function setConnectionParameter() permits the setting of parameters before a database connection is established. This allows the specified parameters to be passed to the text/html 2025-07-19T00:39:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setcustommetatype&rev=1752885592&do=diff setCustomMetaType From Version 5.22 See Also getCustomMetaTypes Syntax bool setCustomMetaType( string $metaType, string $actualType, string $dictionayType, mixed $handleAsType=false, mixed $callBack=false ) Description text/html 2016-01-17T00:39:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setdatelocale&rev=1452991174&do=diff setDateLocale void setDateLocale( optional string $locale = 'En' ) Description The method setDateLocal() changes the SQL connection locale to a specified locale. This is used to get the date formats written depending on the client locale. Usage text/html 2020-01-05T11:30:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:setfetchmode&rev=1578223814&do=diff setFetchMode If you have multiple connection objects, and want to have different fetch modes for each connection, then use SetFetchMode. Once this function is called for a connection object, that connection object will ignore the global variable $ADODB_FETCH_MODE text/html 2018-06-11T08:23:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:settransactionmode&rev=1528705417&do=diff setTransactionMode See Also metaTransaction() Syntax void setTransactionMode( string $mode ) Description SetTransactionMode allows you to pass in the transaction mode to use for all subsequent transactions. Note: if you have persistent connections and using mssql or mysql, you might have to explicitly reset your transaction mode at the beginning of each page request. text/html 2016-04-22T01:08:10+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:sqldate&rev=1461287290&do=diff sqlDate Syntax string sqlDate( string $dateFormat, optional string $dateColumn ) Description When the function sqlDate() is passed a string based on SQL date/time formats, it returns a database-independent date string, either using the system date, or if passed a string containing a datetime column in a table, a string derived from that column. text/html 2025-06-01T11:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:starttrans&rev=1748776882&do=diff startTrans See Also completeTrans() failTrans() Syntax void startTrans( optional string $monitorFn ) Description The function startTrans() begins a smart transaction. The optional monitor function is called when a transaction fails. This monitor function can be used to control the behaviour of a transaction if it fails. The default for this function if not set is text/html 2016-04-10T21:42:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:substr&rev=1460324570&do=diff substr From Version 5.21.0-beta-2 Syntax string substr( string $fieldName, int $startPoint, optional int $length ) Description The method substr() creates an SQL statement that returns the substring of a specified string field. text/html 2016-02-28T16:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:textmax&rev=1456676655&do=diff textMax See Also ADODB_STRINGMAX_NOTSET ADODB_STRINGMAX_NOLIMIT charMax() Syntax int textMax() Description The method textMax() returns an integer, describing the maximum length of data that can be inserted into a field with metaType X. Usage /* * Assume MySQL database */ $i = $db->textMax(); /* * Returns: 4294967295; */ text/html 2016-04-14T13:56:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:transcnt&rev=1460642202&do=diff transCnt Syntax int ADOconnection::transCnt Description The value of $db->transCnt returns the current transaction nesting level. If no transaction has been started, the value is zero. For granular transaction handling: * The value is always 1 when a transaction has been started, as nested transactions are not permitted. text/html 2016-04-14T13:45:46+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:transoff&rev=1460641546&do=diff transOff Syntax int ADOconnection::transOff Description Setting the value of $db->transOff temporarily disables transaction startup. For granular transaction handling: * The value is automatically set to 1 after the first beginTrans() statement, which prevents transaction scopes being nested. text/html 2016-01-17T00:34:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:unixdate&rev=1452990841&do=diff unixDate Use of 64 bit processors and later versions of PHP have effectively made this function obsolete. It may be removed in later releases of ADOdb syntax int dbObject::unixDate(){ float $timestamp } Description The static text/html 2020-01-05T18:21:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:unixtimestamp&rev=1578248467&do=diff unixTimeStamp Use of 64 bit processors and later versions of PHP have effectively made this function obsolete. It may be removed in later releases of ADOdb syntax float dbObject::unixDate(){ string $timestamp } Description The static text/html 2016-01-17T00:58:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:updateblob&rev=1452992315&do=diff updateBlob Support for this function is limited. See the Feature Comparison Matrix Syntax mixed updateBlob( string $tableName, string $columnName, string $blobValue, string $whereStatement, optional string $type='BLOB' ) Description The function updateBlob() text/html 2026-03-20T00:47:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:updateblobfile&rev=1773967661&do=diff updateBlobFile Support for this function is limited. See the Feature Comparison Matrix Syntax mixed updateBlobFile( string $tableName, string $columnName, string $fileName, string $whereStatement, optional string $type='BLOB' ) Description The function text/html 2016-01-17T00:59:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:updateclob&rev=1452992357&do=diff updateClob Support for this function is limited. See the Feature Comparison Matrix Syntax mixed updateClob( string $tableName, string $columnName, string $clobValue, string $whereStatement,) Description The function updateClob() updates a column specified by text/html 2016-01-17T01:15:12+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:userdate&rev=1452993312&do=diff userDate syntax string userDate(){ int $timestamp, optional string $dateFormat='YYYY-MM-DD', optional bool $useGmt=false } Description The function userDate() accepts a user provided Unix Timestamp value, and uses the date/time functionality of the database server to return a date string . For more information about formatting options, see the PHP date format. The optional 3rd argument forces the date to be adjusted to GMT. text/html 2016-01-17T00:49:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:usertimestamp&rev=1452991758&do=diff userTimeStamp syntax string userTimeStamp(){ int $timestamp, optional string $dateFormat='Y-m-d H:i:s' } Description The function userTimeStamp() accepts a user provided Unix Timestamp value, and uses the date/time functionality of the database server to return a date/time string . For more information about formatting options, see the PHP date format. text/html 2023-06-04T10:40:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:version&rev=1685875257&do=diff version Syntax string[] version() Description The function returns the ADOdb version number. $ADODB_vers This global variable should be considered as a constant. It contains the ADOdb version and release date in the following format: vX.Y.Z[-suffix] {date|Unreleased} text/html 2016-04-10T21:56:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adodb.org/dokuwiki/doku.php?id=v5:reference:connection:year&rev=1460325362&do=diff year From Version 5.21.0-beta-2 See Also day() month() Syntax string year( string $fieldName, ) Description The method year() is a helper routine that simplifies the creation of an oft-used SQL statement to obtain just the year of a specified date/time field as a 4 digit number (YYYY).