如果有人可以幫助我解決正在發(fā)生的問題，我將非常感激。使用 PDO 連接的 bind_param () 會出現(xiàn)錯誤。致命錯誤：在第 25 行調(diào)用未定義的方法 PDOStatement::bind_param()setlocale(LC_MONETARY,"en_US");if(isset($_POST["id"])) {foreach($_POST as $key => $value){ $product[$key] = filter_var($value, FILTER_SANITIZE_STRING);} $statement = app('db')->prepare("SELECT as_produtos.nome, as_produtos.preco FROM as_produtos WHERE id = ? LIMIT 1");$statement->bind_param('s', $product['id']);$statement->execute();$statement->bind_result($product_name, $product_price);while($statement->fetch()){ $product["product_name"] = $product_name; $product["product_price"] = $product_price; if(isset($_SESSION["products"])){ if(isset($_SESSION["products"][$product['id']])) { $_SESSION["products"][$product['id']]["product_qty"] = $_SESSION["products"][$product['id']]["product_qty"] + $_POST["product_qty"]; } else { $_SESSION["products"][$product['id']] = $product; } } else { $_SESSION["products"][$product['id']] = $product; } } $total_product = count($_SESSION["products"]);die(json_encode(array('products'=>$total_product)));}if(isset($_GET["remove_code"]) && isset($_SESSION["products"])) {$product_code = filter_var($_GET["remove_code"], FILTER_SANITIZE_STRING);if(isset($_SESSION["products"][$product_code])) { unset($_SESSION["products"][$product_code]);} $total_product = count($_SESSION["products"]);die(json_encode(array('products'=>$total_product)));}if(isset($_GET["update_quantity"]) && isset($_SESSION["products"])) { if(isset($_GET["quantity"]) && $_GET["quantity"]>0) { $_SESSION["products"][$_GET["update_quantity"]]["product_qty"] = $_GET["quantity"]; }$total_product = count($_SESSION["products"]);die(json_encode(array('products'=>$total_product)));}
2 回答
qq_花開花謝_0
TA貢獻(xiàn)1835條經(jīng)驗 獲得超7個贊
我猜你是想打電話給bindParam。
也沒有名為 bind_result 的函數(shù)（檢查：PDO 上 bind_result 的等價物是什么）。
此外，您試圖綁定參數(shù) (':s')，但是有 '?' 在您的請求字符串中。
$statement = app('db')->prepare("SELECT as_produtos.nome, as_produtos.preco FROM as_produtos WHERE id = :s LIMIT 1");
$statement->bindParam(':s', $product['id']);或者使用bindValue。
絕地?zé)o雙
TA貢獻(xiàn)1946條經(jīng)驗 獲得超4個贊
正確的代碼（購物車）確定：
setlocale(LC_MONETARY,"pt_BR");
# add products in cart
if(isset($_POST["id"])) {
foreach($_POST as $key => $value) :
$product[$key] = filter_var($value, FILTER_SANITIZE_STRING);
endforeach;
$statement = app('db')->prepare("SELECT as_produtos.nome, as_produtos.preco FROM
as_produtos WHERE id = :id LIMIT 1");
$statement->bindParam(':id', $product['id'], PDO::PARAM_INT);
$statement->execute();
foreach($statement as $dados_produto) :
$product["product_name"] = $dados_produto["nome"];
$product["product_price"] = $dados_produto["preco"];
if(isset($product["product_name"])){
if(isset($_SESSION["products"][$product['id']])) {
$_SESSION["products"][$product['id']]["product_qty"] = $_SESSION["products"][$product['id']]["product_qty"] + $_POST["product_qty"];
} else {
$_SESSION["products"][$product['id']] = $product;
}
} else {
$_SESSION["products"][$product['id']] = $product;
}
endforeach;
$total_product = count($_SESSION["products"]);
die(json_encode(array('products'=>$total_product)));
}
# Remove products from cart
if(isset($_GET["remove_code"]) && isset($_SESSION["products"])) {
$product_code = filter_var($_GET["remove_code"], FILTER_SANITIZE_STRING);
if(isset($_SESSION["products"][$product_code])) {
unset($_SESSION["products"][$product_code]);
}
$total_product = count($_SESSION["products"]);
die(json_encode(array('products'=>$total_product)));
}
# Update cart product quantity
if(isset($_GET["update_quantity"]) && isset($_SESSION["products"])) {
if(isset($_GET["quantity"]) && $_GET["quantity"]>0) {
$_SESSION["products"][$_GET["update_quantity"]]["product_qty"] =
$_GET["quantity"];
}
$total_product = count($_SESSION["products"]);
die(json_encode(array('products'=>$total_product)));
}
- 2 回答
- 0 關(guān)注
- 202 瀏覽
添加回答
舉報
0/150
提交
取消