Symfony, use the SQL statement from the OST

1 /**2 * Native SQL in array form3 */4  Public functionArraya (Array $did)5 {6 $statement=$this->getentitymanager ()->getconnection ()->executequery ('7 SELECT did, count (1) as Num8 From position_structure9 WHERE do in (?)Ten and status = 1 One GROUP by did A‘,Array($did),Array(Connection::Param_int_array)); -     return $statement-Fetchall (); - } the   - /** - * Native SQL for single value - */ +  Public functionFetchcompaniesbyuserid ($userId){ -     $statement=$this->getentitymanager ()->getconnection ()->prepare (' + SELECT C.id,c.name,c.type from company_admin CA A Left JOIN Company C on c.id = ca.company_id atWHERE ca.user_id =: UserId '); -     $statement->bindvalue (' UserId ',$userId); -     $statement-execute (); -     return $statement-Fetchall (); -}

Symfony, use the SQL statement from the OST