Система выдает мне ошибку "Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in models/orders.php on line 123

Есть функция "function getOrderTotals()", она подключена к таблице "Orders" и "Cakes" в БД.

function getOrderTotals()
{
    global $conn;
    
    $stmt = mysqli_prepare ($conn, 
        "SELECT (SUM(Cakes.Price) / 1.12) AS BeforeTaxPrice, (SUM(Cakes.Price) / 1.12 * 0.12) AS Tax, SUM(Cakes.Price) AS TotalPrice
        FROM INNER JOIN OrdersCakes ON Orders.OrderID = OrdersCakes.OrderID) INNER JOIN Cakes ON OrdersCakes.CakeID = Cakes.CakeID
        WHERE Orders.OrderID=?;");

mysqli_stmt_bind_param($stmt, "i", $OrderID); //line 123
$success = mysqli_stmt_execute($stmt); //line 124
$result = mysqli_stmt_get_result($stmt); //line 125

$resultArr = false;

    if($success && mysqli_num_rows($result)>=0)
    {
        $resultArr = mysqli_fetch_all($result, MYSQLI_ASSOC);
    }
    
    return $resultArr;
}

ВОТ ВСЕ ОШИБКИ КОТОРЫЕ ВЫДАЕТ СИСТЕМА:

Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/jad/public_html/Cakeshop/models/orders.php on line 123

Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/jad/public_html/Cakeshop/models/orders.php on line 124

Warning: mysqli_stmt_get_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/jad/public_html/Cakeshop/models/orders.php on line 125

Что мне делать чтобы исправить эти ошибки?


Ответы (0 шт):