Skip to content

Instantly share code, notes, and snippets.

@e-vural
Created June 24, 2016 09:37
Show Gist options
  • Save e-vural/ea81f81c003f913f7b66377f24ef4909 to your computer and use it in GitHub Desktop.
Save e-vural/ea81f81c003f913f7b66377f24ef4909 to your computer and use it in GitHub Desktop.
$students = $em->createQueryBuilder()
->select("concat(pr.name,' ',pr.surname as student_name")///THİS IS CONCAT
->from('CoreCorporateBundle:Classroom','cr')
->innerJoin('cr.classroom_members','crm')
->innerJoin('crm.profile','pr')
->where('cr.uuid =:uuid')
->andwhere('crm.type =:type')
->setParameter('uuid',$classroom_uuid)
->setParameter('type','ogrenci')
->getQuery()
->getArrayResult();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment