Untitled

<!DOCTYPE html>
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
mysqli_select_db($conn, 'shop');
$query = "SELECT * FROM `product`;";
$result = mysqli_query($conn, $query) or trigger_error(mysqli_error($conn));

?>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Shop</title>
    <!-- Compiled and minified CSS -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.100.2/css/materialize.min.css">

    <!-- Compiled and minified JavaScript -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.100.2/js/materialize.min.js"></script>
</head>
<body>
<div class="navbar-fixed">
    <nav>
        <div class="nav-wrapper">
            <a href="#" class="brand-logo center">Shop</a>
            <ul id="nav-mobile" class="left hide-on-med-and-down">
                <li><a href="cart.php">Cart</a></li>
            </ul>
        </div>
    </nav>
</div>
<div class="container">
    <div class="row">
        <?php
        $email = $_COOKIE["email"];
        $userIDsql = "SELECT UserID FROM user WHERE user.email = '$email'";
        $userID = mysqli_query($conn,$userIDsql);
        $cartquerysql = "SELECT CartID FROM user,cart WHERE user.email = '$email' AND user.UserID = cart.UserID";
        $cartquery = mysqli_query($conn,$cartquerysql);
        $date = time();
        $cartrow = mysqli_fetch_row($cartquery);
        if ($cartrow[0] == 0) {
            $useridrow = mysqli_fetch_row($userID);
            $sql = "INSERT INTO cart (UserID, CreatedDate) VALUES ('$useridrow[0]', '$date'); ";
            $retval = mysqli_query($conn, $sql);
            if (!$retval) {
                die('Could not enter data: ' . mysqli_error($conn));
                $enterdata = 'Unsuccessfully';
            } else {
                $enterdata = 'Successfully';
            }
        }
        while ($row = mysqli_fetch_row($result)){
            echo '<div class="col s12 m4 l4 xl4">';
            echo '<div class="card hoverable">';
            echo '<div class="card-image">';
            echo '<img src="' . $row[5] . '"/>';
            echo '<span class="card-title">'.$row[1].'</span>';
            echo '</div>';
            echo '<div class="card-content">';
            echo '<p>'.$row[1].' delivered to your door, securely packaged and delivered via express post.</p>';
            echo '</div>';
            echo '<div class="card-action">';
            echo '<span>';
            echo $row[2];
            echo ' AUD </span>';
            echo '<form action="buy.php" method="post">';
            echo '';
            echo '<a href="#" class="right">Add to Cart</a>';
            echo '</form>';
            echo '</div>';
            echo '</div>';
            echo '</div>';
        }
        ?>
    </div>
</div>
</body>
</html>