how to get query in symfony2?

Question

I'm creating a query like this

    $om = $this->getContainer()->get('doctrine')->getManager();

    $qb = $om->createQueryBuilder()
            ->from('ProbusQuoteExtraBundle:Quote', 'q')
            ->select('q', 'b')
            ->join('q.booking', 'b')
            ->orderBy('q.id', 'asc')
            ->where("q.startDate >= '" . date('Y-m-d H:i:s', strtotime('-1 hour')) . "'")
            ->andWhere("q.startDate <= '" . date('Y-m-d H:i:s', time()) . "'")
    ;

i want to check if i created correct query or not by using this

echo $qb->getQuery();

but it gives error.

Maybe because you are trying to use Query object as a string, because getQuery() method will return object. Try with getDQL() or use var_dump instead echo. — Ivan Toncev
– Ivan Toncev, Commented May 21, 2015 at 10:13
echo $qb->getQuery()->getSQL(); might help. Also, remember the debugging toolbar in your development environment shows all the queries that have run. — mika
– mika, Commented May 21, 2015 at 10:24

DerStoffel · Accepted Answer · 2015-05-21 13:17:29Z

3

If you want to check your statement in DQL or SQL you can do this by calling ->getSQL(), or ->getDQL() on $qb->getQuery();

Also I recommend installing xdebug and using var_dump():

$sql = $qb->getQuery()->getSQL();
$dql = $qb->getQuery()->getDQL();
var_dump($sql);
var_dump($dql);

It will print both, a SQL and DQL dump of your QueryBuilder

And since we're at it, instead of injecting your parameters by concatenation use the QueryBuilders ->setParameters() method:

->where("q.startDate >= :startDate")
->andWhere("q.startDate <= :endDate")
->setParameters(array(
         'startDate' => date('Y-m-d H:i:s', strtotime('-1 hour')), 
         'endDate' => date('Y-m-d H:i:s', time()),
))

You can find more on that in the Doctrine2 documentation.

edited May 21, 2015 at 13:17

answered May 21, 2015 at 10:24

DerStoffel

2,6432 gold badges17 silver badges25 bronze badges

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

4 Comments

ÛmÄîr MÄlîk Over a year ago

thanks. it worked. one more question, how can i read and display result after query is executed? $result = $qb->getQuery()->getResult(); print_r($result);

DerStoffel Over a year ago

this is exactly how. This is your mapped result.

ÛmÄîr MÄlîk Over a year ago

its giving error object of class datetime could not be converted to string

DerStoffel Over a year ago

that means your result is, or contains a datetime object. Install xdebug, and use var_dump to see what you get. A possibility for a string representation of a DateTime Object ist ->format('Y-m-d H:i:s'). Check the documentation php.net/manual/de/class.datetime.php

Collectives™ on Stack Overflow

how to get query in symfony2?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related