query("select * from tbl_section where id='".$section_id."'"); $lined=$obj->fetchNextObject($sql2d); $section_slug=$lined->section_slug; $store_id=$_POST['store_id']; $sql2dd=$obj->query("select * from stores where storeid='".$store_id."'"); $linedd=$obj->fetchNextObject($sql2dd); $store_slug=$linedd->slug; $status=$_POST['status']; $display_order=$_POST['display_order']; $link_type=$_POST['link_type']; $title=$_POST['title']; $subtitle=$_POST['subtitle']; $bg_color=$_POST['bg_color']; $btn_label=$_POST['btn_label']; $btn_bg_color=$_POST['btn_bg_color']; $btn_text_color=$_POST['btn_text_color']; $post_url=$_POST['post_url']; $pid=$_POST['pid']; $is_nationwide=$_POST['is_nationwide']; $display_page_secid=$_POST['display_page_secid']; require_once __DIR__ . '/../include/S3Helper.php'; $s3 = new S3Helper(); if(isset($_FILES['fileImg']) && $_FILES['fileImg']['error'] === 0 && isValidImage($_FILES['fileImg'])) { $Image= new SimpleImage(); $filename = $_FILES['fileImg']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); $img=time()."-main-".$filename; $path = $s3->upload($_FILES['fileImg']['tmp_name'], 'upload_images/grocery-page-offer/',$img); if (!$path) { die('Something went wrong, Contact to site administrator.'); } // Upload to main website FTP // $url = SITE_URL; // if($url ==MAINSITE_URL || $url==DEVSITE_URL || // $url==UATSITE_URL){ // if($url ==MAINSITE_URL){ // $conn_id = ftp_connect("3.133.214.148") or die("Error in FTP connection - Live"); // $login_status = ftp_login($conn_id, "mainuser@quicklly.com", "n3At8hv3LZKCiF6") or die("Error in FTP login - Live"); // ftp_pasv($conn_id, true); // $destination_file = "upload_images/grocery-page-offer/".$img; // $upload_status = ftp_put($conn_id, $destination_file, $_FILES['fileImg']['tmp_name'], FTP_BINARY); // if (!$upload_status) // echo "Something went wrong, Contact to site administrator."; // ftp_close($conn_id); // } // } // // Upload locally to admin // move_uploaded_file($_FILES['fileImg']['tmp_name'],"../upload_images/grocery-page-offer/".$img); } else{ $img=$_POST['tempimg']; } if(isset($_FILES['fileImgn']) && $_FILES['fileImgn']['error'] === 0 && isValidImage($_FILES['fileImgn'])) { $Image= new SimpleImage(); $filenamen = $_FILES['fileImgn']['name']; $ext = pathinfo($filenamen, PATHINFO_EXTENSION); $imgn=time()."-mainapp-".$filenamen; $path = $s3->upload($_FILES['fileImgn']['tmp_name'], 'upload_images/grocery-page-offer/',$imgn); if (!$path) { die('Something went wrong, Contact to site administrator.'); } // Upload to main website FTP // $url = SITE_URL; // if($url ==MAINSITE_URL || $url==DEVSITE_URL || // $url==UATSITE_URL){ // if($url ==MAINSITE_URL){ // $conn_id = ftp_connect("3.133.214.148") or die("Error in FTP connection - Live"); // $login_status = ftp_login($conn_id, "mainuser@quicklly.com", "n3At8hv3LZKCiF6") or die("Error in FTP login - Live"); // ftp_pasv($conn_id, true); // $destination_file = "upload_images/grocery-page-offer/".$imgn; // $upload_status = ftp_put($conn_id, $destination_file, $_FILES['fileImgn']['tmp_name'], FTP_BINARY); // if (!$upload_status) // echo "Something went wrong, Contact to site administrator."; // ftp_close($conn_id); // } // } // // Upload locally to admin // move_uploaded_file($_FILES['fileImg']['tmp_name'],"../upload_images/grocery-page-offer/".$imgn); } else{ $imgn=$_POST['tempimgn']; } if($_POST['id']=='') { $obj->query("insert into tbl_grocery_offer set photo='".$img."',mob_photo='".$imgn."',section_id='".$section_id."',section_slug='".$section_slug."',store_id='".$store_id."',store_slug='".$store_slug."',status='".$status."',is_nationwide='".$is_nationwide."',link_type='".$link_type."',title='".$title."',subtitle='".$subtitle."',bg_color='".$bg_color."',btn_label='".$btn_label."',btn_bg_color='".$btn_bg_color."',btn_text_color='".$btn_text_color."',post_url='".$post_url."',display_page_secid='".$display_page_secid."',display_order='".$display_order."',pid='".$pid."',created_at=now()"); $_SESSION['sess_msg']='Data added sucessfully'; } else { $obj->query("update tbl_grocery_offer set photo='".$img."',mob_photo='".$imgn."',section_id='".$section_id."',section_slug='".$section_slug."',store_id='".$store_id."',store_slug='".$store_slug."',status='".$status."',is_nationwide='".$is_nationwide."',link_type='".$link_type."',title='".$title."',subtitle='".$subtitle."',bg_color='".$bg_color."',btn_label='".$btn_label."',btn_bg_color='".$btn_bg_color."',btn_text_color='".$btn_text_color."',post_url='".$post_url."',display_page_secid='".$display_page_secid."',display_order='".$display_order."',pid='".$pid."' where id='".$_POST['id']."'"); $_SESSION['sess_msg']='Data added sucessfully'; } header("location:grocery-offer-page.php"); exit(); } if(isset($_GET['delid'])) { $obj->query("delete from tbl_grocery_offer where id='".$_GET['delid']."'"); $_SESSION['sess_msg']='Data deleted sucessfully'; header("location:grocery-offer-page.php"); exit(); } ?> query("select * from tbl_grocery_offer where id='".$_GET['id']."'"); $cardrow=$obj->fetchNextObject($sql2ddd); } ?>

