Advertisement
r1pp3rj4ck

Untitled

Nov 15th, 2011
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.75 KB | None | 0 0
  1.     public function search($keyword)
  2.     {
  3.         $query = 'SELECT v
  4. FROM VelvelZDFBundle:Video v
  5. WHERE v.title LIKE  :keyword
  6. OR v.subtitle LIKE  :keyword
  7. OR v.description LIKE  :keyword
  8. ORDER BY
  9. CASE WHEN v.title LIKE  :keyword
  10. AND v.subtitle LIKE :keyword
  11. AND v.description LIKE :keyword
  12. THEN 0
  13. WHEN v.title LIKE  :keyword
  14. AND v.subtitle LIKE :keyword
  15. THEN 1
  16. WHEN v.title LIKE  :keyword
  17. AND v.description LIKE :keyword
  18. THEN 2
  19. WHEN v.subtitle LIKE :keyword
  20. AND v.description LIKE :keyword
  21. THEN 3
  22. WHEN v.title LIKE :keyword
  23. THEN 4
  24. WHEN v.subtitle LIKE :keyword
  25. THEN 5
  26. WHEN v.description LIKE :keyword
  27. THEN 6
  28. END ASC , id DESC';
  29.  
  30.         return $this->em->createQuery($query)->setParameter('keyword', '%' . $keyword . '%')->getResult();
  31.     }
  32.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement