本文实例讲述了Yii数据读取与跳转参数传递用法。分享给大家供大家参考,具体如下:
$toop=array('id'=>'aaaa','name'=>'bbbb','nickname'=>'ccccc','phone'=>'ddddd','status'=>'eeeeee','mytest'=>$te);
$test='hello world!';
$te="\$this->test='qweqw'";
$conn=Yii::app()->db;
$sql="select * from tbl_user";
$command=$conn->createCommand($sql);
$dataReader=$command->query();
//$rows=$dataReader->readAll();
while(($row=$dataReader->read())!==false) {
var_dump($row);
}
$this->render('index',array('toop'=>$toop,'var1'=>$test,'var2'=>$te));
$row的结果是:
array (size=4)
'id' => string '1' (length=1)
'username' => string 'test1' (length=5)
'password' => string 'pass1' (length=5)
'email' => string 'test1@example.com' (length=17)
array (size=4)
'id' => string '2' (length=1)
'username' => string 'test2' (length=5)
'password' => string 'pass2' (length=5)
'email' => string 'test2@example.com' (length=17)
array (size=4)
'id' => string '3' (length=1)
'username' => string 'test3' (length=5)
'password' => string 'pass3' (length=5)
'email' => string 'test3@example.com' (length=17)
$rows的结果:
array (size=21)
0 =>
array (size=4)
'id' => string '1' (length=1)
'username' => string 'test1' (length=5)
'password' => string 'pass1' (length=5)
'email' => string 'test1@example.com' (length=17)
1 =>
array (size=4)
'id' => string '2' (length=1)
'username' => string 'test2' (length=5)
'password' => string 'pass2' (length=5)
'email' => string 'test2@example.com' (length=17)
2 =>
array (size=4)
'id' => string '3' (length=1)
'username' => string 'test3' (length=5)
'password' => string 'pass3' (length=5)
'email' => string 'test3@example.com' (length=17)
3 =>
array (size=4)
'id' => string '4' (length=1)
'username' => string 'test4' (length=5)
'password' => string 'pass4' (length=5)
'email' => string 'test4@example.com' (length=17)
$dataReader->read() 与 $dataReader->readAll() 不能同时使用 当$dataReader->read()读完之后$dataReader->readAll()读取的为空,反之一样。
通过render传递的参数可以这样调用:
<?php
var_dump($toop);
var_dump($var1);
var_dump($var2);
?>
希望本文所述对大家基于Yii框架的PHP程序设计有所帮助。