symfony中，使用原声的sql语句
时间：2021-07-01 10:21:17
帮助过：61人阅读
/**
2 * 数组形式的原生sql
3 */
4 public function arrayA(
array $did)
5 {
6 $statement =
$this->getEntityManager()->getConnection()->executeQuery(‘
7 SELECT did, count(1) as num
8 FROM position_structure
9 WHERE did in (?)
10 AND status = 1
11 GROUP BY did
12 ‘,
array(
$did),
array(Connection::
PARAM_INT_ARRAY));
13 return $statement->
fetchAll();
14 }
15
16 /**
17 * 单个值的原生sql
18 */
19 public function fetchCompaniesByUserId(
$userId){
20 $statement =
$this->getEntityManager()->getConnection()->prepare(‘
21 SELECT c.id,c.name,c.type FROM company_admin ca
22 LEFT JOIN company c ON c.id = ca.company_id
23 WHERE ca.user_id = :userId‘
);
24 $statement->bindValue(‘userId‘,
$userId);
25 $statement->
execute();
26 return $statement->
fetchAll();
27 }
symfony中，使用原声的sql语句
标签：left join .com param select his sel state com array
