Array to listdata

chrischa · January 7, 2015, 5:13am

Im new in Yii and object oriented,i need some help on how to display the data from controller into layout/main.php.The table called branch and i need to display a dropdownlist at the layout.However, it returns error.Please help me.Here is the code,

protected/controllers/BranchController.php:

public static function BranchList()

{


	&#036;myList = &quot;SELECT branch_name FROM branch&quot;;


	&#036;rows = Yii::app()-&gt;db-&gt;createCommand(&#036;myList)-&gt;queryAll();


	return array(&#036;rows);


}

protected/views/layout/main.php:

<?php

	&#036;optd = CHtml::listData(BranchController::BranchList());


	echo CHtml::dropDownList('listname','branch',array(&#036;optd));

?>

negar · January 7, 2015, 5:28am

Chrischa:

Im new in Yii and object oriented,i need some help on how to display the data from controller into layout/main.php.The table called branch and i need to display a dropdownlist at the layout.However, it returns error.Please help me.Here is the code,

protected/controllers/BranchController.php:

public static function BranchList()
{


	&#036;myList = &quot;SELECT branch_name FROM branch&quot;;


	&#036;rows = Yii::app()-&gt;db-&gt;createCommand(&#036;sql)-&gt;queryAll();


	return array(&#036;rows);


}
protected/views/layout/main.php:

<?php
	&#036;optd = CHtml::listData(BranchController::BranchList());


	echo CHtml::dropDownList('listname','branch',array(&#036;optd));
?>

hi

see this link

My link

chrischa · January 7, 2015, 7:35am

Solved the problem based on the links…tq very much…