File "upload_csv_affiliatefuture.php"

Full Path: /home/u165092617/domains/tadzz.com/public_html/admin/backend/upload_csv_affiliatefuture.php
File size: 1.79 KB
MIME-type: text/x-php
Charset: utf-8

<?php session_start();
require_once("../config/config.php");
//require_once("../config/commonsetting.php");

$myformId=SESS_MASTER;
$myIp= ipCheck() ;
$dateceated=date("Y-m-d G:i:s");
$createdby='0';

 
 
 $handle = fopen($_FILES['upload_data']['tmp_name'], "r");
 $headers = fgetcsv($handle, 1000, ",");
 $data = fgetcsv($handle, 1000, ",");
  $num = count($data);
    
     print_r($data);
     
 while (($data = fgetcsv($handle, 1000, ","))!== FALSE) 
 {
    
 try{
     
     $title=addslashes($data[0]);
     $discription=addslashes($data[4]);
     $company_name='AFFILIATEFUTURE';
     $product_image=addslashes($data[6]);
     $amount=$data[7];
     $product_url=addslashes($data[5]);
     $category=addslashes($data[2]);
    // $type=addslashes($data[3]);
    // $exp_date=addslashes($data[7]);
    
     $coupon_country_name='European Union';
     $brand='brand';
     
     if($title!=''){
	
        $olgaquery="INSERT INTO product_master SET company_name='$company_name', title ='$title',amount='$amount',
        discription='$discription',product_url='$product_url',category='$category',product_image='$product_image',
        country_name='$coupon_country_name',
        brand_store='$brand',created_by='0',created_type='Admin'"; 
		$stmt = $conn->prepare($olgaquery);
		if($stmt->execute()){
			$last_insert_id = $conn->lastInsertId();
			
            $status='success';
            $_SESSION["uploaded"] = $status ;
            header("location:../fetch-data.php");
 
		}
 
     }else{
      
    header("location:../fetch-data.php");
         
     }
   }
         
        // show error
        catch(PDOException $exception){
            die('ERROR: ' . $exception->getMessage());
        }
     }
     
    
 echo '<br>';
 
fclose($handle);