您好,登錄后才能下訂單哦!
這篇文章給大家介紹使用Yii怎么對行下的每列數(shù)據(jù)進(jìn)行遍歷,內(nèi)容非常詳細(xì),感興趣的小伙伴們可以參考借鑒,希望對大家能有所幫助。
具體如下:
效果圖如下:
控制器(1種):
//顯示列表 public function actionList() { //實(shí)例化對象 $model= new Qiu(); $country = \Yii::$app->db; //查詢數(shù)據(jù) $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(); //遍歷數(shù)組 $ids = array(); $names = array(); $count = array(); //遍歷區(qū)域ID foreach ($region_ids as $key => $v) { $ids[$key] = $v['region_id']; } //print_r($ids);die; //遍歷球隊(duì) foreach ($ids as $key => $val) { $data =Qiu::find()->where(['region_id'=>$val])->asArray()->all(); $count[]=count($data); $rows[$val] = $data; } //print_r($rows);die; //根據(jù)所有記錄進(jìn)行遍歷,顯示最多行數(shù) $ji = max($count); $arr = array(); //找出對應(yīng)的球隊(duì) 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; //分配數(shù)據(jù) return $this->render('list',['arr'=>$arr,'region'=>$region]); }
(2種):
public function actionList1() { //實(shí)例化模型層 $region = new Region; $qiu = new Qiu; //取出區(qū)域表的iQiud和所有數(shù)據(jù),隊(duì)表數(shù)據(jù) $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]); }
視圖層:
<table border="1"> <!--一行區(qū)域--> <tr > <?php foreach ($region as $key => $v1) {?> <td><?php echo $v1['region_name']; ?></td> <?php }?> </tr> <!--每列球隊(duì)--> <?php foreach ($arr as $key => $val) {?> <tr> <?php foreach ($val as $key => $v) {?> <td><?php echo $v; ?></td> <?php } ?> </tr> <?php } ?> </table>
關(guān)于使用Yii怎么對行下的每列數(shù)據(jù)進(jìn)行遍歷就分享到這里了,希望以上內(nèi)容可以對大家有一定的幫助,可以學(xué)到更多知識。如果覺得文章不錯(cuò),可以把它分享出去讓更多的人看到。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。