photo!='') { ?> mob_photo!='') { ?> "> "> Display ads on display_page_secid==1){ echo "selected"; } ?>>On Grocery listing page display_page_secid==39){ echo "selected"; } ?>>On Food listing page Section Select Section query("select * from tbl_section where status=1"); while($line=$obj->fetchNextObject($sql2)) { ?> section_id==$line->id){ echo "selected"; } ?>>section_name?> Store Select Store query("select * from stores where storeid='".$cardrow->store_id."'"); $linedds=$obj->fetchNextObject($sql2dds); ?> storeid!=0){ echo "selected"; } ?>>storename?> Photo(450*250) required> style="width:100px; height:100px;float:left"> Photo Mob(310*300) required> style="width:100px; height:100px;float:left"> Main Heading Sub Heading Display Order Background color Link Type Select Link Type link_type=='No Link'){ echo "selected"; } ?>>No Link link_type=='External'){ echo "selected"; } ?>>External link_type=='Store Page'){ echo "selected"; } ?>>Store Page link_type=='Section Page'){ echo "selected"; } ?>>Section Page link_type=='Product Page'){ echo "selected"; } ?>>Product Page Product ID External Link Button Label Button Background color Button Text color Status Select Status status==1){ echo "selected"; } ?>>Active status==0){ echo "selected"; } ?>>Deactive Is nationwide Select type is_nationwide==1){ echo "selected"; } ?>>Yes is_nationwide==0){ echo "selected"; } ?>>No      query("select * from tbl_grocery_offer"); $reccnt=$obj->numRows($sql2); if($reccnt==0) { ?> No Record fetchNextObject($sql2)) { $i++; if($i%2==0) { $bgcolor = "#f3f4f6"; } else { $bgcolor = ""; } ?> Record Found. S No. Section Store Photo Title Display On Link On Status Action . section_slug; ?> query("select * from stores where storeid='".$line->store_id."'"); $linedd=$obj->fetchNextObject($sql2dd); echo $linedd->storename; ?> photo!='') { ?> title){ echo "".$line->title.""; } ?> display_page_secid==1){ echo "Grocery Landing Page"; }else{ echo "Food Landing Page"; } ?> link_type){ echo "".$line->link_type.""; } ?> status==1){ echo "Active"; }else{ echo "Deactive"; } ?> Delete / Edit