phP商品sku_php中二維數組更換鍵值

㈠ php中二維數組更換鍵值

代碼：

$arr=array();
for($i=0;$i<4;$i++){//4可以換成數組的長度
$arr[$i]=>array(
'count'=>$count[$i],//原兩個等長的數組
'sku_id'=>$sku_id[$i]
);
}
print_r($arr);//測試

㈡ php 合並多維數組中相同的值

$arr=array(
	array(
	array(
				"stocknotifyId"=>1,
				"sku"=>'13809_BL_37',
				"email"=>'[email protected]'
			),
	array(
				"stocknotifyId"=>3,
				"sku"=>'13809_BL_37',
				"email"=>'[email protected]'
			),
	array(
				"stocknotifyId"=>5,
				"sku"=>'13809_BL_37',
				"email"=>'[email protected]'
			)
		),
	array(
			array(
				"stocknotifyId"=>2,
				"sku"=>'13809_B_39',
				"email"=>'[email protected]'
			)
		),
		array(
			array(
				"stocknotifyId"=>4,
				"sku"=>'13809_BL_39',
				"email"=>'[email protected]'
			)
		)
	);


$re=array();

foreach($arras$a){
	foreach($aas$v){
		$tmp_v=$v;
		unset($tmp_v['email']);
		if(isset($re[$v['email']])){
			$re[$v['email']][]=$tmp_v;
		}else{
			$re[$v['email']]=array($tmp_v);
		}
		
	}
}

print_r($re);

<!--output-->
Array
(
[[email protected]]=>Array
(
[0]=>Array
(
[stocknotifyId]=>1
[sku]=>13809_BL_37
)
[1]=>Array
(
[stocknotifyId]=>2
[sku]=>13809_B_39
)
)
[[email protected]]=>Array
(
[0]=>Array
(
[stocknotifyId]=>3
[sku]=>13809_BL_37
)
[1]=>Array
(
[stocknotifyId]=>4
[sku]=>13809_BL_39
)
)
[[email protected]]=>Array
(
[0]=>Array
(
[stocknotifyId]=>5
[sku]=>13809_BL_37
)
)
)

㈢ php mysql_fetch_assoc 循環遍歷表格

有2個辦法，第一種直接使用sql的多表聯查，效率高，但是得到的數據table1會被擴展成table2一樣的條目數要再次處理

select*fromtable1a,table2bwherea.orderid=b.orderid

第二種方法，先得到table11的數據，在循環中匹配table2到一個新的列名中隱敏行

$conn=mysqli_connect("127.0.0.1","root","123","test");
$sql="select*fromtable1";
$rs=mysqli_query($conn,$sql);
$Arr=拿敗array();
while($row=mysqli_fetch_assoc($rs)){
$sql="select*fromtable2whereorderid=".$row["orderid"];
$row["order_sku"]=mysqli_fetch_all(mysqli_query($conn,$sql),MYSQLI_ASSOC);
$Arr[]=$row;
}
print_r($Arr)

如果你是剛開始學php 建議直接拋棄mysql用mysqli 因為PHP5.5已經廢棄灶嘩mysql方法了

㈣如何用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();
}
});
}

㈤ PHP鏁扮粍闂棰橈紝涓涓澶ф暟緇勯噷闈㈢殑灝忔暟緇勶紝濡傛灉鐩稿悓鐨刼rderid錛屽垯鍚堝苟鎴愪負涓涓鏂扮殑鏁扮粍

寰堢畝鍗曠殑錛屽垎鍒鐢$oldArr,$newArr鏉ヤ唬琛ㄥ師鏉ョ殑鏁版嵁鍜岀幇鍦ㄧ殑鏁版嵁錛屾垜涓嬮潰鍙緇欏嚭澶ц嚧鐨勯昏緫錛屼綘鑷宸卞幓淇鏀瑰苟楠岃瘉鍚с
// 鍘熸潵鐨勬暟緇
$oldArr = array(...);
// 浣犺佺殑鏁扮粍
$newArr = array();
// 榪涜屽驚鐜澶勭悊錛屾敞鎰忥紝鍥犱負鍚堝苟鍚庯紝姣忎釜orderid鍙浼氬睘浜庝竴涓鎴愬憳錛屾墍浠ユ柊鏁扮粍鐨勬垚鍛樹互orderid涓洪敭鍊
foreach ($oldArr as $order) {
// 鍒ゆ柇涔嬪墠鏄鍚﹀凡緇忓瓨鍦ㄧ浉鍚岀殑璁㈠崟錛屼笉鏄鍒欐坊鍔犳柊鏁版嵁錛屽凡緇忓瓨鍦ㄥ垯琛ュ厖鐩稿叧鏁版嵁
if (!isset($newArr[$order['orderid']])) {
// 榪欓噷灝辨槸鏂扮殑orderid瀵瑰簲鐨勯氱敤鍐呭癸紝涓嶅寘鍚鏁板瓧緔㈠紩瀵瑰簲鐨勫唴瀹
$newArr[$order['orderid']] = array(
'orderid' => $order['orderid'],
'shopid' => $order['shopid'],
// 緇х畫璁劇疆浣犵殑鏁版嵁
);
}
// 榪欓噷璁劇疆閲岄潰鏁板瓧緔㈠紩瀵瑰簲鐨勫唴瀹
$newArr[$order['orderid']][] = array(
'sku1' => $order['sku1'],
'remark' => $order['remark'],
// 姝ゅ勭殑閫昏緫灝辯渷鐣ヤ簡錛岃嚜宸辨坊鍔犲惂
);
}

㈥ php取出多維數組重復的值

$arr = array(
array(
array(
"stocknotifyId" => 1,
"sku" => '13809_BL_37',
"email" => '[email protected]'
),
array(
"stocknotifyId" => 3,
"sku" => '13809_BL_37',
"email" => '[email protected]'
),
array(
"stocknotifyId" => 5,
"sku" => '13809_BL_37',
"email" => '[email protected]'
)
),
array(
array(
"stocknotifyId" => 2,
"sku" => '13809_B_39',
"email" => '[email protected]'
)
),
array(
array(
"stocknotifyId" => 4,
"sku" => '13809_BL_39',
"email" =>'[email protected]'
)
)
);

$re = array();

foreach($arr as $a) {
foreach ($a as $v) {
$tmp_v = $v;
unset($tmp_v['email']);
if(isset($re[$v['email']])) {
$re[$v['email']][] = $tmp_v;
}else{
$re[$v['email']] = array($tmp_v);
}

}
}

print_r($re);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38


Array
(
[[email protected]] => Array
(
[0] => Array
(
[stocknotifyId] => 1
[sku] => 13809_BL_37
)
[1] => Array
(
[stocknotifyId] => 2
[sku] => 13809_B_39
)
)
[[email protected]] => Array
(
[0] => Array
(
[stocknotifyId] => 3
[sku] => 13809_BL_37
)
[1] => Array
(
[stocknotifyId] => 4
[sku] => 13809_BL_39
)
)
[[email protected]] => Array
(
[0] => Array
(
[stocknotifyId] => 5
[sku] => 13809_BL_37
)
)
)

導航:首頁 > 編程語言 > phP商品sku

phP商品sku

與phP商品sku相關的資料