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" => "1" (length=1) "username" => "test1" (length=5) "password" => "pass1" (length=5) "email" => "test1@example.com" (length=17)
array (size=4) "id" => "2" (length=1) "username" => "test2" (length=5) "password" => "pass2" (length=5) "email" => "test2@example.com" (length=17)
array (size=4) "id" => "3" (length=1) "username" => "test3" (length=5) "password" => "pass3" (length=5) "email" => "test3@example.com" (length=17)
$rows的结果:
array (size=21)
0 =>
array (size=4)
"id" => "1" (length=1)
"username" => "test1" (length=5)
"password" => "pass1" (length=5)
"email" => "test1@example.com" (length=17)
1 =>
array (size=4)
"id" => "2" (length=1)
"username" => "test2" (length=5)
"password" => "pass2" (length=5)
"email" => "test2@example.com" (length=17)
2 =>
array (size=4)
"id" => "3" (length=1)
"username" => "test3" (length=5)
"password" => "pass3" (length=5)
"email" => "test3@example.com" (length=17)
3 =>
array (size=4)
"id" => "4" (length=1)
"username" => "test4" (length=5)
"password" => "pass4" (length=5)
"email" => "test4@example.com" (length=17)
$dataReader->read() 与 $dataReader->readAll() 不能同时使用 当$dataReader->read()读完之后$dataReader->readAll()读取的为空,反之一样。 通过render传递的参数可以这样调用: <?php var_dump($toop); var_dump($var1); var_dump($var2); ?>
声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。
