Doctrine and LIKE query

Question

I have entity for Doctrine    lt  php         Entity     Table name  orders       class Orders            Id  Column name  OID  type  integer    GeneratedValue        private  id           Column name  Product  type  string             private  product           Column name  RegCode  type  string             private  reg code           Column name  OrderEmail  type  string         private  email      I need make query like this    select   from  orders  where  OrderEmail   some mail com  and  Product  LIKE  My Products     I try handle query without like    em- gt getRepository  Orders  - gt findByEmailAndProduct  uname  product     But it make error  Why  Can I do this query without DQL  I want make this query use magic methods findBy

User · Answer

Actually you just need to tell doctrine who's your repository class, if you don't, doctrine uses default repo instead of yours.

@ORM\Entity(repositoryClass="Company\NameOfBundle\Repository\NameOfRepository")

User · Answer

This is not possible with the magic find methods  Try using the query builder    result    em- gt getRepository  Orders  - gt createQueryBuilder  o      - gt where  o OrderEmail    email      - gt andWhere  o Product LIKE  product      - gt setParameter  email    some mail com      - gt setParameter  product    My Products       - gt getQuery      - gt getResult

User · Answer

You can use the createQuery method  direct in the controller      query    em- gt createQuery  SELECT o FROM AcmeCodeBundle Orders o WHERE o OrderMail     ordermail and o Product like  searchterm   - gt setParameter  searchterm        searchterm      - gt setParameter  ordermail    some email com      You need to change AcmeCodeBundle to match your bundle name  Or even better - create a repository class for the entity and create a method in there - this will make it reusable

User · Answer

you can also do it like that     ver    em- gt getRepository  GedDocumentBundle version  - gt search  val     tail   sizeof  ver

User · Answer

This is not possible with the magic methods  however you can achieve this using DQL  Doctrine Query Language   In your example  assuming you have entity named Orders with Product property  just go ahead and do the following    dql query    em- gt createQuery       SELECT o FROM AcmeCodeBundle Orders o     WHERE        o OrderEmail    some mail com  AND       o Product LIKE  My Products        orders    dql query- gt getResult      Should do exactly what you need

[php] Doctrine and LIKE query

Examples related to php

Examples related to mysql

Examples related to doctrine-orm