Advertisement
Guest User

Untitled

a guest
Jun 10th, 2014
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.57 KB | None | 0 0
  1. $query = 'SELECT * FROM user_fixed_configuration WHERE langcode=:langcode';
  2.         $bindparams = array();
  3.         $bindparams['langcode']=$langcode;
  4.         if (!empty($budgetFrom)) {
  5.             $query .= ' AND price>=:budgetfrom';
  6.             $bindparams['budgetfrom']=$budgetFrom;
  7.         }
  8.         if (!empty($budgetTo)) {
  9.             $query .= ' AND price<=:budgetto';
  10.             $bindparams['budgetto']=$budgetTo;
  11.         }
  12.         $statement = $this->_db->prepare($query);
  13.         foreach ($bindparams as $key => $value) {
  14.             $statement->bindParam(':'.$key,$value);            
  15.         }
  16.         $statement->execute();
  17.         return $statement->fetchAll();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement