本文实例讲述了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程序设计有所帮助。