当前位置：Gxlcms > PHP教程 > php二维数组根据相同id求和，并且限制条件

php二维数组根据相同id求和，并且限制条件

时间：2021-07-01 10:21:17 帮助过：33人阅读 

 '2015-2016-2',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '学雷锋做好事',
            'cname' => '社会活动模块',
            'period' => '16',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '会计从业资格证',
            'cname' => '科技创新模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-1',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '教师资格证',
            'cname' => '科技创新模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530111',
            'stu_name' => '雷雨',
            'stu_major' => '13视传1班',
            'depart_name' => '设计学院',
            'project_name' => '美术学',
            'cname' => '文体艺术模块',
            'period' => '15',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530108',
            'stu_name' => '周励',
            'stu_major' => '13产设1班',
            'depart_name' => '设计学院',
            'project_name' => 'DOM编程艺术',
            'cname' => '科技创新模块',
            'period' => '0',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530116',
            'stu_name' => '高颜',
            'stu_major' => '13陶艺2班',
            'depart_name' => '陶美学院',
            'project_name' => '音乐',
            'cname' => '文体艺术模块',
            'period' => '0',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530110',
            'stu_name' => '程风',
            'stu_major' => '13信管1班',
            'depart_name' => '信息学院',
            'project_name' => 'JavaScript高级程序设计',
            'cname' => '思想道德模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530112',
            'stu_name' => '苏环',
            'stu_major' => '13公事1班',
            'depart_name' => '人文学院',
            'project_name' => '音乐',
            'cname' => '文体艺术模块',
            'period' => '0',
            'credit' => '0'
        ),
   array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '美术学',
            'cname' => '文体艺术模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-1',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => 'DOM编程艺术',
            'cname' => '科技创新模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-1',
            'stu_id' => '201210530108',
            'stu_name' => '周励',
            'stu_major' => '13产设1班',
            'depart_name' => '设计学院',
            'project_name' => '美术学',
            'cname' => '文体艺术模块',
            'period' => '12',
            'credit' => '0'
        ),

);
    $tmp  = array();
    foreach($arr as $v) {

        if(!isset($tmp[$v['stu_id']])){
            $tmp[$v['stu_id']] = $v;
        }else {
            $tmp[$v['stu_id']]['period'] += $v['period'];
        }

    }
        
    
    echo "
";
    // 二维数组
    print_r(array_values($tmp));

?>


$arr是一个二维数组，数组里有相同的stu_id（学生学号），根据stu_id（学生学号）的period（学时），计算总的period（学时），我的实现方案是这样的。


    $tmp  = array();
    foreach($arr as $v) {

        if(!isset($tmp[$v['stu_id']])){
            $tmp[$v['stu_id']] = $v;
        }else {
            $tmp[$v['stu_id']]['period'] += $v['period'];
        }

    }
        
    
    echo "
";
    // 二维数组
    print_r(array_values($tmp));


但是，这只是实现了period（学时）相加。
我还需要加限制条件计算出数组和每个学生的总学分（credit），就是根据cname（模块名称），某个学生的每个模块（共四个模块，分别是思想道德模块、科技创新模块、文体艺术模块、社会活动模块）都需要大于等于16（四个模块同时都满足大于等于16），则这个学生的总学分为6.否则为0。


不知道怎么实现，特请教各位大神，在此先谢谢各位解答了。


                            
                        



                                                                                                                        
                     
