MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]
Packages:
MDB2


Classes:
MDB2_BufferedResult_sqlsrv
MDB2_Driver_Datatype_sqlsrv
MDB2_Driver_Function_sqlsrv
MDB2_Driver_Manager_sqlsrv
MDB2_Driver_Native_sqlsrv
MDB2_Driver_Reverse_sqlsrv
MDB2_Driver_sqlsrv
MDB2_Result_sqlsrv
MDB2_Statement_sqlsrv
Files:
sqlsrv.php
sqlsrv.php
sqlsrv.php
sqlsrv.php
sqlsrv.php
sqlsrv.php

Element index for package MDB2

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ i ] [ l ] [ m ] [ n ] [ r ] [ s ] [ t ] [ u ] [ v ] [ _ ]

_

_add_flag
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::_add_flag()
    Adds a string to the flags array if the flag is not yet in there
  • if there is no flag present the array is created
_baseConvertResult
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::_baseConvertResult()
    general type conversion method
_doConnect
in file sqlsrv.php, method MDB2_Driver_sqlsrv::_doConnect()
    do the grunt work of the connect
_doQuery
in file sqlsrv.php, method MDB2_Driver_sqlsrv::_doQuery()
    Execute a query
_getAdvancedFKOptions
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::_getAdvancedFKOptions()
    Return the FOREIGN KEY query section dealing with non-standard options as MATCH, INITIALLY DEFERRED, ON UPDATE, ...
_getBLOBDeclaration
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::_getBLOBDeclaration()
    Obtain DBMS specific SQL code portion needed to declare an binary large object type field to be used in statements like CREATE TABLE.
_getCLOBDeclaration
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::_getCLOBDeclaration()
    Obtain DBMS specific SQL code portion needed to declare an character large object type field to be used in statements like CREATE TABLE.
_getIntegerDeclaration
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::_getIntegerDeclaration()
    Obtain DBMS specific SQL code portion needed to declare an integer type field to be used in statements like CREATE TABLE.
_mapNativeDatatype
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::_mapNativeDatatype()
    Maps a native array description of a field to a MDB2 datatype and length
_modifyQuery
in file sqlsrv.php, method MDB2_Driver_sqlsrv::_modifyQuery()
    Changes a query string for various DBMS specific reasons
_mssql_field_flags
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::_mssql_field_flags()
    Get a column's flags
_quoteBLOB
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::_quoteBLOB()
    Convert a text value into a DBMS specific format that is suitable to compose query statements.
__construct
in file sqlsrv.php, method MDB2_Driver_sqlsrv::__construct()
    Constructor
__construct
in file sqlsrv.php, method MDB2_Result_sqlsrv::__construct()
    Constructor
top

a

alterDatabase
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::alterDatabase()
    alter an existing database
alterTable
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::alterTable()
    alter an existing table
array_to_obj
in file sqlsrv.php, method MDB2_Result_sqlsrv::array_to_obj()
    Skip the first row of a result set.
top

b

beginTransaction
in file sqlsrv.php, method MDB2_Driver_sqlsrv::beginTransaction()
    Start a transaction or set a savepoint.
top

c

$connection
in file sqlsrv.php, variable MDB2_Driver_sqlsrv::$connection
checkTable
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::checkTable()
commit
in file sqlsrv.php, method MDB2_Driver_sqlsrv::commit()
    Commit the database changes done during a transaction that is in progress or release a savepoint. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after committing the pending changes.
concat
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::concat()
    Returns string to concatenate two or more string parameters
connect
in file sqlsrv.php, method MDB2_Driver_sqlsrv::connect()
    Connect to the database
createConstraint
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::createConstraint()
    create a constraint on a table
createDatabase
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::createDatabase()
    create a new database
createSequence
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::createSequence()
    create sequence
createTable
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::createTable()
    create a new table
top

d

databaseExists
in file sqlsrv.php, method MDB2_Driver_sqlsrv::databaseExists()
    check if given database name exists?
disconnect
in file sqlsrv.php, method MDB2_Driver_sqlsrv::disconnect()
    Log out and disconnect from the database.
dropDatabase
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::dropDatabase()
    drop an existing database
dropIndex
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::dropIndex()
    drop existing index
dropSequence
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::dropSequence()
    This function drops an existing sequence
dropTable
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::dropTable()
    drop an existing table
top

e

errorInfo
in file sqlsrv.php, method MDB2_Driver_sqlsrv::errorInfo()
    This method is used to collect information about an error
escapePattern
in file sqlsrv.php, method MDB2_Driver_sqlsrv::escapePattern()
    Quotes pattern (% and _) characters in a string)
executeStoredProc
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::executeStoredProc()
    Execute a stored procedure and return any results
top

f

fetchRow
in file sqlsrv.php, method MDB2_Result_sqlsrv::fetchRow()
    Fetch a row and insert the data into an existing array.
free
in file sqlsrv.php, method MDB2_Result_sqlsrv::free()
    Free the internal resources associated with $result.
top

g

getServerVersion
in file sqlsrv.php, method MDB2_Driver_sqlsrv::getServerVersion()
    return version information about the server
getTableConstraintDefinition
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::getTableConstraintDefinition()
    Get the structure of a constraint into an array
getTableFieldDefinition
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::getTableFieldDefinition()
    Get the structure of a field into an array
getTableIndexDefinition
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::getTableIndexDefinition()
    Get the structure of an index into an array
getTableStatus
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::getTableStatus()
    New OpenX method
getTriggerDefinition
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::getTriggerDefinition()
    Get the structure of a trigger into an array
getTypeDeclaration
in file sqlsrv.php, method MDB2_Driver_Datatype_sqlsrv::getTypeDeclaration()
    Obtain DBMS specific SQL code portion needed to declare an text type field to be used in statements like CREATE TABLE.
