1.简单查询
$conditions = 'status = :status:';
$parameters = [
'status' => 1,
];
$result = Customer::find(["columns"=> "id,name,status", $conditions, 'bind' => $parameters]);
2.含有like的查询
$search = '小明';
$models = Customer::query()
->where('id = :id:', array('id' => 10))
->andWhere('name LIKE :name:', $parameters = [ 'name' => '%'. $search. '%'])
->orderBy('date desc')
->execute()
->toArray();
3.连表查询
$model =$this->modelsManager->createBuilder()
->addfrom('app\models\service\Customer','a')
->leftJoin('app\models\product\Product', 'a.id = t.customer_id', 't')
->where('a.id = :id:', array('id' => '1'))
->groupBy(array('a.id'))
->getQuery()
->execute();
phalcon 查询
最新推荐文章于 2021-01-21 16:52:55 发布