0) {
$file = fopen($fileName, "r");
while (($column = fgetcsv($file, 10000, ",")) !== FALSE) {
$uploadCount=$uploadCount+1;
$sqlInsert = "INSERT into vts_service_transaction(s_id, s_v_plate, s_comp_code, s_deal_code, s_appt_type, s_date, s_time, s_service_desc, s_arrived_date, s_arrived_time, s_released_date, s_released_time, add_by , time_slot_code, appt_date, cust_contact, brand_id, model_id, service_status, s_ro_no, transferred_to, s_qs_ssp, s_qs_comp_paid ,s_qs_cust_paid,s_gj_comp_paid,s_gj_cust_paid,s_gj_warranty,s_gj_warranty_sub,s_bp_cust_paid,s_bp_warranty_type,s_bp_insurance_paid)
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]."')";
$result = mysqli_query($conn, $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 Service Appoitment
">
1 && $upLoad==1){echo "
".$uploadCount." Records has been uploaded
";}else{}?>