Developer Documentation
See Release Notes
Long Term Support Release
- Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
- Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
- PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
Differences Between: [Versions 310 and 401] [Versions 311 and 401] [Versions 39 and 401] [Versions 400 and 401] [Versions 401 and 402] [Versions 401 and 403]
Native MSSQL driver.
| 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: | 1105 lines (31 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
Defines 4 classes
ADODB_mssql:: (34 methods):
ServerInfo()
IfNull()
_insertID()
qStr()
_affectedrows()
CreateSequence()
GenID()
SelectLimit()
SQLDate()
BeginTrans()
CommitTrans()
RollbackTrans()
SetTransactionMode()
RowLock()
MetaColumns()
MetaIndexes()
metaForeignKeys()
MetaDatabases()
MetaPrimaryKeys()
MetaTables()
SelectDB()
ErrorMsg()
ErrorNo()
_connect()
_pconnect()
_nconnect()
Prepare()
PrepareSP()
Concat()
Parameter()
UpdateBlob()
_query()
_close()
substr()
Name:: (0 methods):
ADORecordset_mssql:: (11 methods):
__construct()
_initrs()
NextRecordSet()
Fields()
FetchField()
_seek()
MoveNext()
_fetch()
_close()
charMax()
textMax()
ADORecordSet_array_mssql:: (0 methods):
Class: ADODB_mssql - X-Ref
| ServerInfo() X-Ref |
| No description |
| IfNull( $field, $ifNull ) X-Ref |
| No description |
| _insertID($table = '', $column = '') X-Ref |
| No description |
| qStr($s, $magic_quotes=false) X-Ref |
| Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes. An example is $db->qstr("Don't bother"); param: string $s The string to quote param: bool $magic_quotes This param is not used since 5.21.0. return: string Quoted string to be sent back to database |
| _affectedrows() X-Ref |
| No description |
| CreateSequence($seq='adodbseq',$start=1) X-Ref |
| No description |
| GenID($seq='adodbseq',$start=1) X-Ref |
| No description |
| SelectLimit($sql,$nrows=-1,$offset=-1, $inputarr=false,$secs2cache=0) X-Ref |
| No description |
| SQLDate($fmt, $col=false) X-Ref |
| No description |
| BeginTrans() X-Ref |
| No description |
| CommitTrans($ok=true) X-Ref |
| No description |
| RollbackTrans() X-Ref |
| No description |
| SetTransactionMode( $transaction_mode ) X-Ref |
| No description |
| RowLock($tables,$where,$col='1 as adodbignore') X-Ref |
| No description |
| MetaColumns($table, $normalize=true) X-Ref |
| No description |
| MetaIndexes($table,$primary=false, $owner=false) X-Ref |
| No description |
| metaForeignKeys($table, $owner = '', $upper = false, $associative = false) X-Ref |
| No description |
| MetaDatabases() X-Ref |
| No description |
| MetaPrimaryKeys($table, $owner=false) X-Ref |
| No description |
| MetaTables($ttype=false,$showSchema=false,$mask=false) X-Ref |
| No description |
| SelectDB($dbName) X-Ref |
| No description |
| ErrorMsg() X-Ref |
| No description |
| ErrorNo() X-Ref |
| No description |
| _connect($argHostname, $argUsername, $argPassword, $argDatabasename,$newconnect=false) X-Ref |
| No description |
| _pconnect($argHostname, $argUsername, $argPassword, $argDatabasename) X-Ref |
| No description |
| _nconnect($argHostname, $argUsername, $argPassword, $argDatabasename) X-Ref |
| No description |
| Prepare($sql) X-Ref |
| No description |
| PrepareSP($sql,$param=true) X-Ref |
| No description |
| Concat() X-Ref |
| No description |
| Parameter(&$stmt, &$var, $name, $isOutput=false, $maxLen=4000, $type=false) X-Ref |
| No description |
| UpdateBlob($table,$column,$val,$where,$blobtype='BLOB') X-Ref |
| No description |
| _query($sql,$inputarr=false) X-Ref |
| No description |
| _close() X-Ref |
| No description |
| substr($fld,$start,$length=0) X-Ref |
| Returns a substring of a varchar type field The SQL server version varies because the length is mandatory, so we append a reasonable string length param: string $fld The field to sub-string param: int $start The start point param: int $length An optional length return: The SQL text |
Class: ADORecordset_mssql - X-Ref
| __construct($id,$mode=false) X-Ref |
| No description |
| _initrs() X-Ref |
| No description |
| NextRecordSet() X-Ref |
| No description |
| Fields($colname) X-Ref |
| No description |
| FetchField($fieldOffset = -1) X-Ref |
| No description |
| _seek($row) X-Ref |
| No description |
| MoveNext() X-Ref |
| No description |
| _fetch($ignore_fields=false) X-Ref |
| No description |
| _close() X-Ref |
| No description |
| charMax() X-Ref |
| Returns the maximum size of a MetaType C field. Because of the database design, SQL Server places no limits on the size of data inserted Although the actual limit is 2^31-1 bytes. return: int |
| textMax() X-Ref |
| Returns the maximum size of a MetaType X field. Because of the database design, SQL Server places no limits on the size of data inserted Although the actual limit is 2^31-1 bytes. return: int |
Class: ADORecordSet_array_mssql - X-Ref
