0) {
$file = fopen($fileName, "r");
while (($column = fgetcsv($file, 5000, ",")) !== FALSE) {
$uploadCount=$uploadCount+1;
$sqlInsert = "INSERT into businesses_names(bid, business_name, type, business_region, business_municipality, business_city, business_barangay, business_street, contact_person, sales_person, contact_number, email, fb_account, website_link, date_time_added, status, comp_owner_id, deal_owner_id, last_update_date, data_assigned_to, last_update_time, lead_tag, dormant, owner)
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]."')";
//$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{}?>