dth96108 2015-07-19 22:39
浏览 48
已采纳

PHP和MySQL字段的PHP总和回声

I have a database with the follow tables:

sales
expenses
taxes
earnings

When I sell some product it adds a item to sales, the same to expenses while I add expenses, taxes are added automaticly when selling and earnings too. They are on the same database but different tables.

I need to sum those fields together. I do it one by one without problems like this:

<?php
$query = mysqli_query($db, "SELECT SUM(total) AS `total` FROM `sales`");
while($result = mysqli_fetch_assoc($query)){
echo number_format($result['total'],0,',','.');} 
?>

and

<?php
$query2 = mysqli_query($db, "SELECT SUM(expense) AS `expense` FROM `expenses`");
while($result2 = mysqli_fetch_assoc($query2)){
echo number_format($result2['expense'],0,',','.');} 
?>

How do I sum those two and echo a result example:

sales - expense = value ?
  • 写回答

2条回答 默认 最新

  • douyu8187 2015-07-19 22:48
    关注
    <?php
        $query = mysqli_query($db, "SELECT SUM(total) AS `total` FROM `sales`");
        $query2 = mysqli_query($db, "SELECT SUM(expense) AS `expense` FROM `expenses`");
        $total_sales = 0;
        $total_expenses = 0;
        while($result = mysqli_fetch_assoc($query)){
            $total_sales = $total_sales + $result['total'];
            echo number_format($result['total'],0,',','.');
        }
        while($result2 = mysqli_fetch_assoc($query2)){
            $total_expenses = $total_expenses + $result['total'];
           echo number_format($result2['expense'],0,',','.');
       } 
    ?>
    

    The sum would be $total_sales-$total_expenses.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题