Tutorial Extension  1.0.0
SellerDeck Extensions - Tutorial Extension
Public Member Functions | List of all members
CDataBaseAccessNoPDO Class Reference

Inherits CDataBaseAccess.

Public Member Functions

 __construct ($aConnectionDetails, $sDatabaseID)
 
- Public Member Functions inherited from CDataBaseAccess
 __construct ($aConnectionDetails, $sDatabaseID)
 
- Public Member Functions inherited from CDataBase
 __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=[])
 

Additional Inherited Members

- Protected Member Functions inherited from CDataBaseAccess
 CompileSelectSql ($aQuery=[])
 
 ConcatenateJoins ($aJoinDirections, $aJoinTables, $aJoinOns)
 
 Sanitize ($sData)
 
 BoolValue ($bData)
 
- Protected Member Functions inherited from CDataBase
 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 inherited from CDataBaseAccess
 $m_sColumnQuoteBegin = "["
 
 $m_sColumnQuoteEnd = "]"
 
- Protected Attributes inherited from CDataBase
 $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 = ""
 

Detailed Description

Definition at line 14 of file CDataBaseAccessNoPDO.php.

Constructor & Destructor Documentation

__construct (   $aConnectionDetails,
  $sDatabaseID 
)

__construct - Object constructor method

public

Parameters
array$aConnectionDetails
Returns
void

Definition at line 24 of file CDataBaseAccessNoPDO.php.

25  {
26  \SDExtension\Helper\CLogger::get()->addDebug(__CLASS__);
27  try
28  {
29  $sDsn = arr_get($aConnectionDetails, 'sDsn', '');
30  $this->m_sDBUser = arr_get($aConnectionDetails, 'sUser', '');
31  $sPassword = arr_get($aConnectionDetails, 'sPassword', '');
32  $this->m_sDataBaseID = arr_get($aConnectionDetails, 'sDatabaseID', '');
33  $this->m_aDataBases = arr_get($aConnectionDetails, 'aDataBases', []);
34  $this->m_oDB = new CMockAccessOdbcPdo($sDsn, $this->m_sDBUser, $sPassword);
35  \SDExtension\Helper\CLogger::get(LOG_CHANNEL_NAME)->addInfo("Connected to Database: $sDatabaseID");
36  }
37  catch (\Exception $e)
38  {
39  echo $e->getMessage();
40  }
41  }
static get($sChannel="default", $sLogRoot="")
Definition: CLogger.php:90

The documentation for this class was generated from the following file: