How to retrieve data from db

Yii 1.1 General Discussion
1

Hi im new in yii … i wish to retrieve data from db and then view data in drop down menu (selection box). How to do that ? please help thanks

2

All you need to read docs first http://www.yiiframework.com/tour/

3

can u pls be specific to answer me how to retrieve data from db ?

4

The answers on this questions is written in documentation. There is not so much menu items to be a scientists to read it. http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder

5

$user = Yii::app()->db->createCommand()

->select('username, password')


->from('tbl_user')


->where('id=:id', array(':id'=>1))


->queryRow();

found this code … is this correct ?

6

Too "complicated’. You’ld rather write:




$user=User::model()->findByPk(1);

if($user===null) {

   throw new CException('No user'); // Or handle error differently.

} else {

   $username=$user->username;

   $password=$user->password;

}

Prior to that you have to generate the User model for the ‘tbl_user’ table using the methods that are described in the tutorials, documentation, … .