PHP开发的商城销售报表的生成方法

function getSalesData($start, $end) {
    $query = "SELECT product_id, SUM(quantity) as total_sales FROM orders WHERE order_date >= '$start' AND order_date <= '$end' GROUP BY product_id";

    // 执行查询语句并获取结果
    $result = mysqli_query($connection, $query);
    
    // 将结果存储到数组中
    $salesData = array();
    while($row = mysqli_fetch_assoc($result)) {
        $salesData[$row['product_id']] = $row['total_sales'];
    }
    
    return $salesData;
}

function generateReport($start, $end) {
    $salesData = getSalesData($start, $end);
    
    $html = '<table>';
    $html .= '<tr><th>产品ID</th><th>销售数量</th></tr>';
    
    foreach($salesData as $productId => $quantity) {
        $html .= '<tr>';
        $html .= '<td>'.$productId.'</td>';
        $html .= '<td>'.$quantity.'</td>';
        $html .= '</tr>';
    }
    
    $html .= '</table>';
    
    return $html;
}

function showReport($start, $end) {
    $report = generateReport($start, $end);
    
    echo $report;
}