Example #1
0
 public function getSessionVar()
 {
     $sessionVar = [];
     $sql_select = "SELECT sessionName, varName, varValue, LastUpdate\n  FROM sessionvar";
     $stmt = $conn->query($sql_select);
     $returnedList = $stmt->fetchAll();
     if (count($returnedList) > 0) {
         foreach ($returnedList as $group) {
             $curGroup = new Group($group['group_name']);
             $curGroup->setID($group['groupid']);
             $curGroup->setType($group['group_type']);
             $curGroup->setWeb($group['group_web']);
             $listOfGroups[] = $curGroup;
         }
     }
     return $listOfGroups;
 }
Example #2
0
 public static function retrieveGroupList($conn)
 {
     $listOfGroups;
     $sql_select = "SELECT groupid, group_name, group_type, group_web, marked_for_deletion\n    FROM group_tbl\n    ORDER BY group_type";
     $stmt = $conn->query($sql_select);
     $returnedList = $stmt->fetchAll();
     if (count($returnedList) > 0) {
         foreach ($returnedList as $group) {
             if ($group['marked_for_deletion'] == true) {
                 continue;
             }
             $curGroup = new Group($group['group_name']);
             $curGroup->setID($group['groupid']);
             $curGroup->setType($group['group_type']);
             $curGroup->setWeb($group['group_web']);
             $listOfGroups[] = $curGroup;
         }
     }
     return $listOfGroups;
 }