Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[u.id](u.id) AS user_id, p.*, [c.quantity](c.quantity) FROM cart c JOIN produc' at line 1 in C:\OSPanel\domains\upautostore\cart.php:10 Stack trace: #0 C:\OSPanel\domains\upautostore\cart.php(10): mysqli->prepare() #1 {main} thrown in C:\OSPanel\domains\upautostore\cart.php on line 10
Как исправить эту ошибку?
<?php
session_start();
include 'inc/config.php';
if (!isset($_SESSION['user'])) {
header('Location: login.php');
}
// Объединяем два SQL-запроса в один
$cart_query = $mysqli->prepare("SELECT [u.id](u.id) AS user_id, p.*, [c.quantity](c.quantity)
FROM cart c JOIN products p ON [c.product_id](c.product_id) = [p.id](p.id)
JOIN users u ON [c.user_id](c.user_id) = [u.id](u.id)
WHERE [u.username](u.username) = ?");
$cart_query->bind_param("s", $_SESSION['user']);
$cart_query->execute();
$cart_result = $cart_query->get_result();
$total_price = 0;
?>
Простой
Средний