21,893
社区成员




foreach($rows as $row){
$data[$row['banji']]['rows'][] = $row;
$data[$row['banji']]['zongkeshi'] = $row['keshi'] + @$data[$row['banji']]['zongkeshi'];
}
//$data = array_values($data); //如果你不想要关联数组...
var_dump($data);
ps:怎么不能编辑自己回的帖子啊,也不能删除?
[
['banji'=>'一班','keshi'=>3],
['banji'=>'二班','keshi'=>4]
]
那么就可以这样来统计
foreach($rows as $row){
$data[$row['banji']] = $row;
$data[$row['banji']]['zongkeshi'] = $row['keshi'] + @$data[$row['banji']]['zongkeshi'];
}
//$data = array_values($data); //如果你不想要关联数组...
var_dump($data);
<?php
// 基本信息
$servername = "localhost";
$username = "recode";
$password = "recode_passwd";
$db_name = "recode";
$dsn = "mysql:host=$servername;dbname=$db_name";
try {
// 对数据库进行连接
$conn = new PDO($dsn, $username, $password);
$sql = "select Cname,sum(Credit) as cred from course GROUP BY Cname";
//获取一个二维数组
$stms = $conn->query($sql)->fetchAll();
//var_dump($stms);
// foreach ($stms as $arr){
// var_dump($arr);
// echo $arr['Cname']."的总学分为:".$arr['cred']."<br>";
// }
echo "<table border='1' cellpadding='5' cellspacing='0' align='center' width='60%'>";
echo "<tr align='center' bgcolor='#87ceeb'>";
echo "<td>";
echo "课程名";
echo "</td>";
echo "<td>";
echo "课程总学分";
echo "</td>";
echo "</tr>";
//遍历二维数组
foreach ($stms as $arr) {
echo "<tr align='center'>";
echo "<td>";
echo $arr['Cname'];
echo "</td>";
echo "<td>";
echo $arr['cred'];
echo "</td>";
echo "</tr>";
}
echo "</table>";
}
catch(PDOException $e)
{
echo $e->getMessage();
}
查询的结果如下: