php – findAll()在yii

前端之家收集整理的这篇文章主要介绍了php – findAll()在yii前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
EmailArchive表:
id email_id to from
1  101      uk  msm
2  102      uu  avc
3  101      rk  uk
4  103      xyz abc
5  104      xyz poi
6  104      abc xyz
7  101      xyz abc

现在在Yii我想要记录where email_id = 101
我使用下面的代码,但它不工作.

$id =101;
$criteria = new CDbCriteria();
$criteria->addCondition("email_id < :email_id");
$comments = EmailArchive::model()->findAll($criteria,array(':email_id' => $id,));
尝试:
$id =101;
$comments = EmailArchive::model()->findAll(
array("condition"=>"email_id =  $id","order"=>"id"));

要么

$id =101;
$criteria = new CDbCriteria();
$criteria->addCondition("email_id=:email_id");
$criteria->params = array(':email_id' => $id);
$comments = EmailArchive::model()->findAll($criteria);

要么

$Criteria = new CDbCriteria();
$Criteria->condition = "email_id = $id";
$Products = Product::model()->findAll($Criteria);
原文链接:https://www.f2er.com/php/138289.html

猜你在找的PHP相关文章