在列表yii php中获取具有对象索引的对象

在列表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.!