A. php怎麼做購物車
購物車
有兩種實現方式，一種是保存在資料庫，另外一種是session
保存在資料庫的不會以為關閉瀏覽器而消失，session會因為關閉瀏覽器就沒有了。
原理是把每個商品的信息存到一個數組裡面，然後以這個商品的id作為鍵值，然後吧數組存到session裡面就行，
如果是存入資料庫的話，就用關聯數據存一下就行的
B. 如何用html css javascript php製作購物車
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<link rel="stylesheet" href="---.css">
<script src="---.js"></script>
</head>
<body>
<div class="container">
<div class="shop">
<div class="header">
<input type="checkbox" class="shop-checkbox">
<span class="shop-icon"></span>
<span class="shop-name">---</span>
<span class="wangwang-icon"></span>
</div>
<div class="items">
<div class="item">
<div><input class="item-checkbox" type="checkbox" name="" id=""></div>
<div>
<span class="item-img"></span>
</div>
<div class="item-name">
<div>----</div>
<div class="promotion-icons"><span></span><span></span><span></span></div>
</div>
<div class="sku">---</div>
<div class="price">
<div class="price-1">---</div>
<div class="price-2" data-price="---">----</div>
</div>
<div class="num-control">
<span class="num-minus">-</span>
<input class="num" type="text" value="1">
<span class="num-plus">+</span>
</div>
<div class="item-price-total">
<span>￥50.13</span>
</div>
<div class="operation">
<div>---</div>
<div>---</div>
</div>
</div>
</div>
</div>
<div class="shop">
<div class="header">
<input type="checkbox" class="shop-checkbox">
<span class="shop-icon"></span>
<span class="shop-name">---</span>
<span class="wangwang-icon"></span>
</div>
<div class="items">
<div class="item">
<div><input class="item-checkbox" type="checkbox" name="" id=""></div>
<div>
<span class="item-img"></span>
</div>
<div class="item-name">
<div>----</div>
<div class="promotion-icons"><span></span><span></span><span></span></div>
</div>
<div class="sku">---</div>
<div class="price">
<div class="price-1">---</div>
<div class="price-2" data-price="---">---</div>
</div>
<div class="num-control">
<span class="num-minus">-</span>
<input class="num" type="text" value="1">
<span class="num-plus">+</span>
</div>
<div class="item-price-total">
<span>￥9.90</span>
</div>
<div class="operation">
<div>移入收藏夾</div>
<div>刪除</div>
</div>
</div>
<div class="item">
<div><input class="item-checkbox" type="checkbox" name="" id=""></div>
<div>
<span class="item-img"></span>
</div>
<div class="item-name">
<div>---</div>
<div class="promotion-icons"><span></span><span></span><span></span></div>
</div>
<div class="sku">---</div>
<div class="price">
<div class="price-1">---</div>
<div class="price-2" data-price="---">---</div>
</div>
<div class="num-control">
<span class="num-minus">-</span>
<input class="num" type="text" value="1">
<span class="num-plus">+</span>
</div>
<div class="item-price-total">
<span>￥19.9</span>
</div>
<div class="operation">
<div>移入收藏夾</div>
<div>刪除</div>
</div>
</div>
</div>
</body>
</html>
.container{
width: 1000px;
margin-left: auto;
margin-right: auto;
color: #444444;
}
.header{
margin: 8px;
}
.shop-icon, .wangwang-icon, .promotion-icons span{
display:inline-block;
width: 15px;
height: 15px;
background-color: rgb(117,192,241);
}
.promotion-icons span{
margin-right: 4px;
}
.items{
border: 1px solid #ebe9e9;
}
.item{
display: flex;
margin: 8px;
}
.item-img{
width:100px;
height: 100px;
display: inline-block;
background-color: aquamarine;
margin-left: 6px;
margin-right: 6px;
}
.item-name
{
display: flex;
flex-direction: column;
justify-content: space-between;
}
.sku, .price,.item-price-total,.operation,.num-control{
margin-left: 18px;
}
.num{
width: 18px;
height: 15px;
}
.num-control{
display: flex;
align-items: baseline;
}
.num-minus,.num-plus{
width: 18px;
height: 22px;
display: inline-block;
background-color: #ebe9e9;
}
.checkout{
display: flex;
justify-content: space-between;
}
.shop{
margin-bottom: 20px;
margin-top: 30px;
}
.goods,.freight,.checkout-button{
margin-left: 15px;
}
.price-1{
text-decoration: line-through;
color: gray;
}
.check-num ,.total-price{
font-size: large;
color: red;
margin-left: 3px;
margin-right: 3px;
}
.checkout-button{
height: 30px;
width: 50px;
background-color: beige;
}
.checkout{
margin-top: 15px;
}
.item-name{
width: 25%;
}
.item-price-total{
width: 5%;
}
.sku{
width: 20%;
}
function updatePrice(){
let items = document.querySelectorAll('.item');
let totalNum = 0;
let totalPrice = 0;
items.forEach(function(item){
if(item.querySelector('.item-checkbox').checked){
let num = item.querySelector('.num').value;
totalNum = totalNum + parseInt(num);
let price = item.querySelector('.price-2').getAttribute('data-price');
totalPrice = totalPrice + parseFloat(price) * num;
}
});
document.querySelector('.check-num').innerText= totalNum;
document.querySelector('.total-price').innerText = totalPrice;
}
window.onload=function(){
let itemCheckboxes = document.querySelectorAll('.item-checkbox');
itemCheckboxes.forEach(function(itemCheckbox){
itemCheckbox.onchange = function(){
updatePrice();
}
});
let minuses = document.querySelectorAll('.num-minus');
minuses.forEach(function(minus){
minus.onclick = function(event){
let num=minus.parentElement.querySelector('.num').value;
if(parseInt(num)>1)
{
minus.parentElement.querySelector('.num').value=parseInt(num)-1;
updatePrice();
}
};
});
let pluses = document.querySelectorAll('.num-plus');
pluses.forEach(function(plus){
plus.onclick = function(event){
let num=plus.parentElement.querySelector('.num').value;
plus.parentElement.querySelector('.num').value=parseInt(num)+1;
updatePrice();
}
});
}
C. php的購物車中的數組在下訂單時怎樣傳到資料庫中
在資料庫中弄一個設置一個數組欄位，然後接受ID
SQL語句查詢，正常輸出；
打算數組：
$infoarray=explode('|,|',$row[infoarray']);
然後輸出：
<?php echo infoarray$infoarray[0]?> //例如：數量
<?php echo infoarray$infoarray[1]?> //例如：單價（當然可以更多...）
D. 請教關於PHP購物車代碼的資料庫表和欄位
PHP Code
<div id="procts-wrapper">
<h1>Procts</h1>
<div class="procts">
<?php
//current URL of the Page. cart_update.php redirects back to this URL
$current_url = base64_encode($url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']);
$results = $mysqli->query("SELECT * FROM cart ORDER BY id ASC");
if ($results) {
//fetch results set as object and output HTML
while($obj = $results->fetch_object())
{
echo '<div class="proct">';
echo '<form method="post" action="cart_update.php">';
echo '<div class="proct-thumb"><img src="images/'.$obj->proct_img_name.'"></div>';
echo '<div class="proct-content"><h3>'.$obj->proct_name.'</h3>';
echo '<div class="proct-desc">'.$obj->proct_desc.'</div>';
echo '<div class="proct-info">';
echo 'Price '.$currency.$obj->price.' | ';
echo 'Qty <input type="text" name="proct_qty" value="1" size="3" />';
echo '<button class="add_to_cart">Add To Cart</button>';
echo '</div></div>';
echo '<input type="hidden" name="proct_code" value="'.$obj->proct_code.'" />';
echo '<input type="hidden" name="type" value="add" />';
echo '<input type="hidden" name="return_url" value="'.$current_url.'" />';
echo '</form>';
echo '</div>';
}
}
?>
</div>
<div class="shopping-cart">
<h2>Your Shopping Cart</h2>
<?php
if(isset($_SESSION["procts"]))
{
$total = 0;
echo '<ol>';
foreach ($_SESSION["procts"] as $cart_itm)
{
echo '<li class="cart-itm">';
echo '<span class="remove-itm"><a href="cart_update.php?removep='.$cart_itm["code"].'&return_url='.$current_url.'">×</a></span>';
echo '<h3>'.$cart_itm["name"].'</h3>';
echo '<div class="p-code">P code : '.$cart_itm["code"].'</div>';
echo '<div class="p-qty">Qty : '.$cart_itm["qty"].'</div>';
echo '<div class="p-price">Price :'.$currency.$cart_itm["price"].'</div>';
echo '</li>';
$subtotal = ($cart_itm["price"]*$cart_itm["qty"]);
$total = ($total + $subtotal);
}
echo '</ol>';
echo '<span class="check-out-txt"><strong>Total : '.$currency.$total.'</strong> <a href="view_cart.php">Check-out!</a></span>';
echo '<span class="empty-cart"><a href="cart_update.php?emptycart=1&return_url='.$current_url.'">Empty Cart</a></span>';
}else{
echo 'Your Cart is empty';
}
?>
</div>
cart_update.php
PHP Code
<?php
session_start();
include_once("config.php");
//empty cart by distroying current session
if(isset($_GET["emptycart"]) && $_GET["emptycart"]==1)
{
$return_url = base64_decode($_GET["return_url"]); //return url
session_destroy();
header('Location:'.$return_url);
}
//add item in shopping cart
if(isset($_POST["type"]) && $_POST["type"]=='add')
{
$proct_code = filter_var($_POST["proct_code"], FILTER_SANITIZE_STRING); //proct code
$proct_qty = filter_var($_POST["proct_qty"], FILTER_SANITIZE_NUMBER_INT); //proct code
$return_url = base64_decode($_POST["return_url"]); //return url
//limit quantity for single proct
if($proct_qty > 10){
die('<div align="center">This demo does not allowed more than 10 quantity!<br /><a href="http://sanwebe.com/assets/paypal-shopping-cart-integration/">Back To Procts</a>.</div>');
}
//MySqli query - get details of item from db using proct code
$results = $mysqli->query("SELECT proct_name,price FROM cart WHERE proct_code='$proct_code' LIMIT 1");
$obj = $results->fetch_object();
if ($results) { //we have the proct info
//prepare array for the session variable
$new_proct = array(array('name'=>$obj->proct_name, 'code'=>$proct_code, 'qty'=>$proct_qty, 'price'=>$obj->price));
if(isset($_SESSION["procts"])) //if we have the session
{
$found = false; //set found item to false
foreach ($_SESSION["procts"] as $cart_itm) //loop through session array
{
if($cart_itm["code"] == $proct_code){ //the item exist in array
$proct[] = array('name'=>$cart_itm["name"], 'code'=>$cart_itm["code"], 'qty'=>$proct_qty, 'price'=>$cart_itm["price"]);
$found = true;
}else{
//item doesn't exist in the list, just retrive old info and prepare array for session var
$proct[] = array('name'=>$cart_itm["name"], 'code'=>$cart_itm["code"], 'qty'=>$cart_itm["qty"], 'price'=>$cart_itm["price"]);
}
}
if($found == false) //we didn't find item in array
{
//add new user item in array
$_SESSION["procts"] = array_merge($proct, $new_proct);
}else{
//found user item in array list, and increased the quantity
$_SESSION["procts"] = $proct;
}
}else{
//create a new session var if does not exist
$_SESSION["procts"] = $new_proct;
}
}
//redirect back to original page
header('Location:'.$return_url);
}
//remove item from shopping cart
if(isset($_GET["removep"]) && isset($_GET["return_url"]) && isset($_SESSION["procts"]))
{
$proct_code = $_GET["removep"]; //get the proct code to remove
$return_url = base64_decode($_GET["return_url"]); //get return url
foreach ($_SESSION["procts"] as $cart_itm) //loop through session array var
{
if($cart_itm["code"]!=$proct_code){ //item does,t exist in the list
$proct[] = array('name'=>$cart_itm["name"], 'code'=>$cart_itm["code"], 'qty'=>$cart_itm["qty"], 'price'=>$cart_itm["price"]);
}
//create a new proct list for cart
$_SESSION["procts"] = $proct;
}
//redirect back to original page
header('Location:'.$return_url);
}
?>
view_cart.php
PHP Code
<div class="view-cart">
<?php
$current_url = base64_encode($url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']);
if(isset($_SESSION["procts"]))
{
$total = 0;
echo '<form method="post" action="paypal-express-checkout/process.php">';
echo '<ul>';
$cart_items = 0;
foreach ($_SESSION["procts"] as $cart_itm)
{
$proct_code = $cart_itm["code"];
$results = $mysqli->query("SELECT proct_name,proct_desc, price FROM cart WHERE proct_code='$proct_code' LIMIT 1");
$obj = $results->fetch_object();
echo '<li class="cart-itm">';
echo '<span class="remove-itm"><a href="cart_update.php?removep='.$cart_itm["code"].'&return_url='.$current_url.'">×</a></span>';
echo '<div class="p-price">'.$currency.$obj->price.'</div>';
echo '<div class="proct-info">';
echo '<h3>'.$obj->proct_name.' (Code :'.$proct_code.')</h3> ';
echo '<div class="p-qty">Qty : '.$cart_itm["qty"].'</div>';
echo '<div>'.$obj->proct_desc.'</div>';
echo '</div>';
echo '</li>';
$subtotal = ($cart_itm["price"]*$cart_itm["qty"]);
$total = ($total + $subtotal);
echo '<input type="hidden" name="item_name['.$cart_items.']" value="'.$obj->proct_name.'" />';
echo '<input type="hidden" name="item_code['.$cart_items.']" value="'.$proct_code.'" />';
echo '<input type="hidden" name="item_desc['.$cart_items.']" value="'.$obj->proct_desc.'" />';
echo '<input type="hidden" name="item_qty['.$cart_items.']" value="'.$cart_itm["qty"].'" />';
$cart_items ++;
}
echo '</ul>';
echo '<span class="check-out-txt">';
echo '<strong>Total : '.$currency.$total.'</strong> ';
echo '</span>';
echo '</form>';
}else{
echo 'Your Cart is empty';
}
?>
</div>
</div>
E. 請問一下php做購物車為什麼要用SESSION來實現呢
就跟Cookie一樣，不同訪客存儲的數據不一樣，這些數據如果存放到資料庫中，不太方便，可以存放到radis或者SESSION中，直接存儲到cookie中的話，會產生客戶端可以篡改的問題，所以折中的話使用session算是最常規的方法。
F. 我用PHP做的購物車,為什麼每次往購物車中添加不同商品 ,購物車中確顯示的同一件商品啊
這個需要看你的購物車結構。
一般一個屬性的商品是在一條數據裡面，多次加入只是更改數量
不同屬性的商品應該分多條數據保存。最後購物車統計的是總的數量
G. php 實現 購物車 提交到 訂單的資料庫
用戶登陸後系統應該會分配一個session ： id，這個id應該是改用於的用戶表id。然後再做一個購物車的表，裡面可以只考慮存商品id、用戶id等關鍵信息；
當用戶提交購買的時候再做相關的操作，具體可以參考淘寶、天貓的購物車已經後續付款效果。
H. 商品放入購物車時減庫存，購物車在20分鍾後，清除所有商品，這個時候庫存重新加上去，PHP怎麼實現
沒有正式下單，庫存為什麼要減掉？這個是最大弊端啊。
如果要實現，就要在加入購物車的時候生成訂單號，讀取商品數量，連帶訂單號錄入資料庫，由資料庫進行減少一次，把結果反饋成為庫存。
如果移除購物車，就刪除訂單號，結果同樣反饋如資料庫，刪除訂單號的條目，資料庫更新一次，庫存也重新刷新讀取一次，
大體這樣，代碼自己搞
I. php實現購物車都有哪些方法除了session和cookie還有別的嗎
看需求.
上面那位同學說,可以把數據直接入庫,但這個是要建立在,要有用戶登陸的情況下才能實現的.
否則,只能用cookie或者session
J. php購物車顯示數量載入問題
像這種動態數據的改變，必須要由ajax實現的。
你可以在按鈕上添加一個js事件，每當加減的時候，調用後台那個function方法。
把參數傳好，就能夠得到具體的數據了。