modules/default/models/DbTable/Frontend.php

<?php

class Default_Model_DbTable_Frontend extends Zend_Db_Table_Abstract
{
   public function insertdata($tbl,$params)
    {
			$this->_db->insert($tbl, $params);
            return $last_insert_id = $this->_db->lastInsertId();
	}	
	public function updatedata($tbl,$params,$fld,$id)
    {
		$id=$this->_db->update($tbl, $params, array($fld.'= ?' => (int) $id));
		return $id;
	}
	public function deletedata($tbl,$fld,$id)
    {	
		$id=$this->_db->delete($tbl, array($fld.'= ?' => $id));
	}
	public function loginuser($username,$password)
    {
			
        $select = $this->_db->select()
                        ->from('tbl_admin')
                       ->where('email=?',$username)
                       ->where('status=?','1')
                        ->where('password=?',$password);
                        
          $rec=$this->_db->fetchRow($select);
          $select->reset();          
        return $rec;
    } 
	public function getuserdetail($id)
    {
	$where="id=".$id;		
        $select = $this->_db->select()
                        ->from('tbl_admin')
                       // ->columns('name')
                        ->where($where);
                        //orWhere for or condition and don't use array for where function
                        //group
                        //order
                        //limit(20, 10)
          $rec=$this->_db->fetchRow($select);
          $select->reset();          
        return $rec;
    } 
    	public function getalluser()
    {
		
        $select = $this->_db->select()
                        ->from('tbl_admin');
        $rec=$this->_db->fetchAll($select);
         $select->reset(); 
         return  $rec;
    } 
}
?>