Yii How to retrieve data from DB and display in view

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

can you try using print_r instead of echo and see what happens? — roullie
– roullie, Commented Oct 28, 2014 at 1:56

Ali MasudianPour · Accepted Answer · 2014-10-28 06:48:21Z

4

You can do that by the ways listed below:

Active Record

You need to have a model and by model you can fetch data like below:

$object=GamesDevelopersApp::model()->findByAttributes(array("develper_id"=>1));
echo $object->gametitle; // prints gametitle

Query Builder

$row=Yii::app()->db->createCommand()->select('gametitle')->from('db')->where('id=1')->queryRow();
echo $row['gametitle']; //prints gametitle

DAO (Data Access Objects)

$sql="select gametitle from db where developer_id=1";
$command=Yii::app()->db->createCommand($sql)->queryRow();
echo $command['gametitle']; //prints gametitle

edited Oct 28, 2014 at 6:48

answered Oct 28, 2014 at 5:40

Ali MasudianPour

14.5k3 gold badges64 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

crafter Over a year ago

and id developer_id is the primary key, use findByPK($developer_id)

Nana Partykar Over a year ago

Nice One Ali. Banging My Head Since Last 1 Hour And, I Got Here. Thank You.

TheSmile · Accepted Answer · 2014-10-28 04:38:18Z

0

I use this it worked fine for me !

In controller

public function actionFinalCheck()
{

    $developer_id = 'developer_id=1';
    $gametitle=GamesDevelopersApp::model()->find($developer_id);

    $this->render('finalcheck',array('gametitle'=>$gametitle));
}

In View(PHP):

<?php echo CHtml::encode($gametitle->gametitle); ?>

edited Oct 28, 2014 at 4:38

answered Oct 28, 2014 at 4:26

TheSmile

3603 gold badges10 silver badges36 bronze badges

Comments

elvey · Accepted Answer · 2014-10-28 05:57:58Z

0

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

edited Oct 28, 2014 at 5:57

answered Oct 28, 2014 at 2:19

elvey

5185 silver badges9 bronze badges

3 Comments

TheSmile Over a year ago

thanks but if i have to assign id is 1? Cause normally is select gametitle from db where id='1';

TheSmile Over a year ago

include(CdbCriteria.php): failed to open stream: No such file or directory

elvey Over a year ago

Sorry I had an incorrect case on the CDbCriteria name. It's corrected now. Also, if your key is id you will need to use that for the field name. Yii determines which table you are querying from the model

Dave · Accepted Answer · 2018-09-17 12:26:59Z

0

public function getQuotes()
    {    
       $sql="select * from db";
        $command=Yii::app()->db->createCommand($sql)->queryAll();
        foreach($command as $commands)
        echo $commands['gametitle']; 
    }

In view:

<?php echo CHtml::encode($model->gametitle)?>

edited Sep 17, 2018 at 12:26

Dave

5162 gold badges7 silver badges24 bronze badges

answered Mar 27, 2015 at 7:22

KanimozhiPalanisamy

639 bronze badges

Collectives™ on Stack Overflow

Yii How to retrieve data from DB and display in view

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related