public function getAll(\Core\Database $db) { $recs = $db->fetchAllAssoc("select * from rooms", array()); $result = array(); for ($i = 0; $i < count($recs); $i++) { $result[] = new \Application\RoomItem($recs[$i]); } return $result; }
public function getAll(\Core\Database $db) { if ($recs = $db->fetchAllAssoc("select * from employees", array())) { $result = array(); foreach ($recs as $record) { $result[] = new \Application\EmpItem($record); } return $result; } else { return array(); } }
public function getChain($chainId, \Core\Database $db) { $sql = "select * from appointments where chain=:chain"; if ($recs = $db->fetchAllAssoc($sql, array(":chain" => $chainId))) { $result = new \Application\AppointmentChain(); foreach ($recs as $record) { $result->add(new \Application\AppointmentItem($record)); } return $result; } else { return new \Application\AppointmentChain(); } }