phpsku
Ⅰ 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資料庫代碼
2015-03-04 275人 1頁
3.8分
- <?php $mysl_server_name='localhost'; //改成自己的mysl資料庫伺服器 $mysl_username='root'; //改成自己的mysl資料庫用戶名 $mysl_password='12345678'; //改成自己的mysl資料庫密碼 $mysl_database='mycounter'; //改成自己的mysl資料庫名 $conn=mysl_connect($mysl_server_name,$mysl_username,$mysl_password,$mysl_database); $sl='CREATE DATABASE mycounter DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; '; mysl_uery($sl); $sl='CREATE TABLE `counter` (`id` INT(255) UNSIGNED NOT NULL AUTO_INCREMENT ,`count` INT(255) UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY ( `id` ) ) TYPE = innodb;'; mysl_select_db($mysl_database,$conn); $result=mysl_uery($sl); //echo $sl; mysl_close($conn); echo &uot;Hello!資料庫mycounter已經成功建立!&uot;; ?> PHP連
還有不會的可以看看後盾人的視頻
Ⅲ php,訂單詳情表與訂單表怎麼關聯
訂單表裡面放訂單id,總得價格,下單人的信息,配送信息,折扣信息,訂單狀態,而訂單詳情裡面存放訂單中得商品,商品價格,商品sku信息等商品明細信息,同時也存訂單id,通過訂單id關系起來兩個表
Ⅳ 如何用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如何合並數組當中有相同數值的數組
array_unique函數提供了過濾重復的值的功能,但是該函數只能處理一維數組,如果遇到多維數組我們可以現將其轉化為一維數組。示例代碼如下
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
/*
* $data 是你要處理數據
* $result 是輸出的結果
*/
//將其轉化為一維數組
foreach ($data as &$row) {
$row = serialize($row);
}
unset($row);
$data = array_unique($data);
//還原多維數組
foreach ($data as &$row) {
$row = unserialize($row);
}
unset($row);
不好意思 樓主要求,我看錯了,追加下面的代碼
1
2
3
4
5
6
7
8
9
10
11
12
$result=array();
$tmp_arr=array();
foreach ($data as $row) {
$tmp_arr[$row['confuguarable_sku']][] = $row['size'];
}
//將尺寸用逗號拼接
foreach ($tmp_arr as $sku => $size) {
$result[] = array('confuguarable_sku'=>$sku, 'size'=>implode(",", $size));
}
echo "<pre>";
//輸出結果
print_r($result);
Ⅵ php中 二維數組更換鍵值
這個很簡單,遍歷這個數組,然後裡面寫個判斷,判斷鍵值是否和sku_id相等,如果相等就重新給這個鍵賦值,希望對你有幫助
Ⅶ 怎麼樣才能過濾相同數組php
//考慮到你指定的鍵值不一定是連續的相同的,中間可以有間斷,所以程序如下
//1,2,5同,3,4同
$a=array(
array(
'confuguarable_sku'=>'0572911',
'sku'=>4561,
'conseille'=>'No'),
array(
'confuguarable_sku'=>'0572911',
'sku'=>4561,
'conseille'=>'No'),
array(
'confuguarable_sku'=>'0572912',
'sku'=>4561,
'conseille'=>'No'),
array(
'confuguarable_sku'=>'0572912',
'sku'=>4561,
'conseille'=>'No'),
array(
'confuguarable_sku'=>'0572911',
'sku'=>4561,
'conseille'=>'No'),
);
print_r($a);
$b=array();
foreach($aas$key=>$value){
$temp[$key]=$value['confuguarable_sku'];
}
print_r($temp);
print_r($temp=array_unique($temp));
foreach($tempas$key=>$value){
$res[$key]=$a[$key];
}
//顯示結果
print_r($res);
Ⅷ php sku由多個循環分別說出的屬性怎麼處理入
<metA http-equiv="Content-Type" content="text/html; chArset=utf-8">
<?php
$skuattr= Array
(
'7' => Array
(
'6' => '22x33',
'9' => '44x55'
),
'8' => Array
(
'12' => '大小號'
),
'9' => Array
(
'8' => '金屬質',
'13' => '塑料',
),
'16' => Array
Ⅸ php 數組遍歷獲取唯一的sku值
<metAhttp-equiv="Content-Type"content="text/html;chArset=utf-8">
<?php
$skuattr=Array
(
'7'=>Array
(
'6'=>'22x33',
'9'=>'44x55'
),
'8'=>Array
(
'12'=>'大小號'
),
'9'=>Array
(
'8'=>'金屬質',
'13'=>'塑料',
),
'16'=>Array
(
'14'=>'圓形'
)
);
/*
主要思路:
這個商品有4種參數,參數不同的商品算作一種類型
那麼這個商品有2x1x2x1=4種不同類型,要全部列出這個商品類型需要4行
第一個參數只有2種,那麼每種需要顯示2次
第二個參數只有1種,那麼每種需要顯示4次
第三個參數只有2種,那麼每種需要顯示2次
第四個參數只有1種,那麼每種需要顯示4次
這樣排列組合的新二維數組每一行就是商品的一種類型了
這個問題類似一個四位數
千位可選2個不同的數,百位只能選1個數字,十位只能選2個數,個位只能選1個數
有多少個不同的數字。
這里就用函數getRows()算出了,然後從每一列下手,把參數出現的次數填入即可
PS:
拋磚引玉了,期待更好的解法~
發現問題比較好理解,只是畢竟是索引數組顯示還是不太好弄的。
不然四位數用for循環四次,表示我想不出來
*/
showTypes($skuattr);
functionshowTypes($Arrs){
$rows=getRows($Arrs);//獲取行數即商品的不同規格組合數
echo$rows;
$newA=array();//結果數組
$col=0;
foreach($Arrsas$key=>$value){
$row=0;
foreach($valueas$key2=>$value2){//豎直填充
$times=count($value);
for($i=0;$i<($rows/$times);$i++){//重復次數
$newA[$row][$col]=$key.':'.$key2;
$row++;
}
}
$col++;
}
/*echo'<pre>';
print_r($newA);
echo'</pre>';*/
foreach($newAas$value){//顯示結果
foreach($valueas$value){
echo$value.';';
}
echo'</br>';
}
}
functiongetRows($Arrs){
$num=1;
foreach($Arrsas$value){
$num=$num*count($value);
}
return$num;
}
?>