Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
  • Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.

Differences Between: [Versions 310 and 402] [Versions 311 and 402] [Versions 39 and 402] [Versions 400 and 402] [Versions 401 and 402]

Helper functions. Less commonly used functions are placed here to reduce size of adodb.inc.php.

Copyright: 2000-2013 John Lim
Copyright: 2014 Damien Regad, Mark Newnham and the ADOdb community
License: BSD-3-Clause
License: LGPL-2.1-or-later
File Size: 1364 lines (39 kb)
Included or required: 10 times
Referenced: 0 times
Includes or requires: 0 files

Defines 19 functions


Functions that are not part of a class:

adodb_strip_order_by($sql)   X-Ref
Strip the ORDER BY clause from the outer SELECT.

param: string $sql
return: string

adodb_probetypes($array,&$types,$probe=8)   X-Ref
No description

adodb_transpose(&$arr, &$newarr, &$hdr, $fobjs)   X-Ref
No description

_adodb_replace($zthis, $table, $fieldArray, $keyCol, $autoQuote, $has_autoinc)   X-Ref
No description

_adodb_getmenu($zthis, $name,$defstr='',$blank1stItem=true,$multiple=false,$size=0, $selectAttr='',$compareFields0=true)   X-Ref
No description

_adodb_getmenu_gp($zthis, $name,$defstr='',$blank1stItem=true,$multiple=false,$size=0, $selectAttr='',$compareFields0=true)   X-Ref
No description

_adodb_getmenu_select($name, $defstr = '', $blank1stItem = true,$multiple = false, $size = 0, $selectAttr = '')   X-Ref
Generate the opening SELECT tag for getmenu functions.

ADOdb internal function, used by _adodb_getmenu() and _adodb_getmenu_gp().

param: string $name
param: string $defstr
param: bool   $blank1stItem
param: bool   $multiple
param: int    $size
param: string $selectAttr
return: string HTML

_adodb_getmenu_option($defstr, $compare, $value, $display)   X-Ref
Print the OPTION tags for getmenu functions.

ADOdb internal function, used by _adodb_getmenu() and _adodb_getmenu_gp().

param: string $defstr  Default values
param: string $compare Value to compare against defaults
param: string $value   Ready-to-print `value="xxx"` (or empty) string
param: string $display Display value
return: string HTML

_adodb_getcount($zthis, $sql,$inputarr=false,$secs2cache=0)   X-Ref
No description

_adodb_pageexecute_all_rows($zthis, $sql, $nrows, $page,$inputarr=false, $secs2cache=0)   X-Ref
No description

_adodb_pageexecute_no_last_page($zthis, $sql, $nrows, $page, $inputarr=false, $secs2cache=0)   X-Ref
No description

_adodb_quote_fieldname($zthis, $fieldName)   X-Ref
Performs case conversion and quoting of the given field name.

See Global variable $ADODB_QUOTE_FIELDNAMES.

param: ADOConnection $zthis
param: string $fieldName
return: string Quoted field name

_adodb_getupdatesql(&$zthis, $rs, $arrFields, $forceUpdate=false, $force=2)   X-Ref
No description

adodb_key_exists($key, $arr,$force=2)   X-Ref
No description

_adodb_getinsertsql(&$zthis, $rs, $arrFields, $force=2)   X-Ref
There is a special case of this function for the oci8 driver.
The proper way to handle an insert w/ a blob in oracle requires
a returning clause with bind variables and a descriptor blob.


_adodb_column_sql_oci8(&$zthis,$action, $type, $fname, $fnameq, $arrFields)   X-Ref
This private method is used to help construct
the update/sql which is generated by GetInsertSQL and GetUpdateSQL.
It handles the string construction of 1 column -> sql string based on
the column type.  We want to do 'safe' handling of BLOBs

param: string the type of sql we are trying to create
param: string column data type from the db::MetaType() method
param: string the column name
param: array the column value
return: string

_adodb_column_sql(&$zthis, $action, $type, $fname, $fnameq, $arrFields, $recurse=true)   X-Ref
No description

_adodb_debug_execute($zthis, $sql, $inputarr)   X-Ref
Replaces standard _execute when debug mode is enabled

param: ADOConnection   $zthis    An ADOConnection object
param: string|string[] $sql      A string or array of SQL statements
param: string[]|null   $inputarr An optional array of bind parameters
return: handle|void A handle to the executed query

_adodb_backtrace($printOrArr=true, $maximumDepth=9999, $elementsToIgnore=0, $ishtml=null)   X-Ref
Pretty print the debug_backtrace function

param: string[]|bool $printOrArr       Whether to print the result directly or return the result
param: int           $maximumDepth     The maximum depth of the array to traverse
param: int           $elementsToIgnore The backtrace array indexes to ignore
param: null|bool     $ishtml           True if we are in a CGI environment, false for CLI,
return: string Formatted backtrace