Tag: dql

Why is a column going into the next row when there are only 12 columns?

I have a row with 4 columns that are each 3 wide, which adds up to the 12 that are supposed the be in a row, but for some reason the last one is still going onto a new row. Any idea how to fix this? Here’s my code: <div class=”container text-center”> <h3>Welcome to “Ender’s… Read More Why is a column going into the next row when there are only 12 columns?

MRLeave a comment

DQL returns 0 expected result where MySQL has 2

I have a doctrine query (DQL) on my user repository which returns 0 results when I use a like : $qb = $this->createQueryBuilder(‘q’); $qb->select(‘q.id, q.roles’); $qb->andWhere($qb->expr()->like(‘q.roles’, ‘:role1’)); $qb->setParameter(‘role1’, ‘"%ROLE_ADMIN%"’); return $qb->getQuery()->getResult(); whereas if I manually execute the query on MySQL, I have 2 results SELECT * FROM user u WHERE u.roles LIKE "%ROLE_ADMIN%" I have… Read More DQL returns 0 expected result where MySQL has 2

MRLeave a comment