PHP结帐页面无法使用“找不到对象”错误

Question

I was just wondering if I could get some help with this big website project I have for my introductory web programming class. The website is supposed to be a little online store with a home page, a shop page, and a checkout page.

I cannot seem to get the checkout page to work, as when I grade the assignment it gives me 7 "object not found" errors.

My professor told me that I have 1 extra character in my SQL that causes a critical error but I cannot find it for the life of me.

Here's my code:

<?php

    session_start();

    //include php library

    include("website 01 library.php");

    echo "<h1 id = 'header' class = ''>CHECKOUT</h1>";

    $category = $_SESSION[category];

    $host_name = "localhost";

    $user_name = "web";

    $password = "programming";

    $database = "assignments";

    $connection = mysqli_connect($host_name, $user_name, $password, $database);

    $sql = "select * from cart, product, where cart.productid = product.productid";

    $recordSet = mysqli_query($connection, $sql);

    $total = 0;

    // Process the recordset in a loop

    while ($record = mysqli_fetch_array($recordSet, MYSQLI_ASSOC)) {

        $productid = $record[productid];

        $title = $record[title];

        $quantity = $record[quantity];

        $price = $record[price];

        $totalCost = $price * $quantity;

        $total = $total + $totalCost;

        // product name

        echo "<td id = 'title_$productid' class = ''>$title</td>";

        // quantity purchased

        echo "<td id = 'quantity_$productid' class = ''>$quantity</td>";

        //price

        echo "<td id = 'price_$productid' class = ''>$price</td>";

        $totalCost_productid = $totalCost_productid + $price;

        //echo "<td id = 'totalCost_$productid = quantity_$productid * price_$productid></td>";
        // total cost for product (calculate as quantity * price)
        //echo "<td id = 'totalCost_$productid' class = ''></td>";

        mysqli_close($connection);

        mysqli_free_result($recordSet);

    };

    echo "<td id = 'total' class = ''>$total</td>";

    echo $totalCost_productid;

    mysqli_close($connection);

    mysqli_free_result($recordSet);

    echo "<table class = '' border = 1>";

        echo "PRODUCT<tr>";

        echo "<td class = ''></td>";

        echo "<td class = ''></td>";

    echo "</tr>";

    echo "QUANTITY<tr>";

    echo "<td class = ''></td>";

    echo "<td class = ''></td>";

echo "</tr>";

echo "<table class = '' border = 1>";

    echo "PRICE<tr>";

    echo "<td class = ''></td>";

    echo "<td class = ''></td>";

echo "</tr>";

echo "TOTAL COST<tr>";

echo "<td class = ''></td>";

echo "<td class = ''></td>";

echo "</tr>";

echo "</table>";

?>

Any help would be greatly appreciated.