ZF2, Using WHERE in Db\SQL

Question

I'm trying to build a SQL object using ZF2's Db\SQL.

Below is my code.

    $sql = new Sql($this->database);
    $predicate = new Where();
    $query = $sql->select();
    $query->from('sessions');
    $query->columns(array('sessiondata'));
    $query->where($predicate->equalTo('sessionid', $sessionId));
    $query->where($predicate->greaterThan('expire', new Expression("NOW()")));

As you can read, I'm doing a session read.

The preparing is failing on the execute because of the [last] where property:

$query->where($predicate->greaterThan('expire', 'NOW()'));

Unfortunately, ZF2 doesn't tell me why it's failed, all I know is that Statement could not be executed

What am I doing wrong in the above?

I think that prepare is interpreting the thing as literally as it can, hence the presence of the mysql function Now() is causing it to fail. How do I get past this?

EDIT: Actually, it's the execution that's failing.

in the exception you have, check if there is parent exception with actual error message — Xerkus
– Xerkus, Commented Dec 30, 2012 at 17:37
Zend\Db throws exception with useless message, but it is setting exception from PDO/MySQLi as previous: php.net/manual/en/exception.getprevious.php — Xerkus
– Xerkus, Commented Dec 30, 2012 at 18:40

shark555 · Accepted Answer · 2012-12-30 17:32:09Z

4

Try debug the final query. You can use mysql query logger for that. In my.cnf(or my.ini) you set:

log = "C:/genquery.log"

OR

log = "/var/log/mysql/error.log"

depending on system.

Then reset mysql server and you can analyze what really happened.

answered Dec 30, 2012 at 17:32

shark555

2,5621 gold badge20 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

ZF2, Using WHERE in Db\SQL

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