OrderList.php

<?php // <--- do NOT put anything before this PHP tag
include_once('./functions.php');

include('./views/partials/head.php');
include('./views/partials/navbar.php');

$heading = "Orders";
$bannerMessage = "Orders made on our platform so far.";
// $marqueeDuration = 9;
include('./views/partials/banner.php');
?>

<?php
$dbh = connectToDatabase();

$sql = "
SELECT
    o.OrderID,
    o.TimeStamp,
    SUM(op.Quantity) AS TotalItems,
    SUM(op.Quantity * p.Price) AS TotalPrice,
    c.CustomerID,
    c.UserName,
    c.FirstName,
    c.LastName,
    c.Address,
    c.City

FROM Orders o
LEFT JOIN OrderProducts op ON op.OrderID = o.OrderID
LEFT JOIN Products p ON p.ProductID = op.ProductID
JOIN Customers c ON o.CustomerID = c.CustomerID
GROUP BY
    o.OrderID, o.TimeStamp,
    c.CustomerID, c.UserName, c.FirstName, c.LastName, c.Address, c.City
";

$statement = $dbh->prepare($sql);
$statement->execute();
$rows = $statement->fetchAll(PDO::FETCH_ASSOC);
include('./views/OrderList.view.php');