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; }
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; }