getDbTable()->select() ->from($this->_dbTable) ->where($criteria . ' = ?', $value); $stmt = $select->query(); $result = $stmt->fetchAll(); return $result; }catch (Zend_Exception $e) { echo "Error message 2: " . $e->getMessage() . "\n"; } } public function setDbTable($dbTable) { if (is_string($dbTable)) { $dbTable = new $dbTable(); } if (!$dbTable instanceof Zend_Db_Table_Abstract) { throw new Exception('Invalid table data gateway provided'); } $this->_dbTable = $dbTable; return $this; } public function getDbTable() { if (null === $this->_dbTable) { $this->setDbTable('Application_Model_DbTable_Session'); } return $this->_dbTable; } public function save(Application_Model_Session $session) { $data = array( 'sessionID'=> $session->getID() , 'alphasessionID'=> $session->getAlphasessionID(), 'clientID'=> $session->getClientID() , 'bootmenuentryID'=> $session->getBootmenuentryID(), 'bootosID'=> $session->getBootosID() , 'bootisoID'=> $session->getBootisoID() , 'time'=> $session->getTime() , 'ip'=> $session->getIp() , 'ip6'=> $session->getIp6() ); if (null === ($id = $session->getID()) ) { unset($data['sessionID']); $this->getDbTable()->insert($data); } else { $this->getDbTable()->update($data, array('sessionID = ?' => $id)); } } public function delete(Application_Model_Session $sesion) { if (null === ($id = $sesion->getID()) ) { return; } else { $this->getDbTable()->delete(array('sessionID = ?' => $id)); } } public function find($id, Application_Model_Session $sesion) { $result = $this->getDbTable()->find($id); if (0 == count($result)) { return; } $row = $result->current(); $sesion->setID($row->sessionID) ->setAlphasessionID($row->alphasessionID) ->setClientID($row->clientID) ->setBootmenuentryID($row->bootmenuentryID) ->setBootosID($row->bootosID) ->setBootisoID($row->bootisoID) ->setTime($row->time) ->setIp($row->ip) ->setIp6($row->ip6); } public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_Session(); $entry->setID($row->sessionID) ->setAlphasessionID($row->alphasessionID) ->setClientID($row->clientID) ->setBootmenuentryID($row->bootmenuentryID) ->setBootosID($row->bootosID) ->setBootisoID($row->bootisoID) ->setTime($row->time) ->setIp($row->ip) ->setIp6($row->ip6); $entries[] = $entry; } return $entries; } }