回复内容：

                      
                                                            

 '2015-2016-2',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '学雷锋做好事',
            'cname' => '社会活动模块',
            'period' => '16',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '会计从业资格证',
            'cname' => '科技创新模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-1',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '教师资格证',
            'cname' => '科技创新模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530111',
            'stu_name' => '雷雨',
            'stu_major' => '13视传1班',
            'depart_name' => '设计学院',
            'project_name' => '美术学',
            'cname' => '文体艺术模块',
            'period' => '15',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530108',
            'stu_name' => '周励',
            'stu_major' => '13产设1班',
            'depart_name' => '设计学院',
            'project_name' => 'DOM编程艺术',
            'cname' => '科技创新模块',
            'period' => '0',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530116',
            'stu_name' => '高颜',
            'stu_major' => '13陶艺2班',
            'depart_name' => '陶美学院',
            'project_name' => '音乐',
            'cname' => '文体艺术模块',
            'period' => '0',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530110',
            'stu_name' => '程风',
            'stu_major' => '13信管1班',
            'depart_name' => '信息学院',
            'project_name' => 'JavaScript高级程序设计',
            'cname' => '思想道德模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530112',
            'stu_name' => '苏环',
            'stu_major' => '13公事1班',
            'depart_name' => '人文学院',
            'project_name' => '音乐',
            'cname' => '文体艺术模块',
            'period' => '0',
            'credit' => '0'
        ),
   array
        (
            'term' => '2015-2016-2',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => '美术学',
            'cname' => '文体艺术模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-1',
            'stu_id' => '201210530109',
            'stu_name' => '罗成',
            'stu_major' => '12热工1班',
            'depart_name' => '材料学院',
            'project_name' => 'DOM编程艺术',
            'cname' => '科技创新模块',
            'period' => '12',
            'credit' => '0'
        ),
    array
        (
            'term' => '2015-2016-1',
            'stu_id' => '201210530108',
            'stu_name' => '周励',
            'stu_major' => '13产设1班',
            'depart_name' => '设计学院',
            'project_name' => '美术学',
            'cname' => '文体艺术模块',
            'period' => '12',
            'credit' => '0'
        ),

);
    $tmp  = array();
    foreach($arr as $v) {

        if(!isset($tmp[$v['stu_id']])){
            $tmp[$v['stu_id']] = $v;
        }else {
            $tmp[$v['stu_id']]['period'] += $v['period'];
        }

    }
        
    
    echo "
";
    // 二维数组
    print_r(array_values($tmp));

?>


$arr是一个二维数组，数组里有相同的stu_id（学生学号），根据stu_id（学生学号）的period（学时），计算总的period（学时），我的实现方案是这样的。


    $tmp  = array();
    foreach($arr as $v) {

        if(!isset($tmp[$v['stu_id']])){
            $tmp[$v['stu_id']] = $v;
        }else {
            $tmp[$v['stu_id']]['period'] += $v['period'];
        }

    }
        
    
    echo "
";
    // 二维数组
    print_r(array_values($tmp));


但是，这只是实现了period（学时）相加。
我还需要加限制条件计算出数组和每个学生的总学分（credit），就是根据cname（模块名称），某个学生的每个模块（共四个模块，分别是思想道德模块、科技创新模块、文体艺术模块、社会活动模块）都需要大于等于16（四个模块同时都满足大于等于16），则这个学生的总学分为6.否则为0。


不知道怎么实现，特请教各位大神，在此先谢谢各位解答了。


                            
                        
            

                                    
$res = array();

        foreach($arr as $key => $value){
            if(!array_key_exists($value['stu_id'],$res)){
                
                $res[$value['stu_id']][$value['cname']] = $value['period'];
            }else{
                if(array_key_exists($value['cname'],$res[$value['stu_id']])){
                    $res[$value['stu_id']][$value['cname']] +=$value['period'];
                }else{
                    $res[$value['stu_id']][$value['cname']] = $value['period'];
                }
            }
        }
        
        $tmp  = array();
        foreach($arr as $v) {

            if(!isset($tmp[$v['stu_id']])){
                $tmp[$v['stu_id']] = $v;
            }else {
                $tmp[$v['stu_id']]['period'] += $v['period'];
            }

        }

        $result = array();
        foreach ($res as $key => $value) {
              $result[$key]['total_period'] = array_sum($value);

            foreach($value as $key1 => $value1){
                if($value1<16){
                    $result[$key]['total_credit']=0;
                    break;
                }
            }
            
        }
        $lastData = array();
        foreach ($tmp as $key => $value) {
            $lastData[$key]['term'] = $value['term'];
            $lastData[$key]['stu_id'] = $value['stu_id'];
              $lastData[$key]['stu_name'] = $value['stu_name'];
              $lastData[$key]["stu_major"] = $value['stu_major'];
              $lastData[$key]["depart_name"] = $value['depart_name'];
        }
        foreach ($result as $key => $value) {
            $lastData[$key]["total_period"] = $value['total_period'];
              $lastData[$key]["total_credit"] = $value['total_credit'];
        }

        
        $theLastData = array_values($lastData);

        echo "
";
        print_r($theLastData);
        exit;

                            
            

                                    
你的数据怎么来的 是从数据库中读取的吗？ 如果是 那么你的这些问题直接查询就出来了， 不需要用php逻辑处理~ 如果不是 那么逐条把数据存到数据库中 再查询得到想要的结果

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！