PHP select query has no bound

Question

I am trying to do a query onto my database with the following code.

public function getFreeFields($date){
        print_r($date);
        $db = Zend_Registry::get('db');
    $select = $db->select()
        ->from(array('f' => $this->_tablename()), array('f.fie_id','f.fie_name'))
                    ->join('reservation','reservation.res_field = f.fie_id')
                    ->where('reservation.res_date_from > ?'. $date)
                    ->where('reservation.res_date_till < ?'. $date);

    $result = $db->fetchRow($select);
    $data = $this->_mapper->toObject( is_array($result) ? $result : array() );

    return $data;
    }

But it crashes with the following error.

Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound'

When I die after the print_r, I got the correct date that I give to the request.

Any help?

Yogesh Suthar · Accepted Answer · 2013-03-15 09:32:20Z

2

change this

->where('r.res_date_from > ?'. $date)
->where('r.res_date_till < ?'. $date);

to

->where('r.res_date_from > ?', $date)
->where('r.res_date_till < ?', $date);

answered Mar 15, 2013 at 9:32

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP select query has no bound

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related