query("delete from tbl_promotion_data where type=2"); $obj->query("delete from tbl_promotion_data where type=1"); foreach ($_REQUEST['ing_value_c'] as $key => $val) { $i++; $ing_name_c = mysqli_real_escape_string($GLOBALS['conn'],$val); $ing_value_c = $ing_name_c; $ing_desc_c = $_REQUEST['ing_desc_c'][$key]; $ing_short_c = $_REQUEST['ing_short_c'][$key]; $ing_url_c = $_REQUEST['ing_url_c'][$key]; if(!empty($ing_name_c) && !empty($ing_value_c)){ $obj->query("INSERT INTO tbl_promotion_data set coupon_code='$ing_value_c ',main_description='$ing_desc_c',short_description='$ing_short_c',store_url='$ing_url_c',status=1,type=1"); } }// for ecah loop foreach ($_REQUEST['ing_value'] as $key => $val) { $i++; $ing_name = mysqli_real_escape_string($GLOBALS['conn'],$val); $ing_value = $ing_name; $ing_desc = $_REQUEST['ing_desc'][$key]; $ing_short = $_REQUEST['ing_short'][$key]; $exist_icon = $_REQUEST['exist_icon'][$key]; $ing_url = $_REQUEST['ing_url'][$key]; $exist_id =$_REQUEST['exist_id'][$key]; $ing_icon=''; if(!empty($ing_name) && !empty($ing_value)){ if ($_FILES['ing_icon']['size'][$key] > 0 && $_FILES['ing_icon']['error'][$key] == '') { $product_pic = preg_replace('/[0-9\@\.\;\" "]+/', '', $plan_name); $str = strtr( $product_pic, $unwanted_array ); $product_img_name = buildURL($str); $Image = new SimpleImage(); $filename = $_FILES['ing_icon']['name'][$key]; $tempfilename=$_FILES['ing_icon']['tmp_name'][$key]; $ext = pathinfo($filename, PATHINFO_EXTENSION); $ing_icon = time() . "-" . $product_img_name . $i . "." . $ext; //ftp start require_once __DIR__ . '/../include/S3Helper.php'; $s3Helper = new S3Helper(); // or however you instantiate it in your project $tempFilePath = $_FILES['ing_icon']['tmp_name'][$key]; $destination = 'upload_images/promotion'; if ($ing_icon != '') { $s3Helper->upload($tempFilePath, $destination, $ing_icon); } if($ing_icon!=''){ $ing_icon=$ing_icon; } else { $ing_icon=$exist_icon; } $obj->query("INSERT INTO tbl_promotion_data set coupon_code='$ing_value ',main_description='$ing_desc',short_description='$ing_short',store_logo='$ing_icon',store_url='$ing_url',status=1,type=2"); } }// for ecah loop } } header("location:quicklly-promotion-addf.php"); exit(); } ?>

Admin: Update Promotion query("SELECT * FROM tbl_promotion_data WHERE type=1 and status=1"); $numoption=$obj->numRows($sqloption); if($numoption==0){ ?> query("SELECT * FROM tbl_promotion_data WHERE type=2 and status=1"); $numoption=$obj->numRows($sqloption); if($numoption==0){ ?> Coupons for you : Coupon Code: Description: Short Description: Url         Coupon For You : fetchNextObject($sqloption)){ ?> Coupon Code: Description: Short Description: Url Store Deals : Store Icon: Coupon Code: Description: Short Description: Url         Store Deals : fetchNextObject($sqloption)){ ?> Store Icon: Coupon Code: Description: Short Description: Url