快捷導(dǎo)航

Yii遍歷行下每列數(shù)據(jù)的方法

更新時(shí)間：2016年10月17日 14:55:42 作者：Love滿天星

這篇文章主要介紹了Yii遍歷行下每列數(shù)據(jù)的方法,結(jié)合實(shí)例形式分析了Yii框架下數(shù)據(jù)遍歷的相關(guān)操作技巧,需要的朋友可以參考下

本文實(shí)例講述了Yii遍歷行下每列數(shù)據(jù)的方法。分享給大家供大家參考，具體如下：

效果圖如下：

控制器(1種)：

//顯示列表
public function actionList()
{
    //實(shí)例化對(duì)象
    $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();
    //找出對(duì)應(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 style="background:red;">
<?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相關(guān)內(nèi)容感興趣的讀者可查看本站專(zhuān)題：《Yii框架入門(mén)及常用技巧總結(jié)》、《php優(yōu)秀開(kāi)發(fā)框架總結(jié)》、《smarty模板入門(mén)基礎(chǔ)教程》、《php面向?qū)ο蟪绦蛟O(shè)計(jì)入門(mén)教程》、《php字符串(string)用法總結(jié)》、《php+mysql數(shù)據(jù)庫(kù)操作入門(mén)教程》及《php常見(jiàn)數(shù)據(jù)庫(kù)操作技巧匯總》

希望本文所述對(duì)大家基于Yii框架的PHP程序設(shè)計(jì)有所幫助。

您可能感興趣的文章: