Guest User

Untitled

a guest
Jan 20th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. public function feedbackaverageAction(){
  2. $value =$_GET['value'];
  3. $db = Zend_Registry::get('dbadapter');
  4. $select = new Zend_Db_Select($db);
  5. $select = $db->select();
  6. $select->from(array('feedback' => 'feedback'),
  7. array ('customdata',
  8. 'checkinprocess',
  9. 'service_by_owner',
  10. 'locationrating',
  11. 'cleanlinessrating',
  12. 'valueformoneyrating',
  13. 'kitchenequipmentrating'));
  14. $select->where('feedback.checkinprocess' +
  15. 'feedback.service_by_owner' +
  16. 'feedback.locationrating' +
  17. 'feedback.cleanlinessrating' +
  18. 'feedback.valueformoneyrating' +
  19. 'feedback.kitchenequipmentrating' <= $value);
  20. $stmt = $select->query();
  21. $result = $stmt->fetchAll();
  22. $this->view->rows = $result;
  23. }
  24.  
  25. $value = $_GET['value'];
  26. $db = Zend_Registry::get('dbadapter');
  27. $select = new Zend_Db_Select($db);
  28. $select = $db->select();
  29.  
  30. $select->from(array('feedback' => 'feedback'),array ('customdata','checkinprocess','service_by_owner','locationrating','cleanlinessrating','valueformoneyrating','kitchenequipmentrating'));
  31.  
  32. $select->where(new Zend_Db_Expr('feedback.checkinprocess'+'feedback.service_by_owner'+'feedback.locationrating'+'feedback.cleanlinessrating'+'feedback.valueformoneyrating'+'feedback.kitchenequipmentrating')<= $value);
  33.  
  34. $stmt = $select->query();
  35.  
  36. $result = $stmt->fetchAll();
  37.  
  38. $this->view->rows = $result;
Add Comment
Please, Sign In to add comment