public function buildListFilter($module) { $objNewSQL=new ClsAuieoSQL(); $objFrom=$objNewSQL->addFrom("saved_list_entry"); $joinID=$objFrom->addJoinField("saved_list_id"); $objFromList=$objNewSQL->addFrom("saved_list"); $userJoinID=$objFromList->addJoinField("saved_list_id"); $objFromList->setJoinWith($objFrom,$joinID,$userJoinID); $joinID=$objFromList->addJoinField("created_by"); $objFromUser=$objNewSQL->addFrom("user","owner_user"); $userJoinID=$objFromUser->addJoinField("user_id"); $objFromUser->setJoinWith($objFromList,$joinID,$userJoinID); $joinID=$objFromList->addJoinField("data_item_type"); $objFromType=$objNewSQL->addFrom("data_item_type"); $userJoinID=$objFromType->addJoinField("data_item_type_id"); $objFromType->setJoinWith($objFromList,$joinID,$userJoinID); $objWhere=$objNewSQL->addWhere($objFromType, "module", $module); $sql=$objNewSQL->render(); $objPDO=ClsNaanalPDO::getNamedInstance(); $objPDO->setQuery($sql); $arr=$objPDO->getAllAssoc();trace($arr); }
/** * Initiate a connection with the MySQL database. This is called by the * constructor. * * @param string MySQL query or null to operate on the last executed query * for this instance. * @return boolean Was the connection successful? */ public function connect() { $this->_connection = ClsNaanalPDO::getNamedInstance("cats", DATABASE_NAME, DATABASE_USER, DATABASE_PASS, "mysql", DATABASE_HOST); return true; }
/** * returns current database * @return string */ public static function getCurrentDatabase() { $dbid = self::getCurrentDatabaseID(); if ($dbid > 0) { $sql = "select * from `database` where `id`=" . $dbid; $pdo = ClsNaanalPDO::getNamedInstance(); $pdo->setQuery($sql); $arrAssoc = $pdo->getAllAssoc(); $database = $arrAssoc[0]["databasename"]; $pdo->statement = null; return $database; } else { return ClsNaanalApplication::getDefaultDatabase(); } }