Search moodle.org's
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: Name  - X-Ref

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