0) {
$file = fopen($fileName, "r");
while (($column = fgetcsv($file, 10000, ",")) !== FALSE) {
$uploadCount=$uploadCount+1;
$sqlInsert = "INSERT into vts_vehicle_lists(v_id, v_brand, v_model,v_type, v_make, v_plate, v_conduction, v_color, v_owner_id, v_status, v_in_out, v_location_id, v_pms_due_date, v_last_pms_date, cust_id, action_id, cust_pre_new_priv, sold_by_dealer, date_added, v_gear, v_notes, add_by)
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]."')";
$result = mysqli_query($conn, $sqlInsert);
if (!empty($result)) {
$type = "success";
$message = "Vehicle Data Imported into the Database";
$upLoad=1;
} else {
$type = "error";
$message = "Problem in Importing CSV Data. Possible duplicate record detected.
";
$upLoad=0;
}
}
}
}
?>
Loading..
Importing Vehicles from CSV File
">
1 && $upLoad==1){echo "
".$uploadCount." Records has been uploaded
";}else{}?>