0) {
$file = fopen($fileName, "r");
while (($column = fgetcsv($file, 5000, ",")) !== FALSE) {
$uploadCount=$uploadCount+1;
$sqlInsert = "INSERT into vts_customers(c_id, cust_fname, cust_lname, cust_middle_name, cust_bday, cust_gender, cust_mobile, cust_email, cust_region, cust_municipality, cust_city, brgy_name, cust_home_add, cust_comp_id, cust_deal_id, cust_date_added, cust_time_added, cust_add_by, status, age, profile_pic, cust_viber, cust_tweet, cust_fb, cust_InstaG, last_update_date, last_update_time, cust_business_id, sector_id, data_assigned_to, lead_tag, dormant)
values ('".$column[0]."','".$column[1]."','".$column[2]."','".$column[3]."','".$column[4]."','".$column[5]."','".$column[6]."','".$column[7]."','".$column[8]."','".$column[9]."','".$column[10]."','".$column[11]."','".$column[12]."','".$column[13]."','".$column[14]."','".$column[15]."','".$column[16]."','".$column[17]."','".$column[18]."','".$column[19]."','".$column[20]."','".$column[21]."','".$column[22]."','".$column[23]."','".$column[24]."','".$column[25]."','".$column[26]."','".$column[27]."','".$column[28]."','".$column[29]."','".$column[30]."','".$column[31]."')";
//$result = mysqli_query($conn, $sqlInsert);
$result = mysqli_query($sqlInsert);
if (!empty($result)) {
$type = "success";
$message = "New Service Appointment has been uploaded to yout system";
$upLoad=1;
} else {
$type = "error";
$message = "Problem in Importing CSV Data. Possible duplicate record detected.
";
$upLoad=0;
}
}
}
}
?>
Loading..
Upload New Fleet Database
">
1 && $upLoad==1){echo "
".$uploadCount." Records has been uploaded
";}else{}?>