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_FilterEntries'); } return $this->_dbTable; } public function save(Application_Model_FilterEntries $filterentries) { try{ $data = array( 'filterentriesID'=>$filterentries->getID(), 'filterID'=> $filterentries->getFilterID() , 'filtertypeID'=> $filterentries->getFiltertypeID() , 'filtervalue'=> $filterentries->getFiltervalue() , 'filtervalue2'=> $filterentries->getFiltervalue2() ); $filterentries2 = new Application_Model_FilterEntries(); $result = $this->find($filterentries->getID(),$filterentries2); $id1 = $filterentries2->getID(); if (0 == count($result) && null == $id1) { $this->getDbTable()->insert($data); echo 'inserted'; } else { print_r($this->getDbTable()->update($data, array('filterentriesID = ?' => $id1))); echo 'updated'; } }catch (Zend_Exception $e) { echo "Error message 2: " . $e->getMessage() . "\n"; } } public function delete(Application_Model_FilterEntries $filterentries) { try{ $id1 = $filterentries->getID(); if ((null == $id1)) { echo 'case1'; return; } else { $this->getDbTable()->delete(array('filterentriesID = ?' => $id1)); echo 'case2'; } }catch (Zend_Exception $e) { echo "Error message 2: " . $e->getMessage() . "\n"; } } public function find($filterentriesID, Application_Model_FilterEntries $filterentries) { $result = $this->getDbTable()->find($filterentriesID); echo 'dump1'; if (0 == count($result)) { return; } echo 'dump2'; $row = $result->current(); $filterentries->setID($row->filterentriesID) ->setFilterID($row->filterID) ->setFiltertypeID($row->filtertypeID) ->setFiltervalue($row->filtervalue) ->setFiltervalue2($row->filtervalue2); return $filterentries; } public function fetchAll() { $resultSet = $this->getDbTable()->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entry = new Application_Model_FilterEntries(); $entry->setID($row->filterentriesID) ->setFilterID($row->filterID) ->setFiltertypeID($row->filtertypeID) ->setFiltervalue($row->filtervalue) ->setFiltervalue2($row->filtervalue2); $entries[] = $entry; } return $entries; } }