Yii如何从数据库中检索数据并在视图中显示

Question

I trying to retrieve data from DB...But I face some problem

Following is my coding:

In Controller :

public function actionFinalCheck()
{

    $gametitle=GamesDevelopersApp::model()->find('develper_id=1',array('gametitle'));
    $this->render('finalcheck',array('gametitle'=>$gametitle));
}

In View(PHP):

<?php print_r($gametitle); ?>

What I need is "select gametitle from db where developer_id=1" but in Yii I not sure how to do

OR any better way to retrieve data from DB and display in view ? Thanks

Answer 1

You are passing the parameter :developer_id but are not using it in the condition. Try passing it a CDBCriteria object like below:

$criteria = new CDbCriteria();
$criteria->compare('id', 1); // Check that the column gametitle is equal to 1
$gametitle=GamesDevelopersApp::model()->findAll($criteria);

See findAll method for ACtiveRecord http://www.yiiframework.com/doc/api/1.1/CActiveRecord#findAll-detail for details