本文实例讲述了yii遍历行下每列数据的方法。分享给大家供大家参考，具体如下：
效果图如下：
控制器(1种)：
|
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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
//显示列表public function actionlist(){ //实例化对象 $model= new qiu(); $country = \yii::$app->db; //查询数据 $data = $country->createcommand("select * from qiu join region on qiu.region_id=region.region_id")->queryall(); $region_ids = $country->createcommand("select region_id from region")->queryall(); $region = $country->createcommand("select * from region")->queryall(); //遍历数组 $ids = array(); $names = array(); $count = array(); //遍历区域id foreach ($region_ids as $key => $v) { $ids[$key] = $v['region_id']; } //print_r($ids);die; //遍历球队 foreach ($ids as $key => $val) { $data =qiu::find()->where(['region_id'=>$val])->asarray()->all(); $count[]=count($data); $rows[$val] = $data; } //print_r($rows);die; //根据所有记录进行遍历,显示最多行数 $ji = max($count); $arr = array(); //找出对应的球队 for($i=0;$i<$ji;$i++) { foreach($rows as $key => $val) { if(isset($val[$i])) { $arr[$i][$key] = $val[$i]['q_name']; } else { $arr[$i][$key] = ''; } } } //var_dump($arr);die; //分配数据 return $this->render('list',['arr'=>$arr,'region'=>$region]);} |
(2种)：
|
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
26
27
28
29
30
31
32
33
34
|
public function actionlist1(){ //实例化模型层 $region = new region; $qiu = new qiu; //取出区域表的iqiud和所有数据,队表数据 $region_ids = $region->find()->select('region_id')->column(); $areas = $region->find()->asarray()->all(); $team = $qiu->find()->asarray()->all(); $count = array(); $info = array(); foreach ($region_ids as $aid) {//1,2,3--6 foreach ($team as $key=>$val) { if($val['region_id'] == $aid){ $info[$aid][] = $val; $count[]=count($info[$aid]); } } } //var_dump($count);die; $con = max($count); $arr = array(); for ($i=0; $i <$con ; $i++) { foreach ($info as $key => $val) { if(isset($val[$i])){ $arr[$i][$key] = $val[$i]['q_name']; } else { $arr[$i][$key] = ''; } } } //var_dump($arr);die; return $this->render('list',['arr'=>$arr,'region'=>$areas]);} |
视图层：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
<table border="1"><!--一行区域--><tr style="background:red;"><?php foreach ($region as $key => $v1) {?><td><?php echo $v1['region_name']; ?></td><?php }?></tr><!--每列球队--><?php foreach ($arr as $key => $val) {?><tr><?php foreach ($val as $key => $v) {?><td><?php echo $v; ?></td><?php } ?></tr><?php } ?></table> |
希望本文所述对大家基于yii框架的php程序设计有所帮助。
