我是Yii的新手,在向表中插入行后运行的Yii::app()->db->createCommand()
有问题。我想检查提供了params的表中有多少行,但即使插入了行,Yii::app()->db->createCommand()
也会返回0。
这是简化的代码:
$photo_model = new Photo();
$ehp_model = new EventHasPhoto();
$photo_model->setIsNewRecord(true);
$photo_model->photo_id = null;
$photo_model->original_id = $data->id;
$photo_model->save();
$ehp_model->setIsNewRecord(true);
$ehp_model->event_id = $event_id;
$ehp_model->photo_id = $photo_model->photo_id;
$ehp_model->is_approved = ($event_model->moderation == 1 ? -1 : 1);
$ehp_model->save();
$count = Yii::app()->db->createCommand()->select('COUNT(p.photo_id) AS num')
->from('photo AS p')
->join('event_has_photo AS ehp','ehp.photo_id=p.photo_id')
->where('p.original_id="'.$data->id.'" AND ehp.event_id='.$event_id)
->queryAll();
$exist = $count[0]["num"]; // exists is 0
exists的值是0,但当我通过MySQL工作台运行相同的查询时,我得到1,所以我假设有一些内置的缓存机制会返回过时的数据。
有什么想法吗?
看起来像是语法错误,错误报告关闭。
如果不将true
传递给queryAll,则不会返回关联数组;相反,您将得到一个带有整数索引键的结果。
换句话说,您的$count
变量包含:
$count = array(
0=>array(0=>1)
)
在error_reporting(
)设置为0的情况下,$count[0]["num"]
在这种情况下评估为false
。
要求解,请将true
传递给queryAll()
$count = Yii::app()->db->createCommand()->select('COUNT(p.photo_id) AS num')
->from('photo AS p')
->join('event_has_photo AS ehp','ehp.photo_id=p.photo_id')
->where('p.original_id="'.$data->id.'" AND ehp.event_id='.$event_id)
->queryAll(true);
$exist = $count[0]["num"];
或使用queryScalar()
$count = Yii::app()->db->createCommand()->select('COUNT(p.photo_id) AS num')
->from('photo AS p')
->join('event_has_photo AS ehp','ehp.photo_id=p.photo_id')
->where('p.original_id="'.$data->id.'" AND ehp.event_id='.$event_id)
->queryScalar();
$exist = $count;
甚至可以使用原始查询访问正确的数组元素:
$count = Yii::app()->db->createCommand()->select('COUNT(p.photo_id) AS num')
->from('photo AS p')
->join('event_has_photo AS ehp','ehp.photo_id=p.photo_id')
->where('p.original_id="'.$data->id.'" AND ehp.event_id='.$event_id)
->queryAll();
$exist = $count[0][0];