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。