YII2中andWhere如何多個or查詢

YII2中andWhere如何多個or查詢

YII2中andwhere如何多個or查詢

使用多個or的復雜查詢:

AND?((`name`='張三')?OR?(`name`='李四')?OR?(`name`='王五'))
//?AND?((`name`='張三')?OR?(`name`='李四')?OR?(`name`='王五')) $query->andWhere(['or', ????['name'?=>?'張三'], ????['name'?=>?'李四'], ????['name'?=>?'王五'] ]);
AND?(((name=‘張三’)?AND?(phone=‘15200000000’))?OR?((name=‘李四’)?AND?(phone=‘15300000000’)))
//?AND?(((`name`='張三')?AND?(`phone`='15200000000'))?OR?((`name`='李四')?AND?(`phone`='15300000000'))) $query->andWhere(['or', ????['and', ????????['name'?=>?'張三'], ????????['phone'?=>?'15200000000'] ????], ????['and', ????????['name'?=>?'李四'], ????????['phone'?=>?'15300000000'] ????] ]);

推薦:《YII教程》??

? 版權聲明
THE END
喜歡就支持一下吧
點贊9 分享