Yii数据读取与跳转参数传递用法实例分析

时间:2022-10-26 19:59:10

本文实例讲述了Yii数据读取与跳转参数传递用法。分享给大家供大家参考,具体如下:

?
1
2
3
4
5
6
7
8
9
10
11
12
$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的结果是:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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的结果:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
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传递的参数可以这样调用:

?
1
2
3
4
5
<?php
var_dump($toop);
var_dump($var1);
var_dump($var2);
?>

希望本文所述对大家基于Yii框架的PHP程序设计有所帮助。