Here below my code . its working fine, only $itemsize is not inserting any data in db. Others filed are okay. FYI $itemsize will repeatedly insert in many row following $friendarray as $s666s this data.
PHP Code:
$friendslist =
"$s4s,$s6s,$s8s,$s10s,$s12s,$s14s,$sxss,$sss,$sms,$sls,$sxls,$sxxls";
$friendarray = explode(",", $friendslist);
$sizelists ="4,6,8,10,12,14,XS,S,M,L,XL,XXL";
$size = explode(",",$sizelists);
foreach ($size as $itemsize){
echo "<li>$itemsize</li>";
}
for ($n = 0; $n < count($friendarray); $n++) {
$friendidpush = "('".$style."','".$order."','".$color."','".$itemsize."','".$friendarray[$n]."','".$ctnqty."','".$invoice."','".$kcgmt."','".$season."','".$buyer."','".$factory."'),";
}
$query = "INSERT INTO freddyhipment (style, orderno, col, s4s, s6s, ctnqty, invoice, kcgmt, season, buyer, factory) VALUES ";
$friendarray = explode(",", $friendslist);
foreach ($friendarray as $s666s) {
$query .= "('".$style."','".$order."','".$color."','".$itemsize."','".$s666s."','".$ctnqty."','".$invoice."','".$kcgmt."','".$season."','".$buyer."','".$factory."'),";
}
$query = substr($query, 0, -1); // remove trailing comma
CodingForums...
ما را در سایت CodingForums دنبال می کنید
برچسب : نویسنده : codingforums بازدید : 240 تاريخ : جمعه 7 مهر 1396 ساعت: 10:54