Home >Backend Development >PHP Tutorial >php 二维数组根据相同id求和，并且限制条件
php 二维数组根据相同id求和，并且限制条件
- WBOYOriginal
- 2016-06-06 20:10:251213browse
<code><?php header('Content-Type: text/plain;charset=utf-8');
$arr = array
(
array
(
'term' => '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 "<pre class="brush:php;toolbar:false">";
// 二维数组
print_r(array_values($tmp));
?>
$arr是一个二维数组，数组里有相同的stu_id（学生学号），根据stu_id（学生学号）的period（学时），计算总的period（学时），我的实现方案是这样的。
<code> $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 "<pre class="brush:php;toolbar:false">";
// 二维数组
print_r(array_values($tmp));
但是，这只是实现了period（学时）相加。
我还需要加限制条件计算出数组和每个学生的总学分（credit），就是根据cname（模块名称），某个学生的每个模块（共四个模块，分别是思想道德模块、科技创新模块、文体艺术模块、社会活动模块）都需要大于等于16（四个模块同时都满足大于等于16），则这个学生的总学分为6.否则为0。
不知道怎么实现，特请教各位大神，在此先谢谢各位解答了。
回复内容：
<code><?php header('Content-Type: text/plain;charset=utf-8');
$arr = array
(
array
(
'term' => '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 "<pre class="brush:php;toolbar:false">";
// 二维数组
print_r(array_values($tmp));
?>
$arr是一个二维数组，数组里有相同的stu_id（学生学号），根据stu_id（学生学号）的period（学时），计算总的period（学时），我的实现方案是这样的。
<code> $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 "<pre class="brush:php;toolbar:false">";
// 二维数组
print_r(array_values($tmp));
但是，这只是实现了period（学时）相加。
我还需要加限制条件计算出数组和每个学生的总学分（credit），就是根据cname（模块名称），某个学生的每个模块（共四个模块，分别是思想道德模块、科技创新模块、文体艺术模块、社会活动模块）都需要大于等于16（四个模块同时都满足大于等于16），则这个学生的总学分为6.否则为0。
不知道怎么实现，特请教各位大神，在此先谢谢各位解答了。
<code>$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 $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 "<pre class="brush:php;toolbar:false">";
print_r($theLastData);
exit;
你的数据怎么来的 是从数据库中读取的吗？ 如果是 那么你的这些问题直接查询就出来了， 不需要用php逻辑处理~ 如果不是 那么逐条把数据存到数据库中 再查询得到想要的结果
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql to_days()这个函数怎么用的Next article：请问七牛能给文件提供真实的长期下载地址吗?