PHP DatabaseManager::loadObjectList Beispiele

Beispiel #1

Datei: Member.php Projekt: rooswill/CommanderHQ

 public function getHistory()
 {
     $db = new DatabaseManager(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_CUSTOM_DATABASE);
     $SQL = 'SELECT B.recid, B.WorkoutName, A.Attribute, L.AttributeValue, L.TimeCreated 
         FROM WODLog L 
                 LEFT JOIN CustomWorkouts B ON B.recid = L.ExerciseId 
                 LEFT JOIN Attributes A ON A.recid = L.AttributeId
                 LEFT JOIN WorkoutTypes ET ON ET.recid = L.WODTypeId
                 WHERE L.MemberId = ' . $_COOKIE['UID'] . ' 
                 AND ET.WorkoutType = "Custom"
                 AND A.Attribute = "TimeToComplete"
                 ORDER BY TimeCreated';
     $db->setQuery($SQL);
     return $db->loadObjectList();
 }