Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = 'SELECT * FROM user_fixed_configuration WHERE langcode=:langcode';
- $bindparams = array();
- $bindparams['langcode']=$langcode;
- if (!empty($budgetFrom)) {
- $query .= ' AND price>=:budgetfrom';
- $bindparams['budgetfrom']=$budgetFrom;
- }
- if (!empty($budgetTo)) {
- $query .= ' AND price<=:budgetto';
- $bindparams['budgetto']=$budgetTo;
- }
- $statement = $this->_db->prepare($query);
- foreach ($bindparams as $key => $value) {
- $statement->bindParam(':'.$key,$value);
- }
- $statement->execute();
- return $statement->fetchAll();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement