Skip to content

Instantly share code, notes, and snippets.

/php

Created October 10, 2015 14:07
Show Gist options
  • Save anonymous/92012697fc99fcf02da5 to your computer and use it in GitHub Desktop.
Save anonymous/92012697fc99fcf02da5 to your computer and use it in GitHub Desktop.
cartype with createQueryBuilder()
public function FindMake($makename,$local){
$fields = array('Carparktype.makename', 'Carparktype.rangename','Carparktype.doors', 'Carparktype.versionname', 'Carparktype.kw', 'Carparktype.ccmtech',
'Carparktype.engine','Carparktype.modelyear','Carparktype.buildfrom','Carparktype.buildto', 'CarparkAgestext.agesen', 'CarFueltext.fuelen');
$query = $this->getEntityManager()->createQueryBuilder()
->select($fields)
->from('MyBundle:SpareParts\Carparktype Carparktype')
->innerJoin('MyBundle:SpareParts\CarparkAgestext CarparkAgestext')
->innerJoin('MyBundle:SpareParts\CarFueltext CarFueltext')
->where('Carparktype.makename =:makename')
->setParameter('makename',$makename)
->getQuery()
->getResult();
return $query;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment