在列表yii php中获取具有对象索引的对象
问题描述:
This is code query data from database :
public function getAllUser(){
$connect = Yii::app()->db;
$query = "SELECT * FROM user";
$statement = $connect->CreateCommand($query);
$result = $statement->query();
return $result;
}
After that I use Controller to get data & send to View :
public function actionIndex()
{
$consultas = new ConsultasDB();
$listUser = $consultas->getAllUser();
$this->render('index', array
("listUser" => $listUser));
}
In View I know show all information from database by loop listUser
foreach ($listUser->readAll() as $user)
{
echo 'Username : '.$user["username"].'<br>';
echo 'Password : '.$user["password"].'<br>';
}
but I don't know how to get a object with an index. Ex: User[1]... Thanks!
这是来自数据库的代码查询数据: p>
public function getAllUser(){
$ connect = Yii :: app() - &gt; db;
$ query =“SELECT * FROM user”;
$ statement = $ connect-&gt; CreateCommand($ query);
$ result = $ statement-&gt; query();
返回$ result;
}
code> pre>
之后我使用Controller获取数据&amp; 发送到视图: p>
public function actionIndex()
{
$ consultas = new ConsultasDB();
$ listUser = $ consultas-&gt; getAllUser();
$ this-&gt; render('index',array
(“listUser”=&gt; $ listUser));
}
code> pre>
在视图中我知道通过循环listUser显示来自数据库的所有信息 p>
foreach($ listUser-&gt; readAll()as $ user)
{
echo'Username:' 。$ user [“username”]。'&lt; br&gt;';
echo'Password:'。$ user [“password”]。'&lt; br&gt;';
}
code> pre>
但我不知道如何获取带索引的对象。 例如:用户[1] ...
谢谢! p>
div>
答
Add this in your view, before the foreach
loop
echo "<pre>";
print_r($listUser->readAll());
echo "</pre>";
Hope this helps you out.!