Tutorial Extension
1.0.0
SellerDeck Extensions - Tutorial Extension
|
Inherits CDataBase.
Public Member Functions | |
QuoteTable ($sTableName) | |
![]() | |
__construct ($aConnectionDetails, $sDatabaseID) | |
GetDatabaseID () | |
GetDataBases () | |
GetDBUser () | |
GetDBAuthType () | |
Expression ($sExpression) | |
QuoteValue ($vData) | |
QuoteTable ($vTableName) | |
QuoteColumn ($vData) | |
QuoteCompundColumn ($vUnquotedElement) | |
GetDB () | |
GetLastQuery () | |
SQL ($sQuery, $nReturnType=\PDO::FETCH_ASSOC) | |
Insert ($sTable, $aValues, $bAutoID=true, $sIDColumn=null) | |
Update ($sTable, $aValues, $aWhere=[[1, '', '']]) | |
Select ($sTable, $vColumns="*", $aWhere=[], $aOthers=[], $nReturnType=\PDO::FETCH_ASSOC) | |
CompileWhere ($aWhere=[], $aBoolOp=BOOP_OP_AND) | |
CompileJoinOn ($aJoinOn=[]) | |
Protected Member Functions | |
BasicInsert ($sTable, $aValues) | |
Sanitize ($sData) | |
CompileSelectSql ($aQuery=[]) | |
BoolValue ($bData) | |
![]() | |
Quote ($sData, $sQuoteBegin, $sQuoteEnd) | |
Sanitize ($sData) | |
QuoteArray ($aUnquotedArray, $bValue=true) | |
QuoteUpdateArray ($aUnquotedArray) | |
QuoteValueArray ($aUnquotedArray) | |
QuoteColumnArray ($aUnquotedArray) | |
QuoteValueList ($aUnquotedArray, $sSeparator=", ") | |
QuoteColumnList ($aUnquotedArray, $sSeparator=", ") | |
BasicInsert ($sTable, $aValues) | |
CompileSelectSql ($aQuery=[]) | |
CompileWhereElement ($aValue=[]) | |
IsElementFormat ($aValue) | |
CompileLimit ($vLimit) | |
CompileJoin ($aJoins) | |
ConcatenateJoins ($aJoinDirections, $aJoinTables, $aJoinOns) | |
CompileGroupBy ($aGroupByList) | |
CompileOrderBy ($aOrderByList) | |
BoolValue ($bData) | |
Protected Attributes | |
$m_sColumnQuoteBegin = "[" | |
$m_sColumnQuoteEnd = "]" | |
$m_aCatalogTables | |
![]() | |
$m_oDB = null | |
$m_sDataBaseID = DB_CATALOG | |
$m_sDBAuthType = "DB" | |
$m_sDBUser = "dbo" | |
$m_aDataBases = [] | |
$m_sColumnQuoteBegin = '`' | |
$m_sColumnQuoteEnd = '`' | |
$m_sValueQuoteBegin = "'" | |
$m_sValueQuoteEnd = "'" | |
$m_sNullValue = "NULL" | |
$m_sLastQuery = "" | |
Definition at line 14 of file CDataBaseSqlServer.php.
|
protected |
BasicInsert - Generates and runs Basic INSERT expression
protected
string | $sTable | Table name |
array | $aValues | Array of (DB Column => Value) pairs |
Definition at line 162 of file CDataBaseSqlServer.php.
|
protected |
BoolValue - Converts Boolean to appropriate value depending on driver
protected
bool | $bData | Boolean value |
Definition at line 241 of file CDataBaseSqlServer.php.
|
protected |
CompileSelectSql - Compiles SQL expression
protected
array | $aWhere | Array of conditions |
Definition at line 192 of file CDataBaseSqlServer.php.
QuoteTable | ( | $sTableName | ) |
QuoteTable - Quotes Table name
public
string | $sTableName | Table name |
Definition at line 146 of file CDataBaseSqlServer.php.
|
protected |
Sanitize - Sanitizes string
protected
string | $sData | Data to sanitize |
Definition at line 180 of file CDataBaseSqlServer.php.