php - 如何在 php 中显示完整的月份日期和金额？

Question

我想在 php 中创建一个 xml 字符串，

我希望当交易date=$dates时，交易日期和相关金额从数据库中显示出来

如果交易 date!=$dates 则将 $date 存储在标签中，并且 amount=0 我该怎么做

这是我的 php 代码:

    <?php
function default1()
{
     $dates = array();
     $timestamp = time();
     for ($i = 1 ; $i <=30 ; $i++) 
     {
        $dates[$i]= date('Y-m-d', $timestamp) . '<br />';
        $timestamp -= 24 * 3600;
     }

        print_r ($dates);
    //echo date('Y-m-d', strtotime('-7 days'));
        $strQuery="select Distinct DATE_FORMAT(transactions.transaction_date,'%c-%d-%Y') as transaction_date,sum(amount)as Amount from transactions group by  DATE_FORMAT(transactions.transaction_date,'%c-%d-%Y')";       
        $result = $GLOBALS ['mysqli']->query ($strQuery) or die ($GLOBALS ['mysqli']->error . __LINE__);
        $strXML = "<chart caption='Reports of transactions' xAxisName='Date' yAxisName='Amount' showValues='0' useRoundEdges='1' palette='3'>";
        while($ors = $result->fetch_assoc ())
        {
            for ($i = 1 ; $i <=30 ; $i++)
            {
                if(in_array("'".$ors['transaction_date']."'", $dates[$i]))
                {
                    $strXML .= "<set label='" .$ors['transaction_date'] ."' value='" . $ors['Amount'] ."' />";
                }
                else
                {
                    $strXML .= "<set label='" .$dates."' value='0' />";
                }
            }
        }
        $strXML .= "</chart>";
        ?>
        <textarea><? print_r($strXML); ?></textarea>
     <?             
}

？>

Answer 1

请尝试此查询，

if(sum(金额)=0,0,sum(金额))作为金额

$strQuery="select Distinct DATE_FORMAT(transactions.transaction_date,'%c-%d-%Y') as transaction_date,if(sum(amount)=0,0,sum(amount))as Amount from transactions group by  DATE_FORMAT(transactions.transaction_date,'%c-%d-%Y')";