Php子总数和所有总数 [英] Php sub total and all the totals
本文介绍了Php子总数和所有总数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
<html>
<head>
</head>
<body>
<?php
include('connection.php');
$sql = mysqli_query($connection,"SELECT COALESCE(Customer.CustomerID, 'Sub Total') AS CustomerID,
Customer.CusName,
CusGroup.groupId,
Customer.CreditAllowed,
SUM(Customer.CreditAllowed) AS total
FROM Customer INNER JOIN CusGroup ON Customer.GroupID=CusGroup.groupId
GROUP BY CusGroup.groupId ,Customer.CustomerID with rollup");
echo '<table border="1" align="center" width="80%">
<thead>
<tr>
<td>CustomerId</td>
<td>CustomerName</td>
<td>Group Id</td>
<td>CreditLimit</td>
<td>Total</td>
</tr>
</thead>
<tbody>';
$total = 0;
while($row=mysqli_fetch_array($sql,MYSQLI_ASSOC)){
echo '<tr>
<td>'.$row['CustomerID'].'</td>
<td>'.$row['CusName'].'</td>
<td>'.$row['groupId'].'</td>
<td>'.$row['CreditAllowed'].'</td>
<td>'.number_format($row['total']).'</td>
</tr>';
$total +=$row['total'];
}
'</tbody>
</table>';
?>
</body>
</html>
我的尝试:
What I have tried:
i want sub total and all the totals of the sub total.but in sub total row i get unnecessary data allso plz check this and help me im new to programming.
推荐答案
sql = mysqli_query(
sql = mysqli_query(
connection,SELECT COALESCE(Customer.CustomerID,'Sub Total')AS CustomerID,
Customer.CusName,
CusGroup.groupId,
Customer.CreditAllowed,
SUM(Customer.CreditAllowed)AS total
FROM Customer INNER JOIN CusGroup ON Customer.GroupID = CusGroup。 groupId
GROUP BY CusGroup.groupId,Customer.CustomerID with rollup);
echo'< table border =1align =centerwidth =80%>
< thead>
< tr>
< td> CustomerId< / td>
< td>客户名称< / td>
< td> Group Id< / td>
< td> CreditLimit< / td>
< td>总计< / td>
< / tr>
< / thead>
< tbody>';
connection,"SELECT COALESCE(Customer.CustomerID, 'Sub Total') AS CustomerID, Customer.CusName, CusGroup.groupId, Customer.CreditAllowed, SUM(Customer.CreditAllowed) AS total FROM Customer INNER JOIN CusGroup ON Customer.GroupID=CusGroup.groupId GROUP BY CusGroup.groupId ,Customer.CustomerID with rollup"); echo '<table border="1" align="center" width="80%"> <thead> <tr> <td>CustomerId</td> <td>CustomerName</td> <td>Group Id</td> <td>CreditLimit</td> <td>Total</td> </tr> </thead> <tbody>';
total = 0;
while(
total = 0; while(
这篇关于Php子总数和所有总数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文