How can i get the single result using DQL in symfony2 How can i get the single result using DQL in symfony2 symfony symfony

How can i get the single result using DQL in symfony2


php symfony doctrine

The right method is: 

$singleProfile = $em->createQuery($dql)                    ->setParameter('user_id',$user_id)                    ->getSingleResult();

To prevent error then no results try this: 

$singleProfile = $em->createQuery($dql)                    ->setParameter('user_id',$user_id)                    ->getOneOrNullResult();

php symfony doctrine 

                $allProfiles = $em->createQuery($dql)                                ->setParameter('user_id',$user_id)                                ->setMaxResults(1)                                ->getResult();                return $allProfiles[0];

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last