guid
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::guid()
    Returns global unique identifier
top

i

$identifier_quoting
in file sqlsrv.php, variable MDB2_Driver_sqlsrv::$identifier_quoting
top

l

lastInsertID
in file sqlsrv.php, method MDB2_Driver_sqlsrv::lastInsertID()
    Returns the autoincrement ID if supported or $id or fetches the current ID in a sequence called: $table.(empty($field) ? '' : '_'.$field)
length
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::length()
    return string to call a function to get the length of a string expression
listDatabases
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listDatabases()
    list all databases
listFunctions
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listFunctions()
    list all functions in the current database
listSequences
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listSequences()
    list all sequences in the current database
listTableConstraints
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listTableConstraints()
    list all constraints in a table
listTableFields
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listTableFields()
    list all fields in a table in the current database
listTableIndexes
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listTableIndexes()
    list all indexes in a table
listTables
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listTables()
    list all tables in the current database
listTableTriggers
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listTableTriggers()
    list all triggers in the database that reference a given table
listUsers
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listUsers()
    list all users
listViews
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::listViews()
    list all views in the current database
top

m

MDB2_BufferedResult_sqlsrv
in file sqlsrv.php, class MDB2_BufferedResult_sqlsrv
    MDB2 MSSQL Server buffered result driver
MDB2_Driver_Datatype_sqlsrv
in file sqlsrv.php, class MDB2_Driver_Datatype_sqlsrv
    MDB2 MS SQL driver
MDB2_Driver_Function_sqlsrv
in file sqlsrv.php, class MDB2_Driver_Function_sqlsrv
    MDB2 MSSQL driver for the function modules
MDB2_Driver_Manager_sqlsrv
in file sqlsrv.php, class MDB2_Driver_Manager_sqlsrv
    MDB2 MSSQL driver for the management modules
MDB2_Driver_Native_sqlsrv
in file sqlsrv.php, class MDB2_Driver_Native_sqlsrv
    MDB2 MSSQL driver for the native module
MDB2_Driver_Reverse_sqlsrv
in file sqlsrv.php, class MDB2_Driver_Reverse_sqlsrv
    MDB2 MSSQL driver for the schema reverse engineering module
MDB2_Driver_sqlsrv
in file sqlsrv.php, class MDB2_Driver_sqlsrv
    MDB2 MSSQL Server (native) driver
MDB2_Result_sqlsrv
in file sqlsrv.php, class MDB2_Result_sqlsrv
    MDB2 MSSQL Server result driver
MDB2_Statement_sqlsrv
in file sqlsrv.php, class MDB2_Statement_sqlsrv
    MDB2 MSSQL Server statement driver
top

n

nextID
in file sqlsrv.php, method MDB2_Driver_sqlsrv::nextID()
    Returns the next free id of a sequence
nextResult
in file sqlsrv.php, method MDB2_Result_sqlsrv::nextResult()
    Move the internal result pointer to the next available result
now
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::now()
    Return string to call a variable with the current timestamp inside an SQL statement
numCols
in file sqlsrv.php, method MDB2_Result_sqlsrv::numCols()
    Count the number of columns returned by the DBMS in a query result.
numRows
in file sqlsrv.php, method MDB2_Result_sqlsrv::numRows()
    Returns the number of rows in a result object
top

r

rollback
in file sqlsrv.php, method MDB2_Driver_sqlsrv::rollback()
    Cancel any database changes done during a transaction or since a specific savepoint that is in progress. This function may only be called when auto-committing is disabled, otherwise it will fail. Therefore, a new transaction is implicitly started after canceling the pending changes.
rowCount
in file sqlsrv.php, method MDB2_Result_sqlsrv::rowCount()
    Returns the actual row number that was last fetched (count from 0)
top

s

$string_quoting
in file sqlsrv.php, variable MDB2_Driver_sqlsrv::$string_quoting
sqlsrv.php
procedural page sqlsrv.php
sqlsrv.php
procedural page sqlsrv.php
sqlsrv.php
procedural page sqlsrv.php
sqlsrv.php
procedural page sqlsrv.php
sqlsrv.php
procedural page sqlsrv.php
sqlsrv.php
procedural page sqlsrv.php
seek
in file sqlsrv.php, method MDB2_Result_sqlsrv::seek()
    Seek to a specific row in a result set
standaloneQuery
in file sqlsrv.php, method MDB2_Driver_sqlsrv::standaloneQuery()
    execute a query as DBA
substring
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::substring()
    return string to call a function to get a substring inside an SQL statement
top

t

tableInfo
in file sqlsrv.php, method MDB2_Driver_Reverse_sqlsrv::tableInfo()
    Returns information about a table or a result set
truncateTable
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::truncateTable()
    Truncate an existing table (if the TRUNCATE TABLE syntax is not supported, it falls back to a DELETE FROM TABLE query)
top

u

unixtimestamp
in file sqlsrv.php, method MDB2_Driver_Function_sqlsrv::unixtimestamp()
    return string to call a function to get the unix timestamp from a iso timestamp
top

v

vacuum
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::vacuum()
    Optimize (vacuum) all the tables in the db (or only the specified table) and optionally run ANALYZE.
valid
in file sqlsrv.php, method MDB2_BufferedResult_sqlsrv::valid()
    Check if the end of the result set has been reached
validateDatabaseName
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::validateDatabaseName()
    New OPENX method to check database name according to specifications:
validateTableName
in file sqlsrv.php, method MDB2_Driver_Manager_sqlsrv::validateTableName()
    New OPENX method to check table name according to specifications: http://msdn.microsoft.com/en-us/library/aa258255(SQL.80).aspx
top
Documentation generated on Mon, 11 Mar 2019 15:51:27 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.