HTML CODE
<div class="panel-body">
<form action="employee_entry.php" method="post" class="form-horizontal" enctype="multipart/form-data" >
<div class="form-group">
<div class="col-md-9"></div>
<div class="col-md-3">
<a href="download/Employee_details.csv">Download CSV Format</a>
</div>
</div>
<fieldset>
<legend>
Work Order Form
</legend>
<div class="form-group">
<div class="col-md-2">
<label class="" for="organisation">Select Csv File</label>
</div>
<div class="col-md-10">
<input type="file" class="form-control" name="csv_data" data-icon="false">
</div>
</div>
</fieldset>
<div class="form-group">
<div class="col-md-12">
<button name="upload" class="btn btn-primary btn-wide pull-right">Upload Csv <i class="fa fa-arrow-circle-right" ></i></button>
</div>
</div>
</fieldset>
</form>
</div>
PHP CODE
if(isset($_REQUEST['upload']))
{
if($_FILES['csv_data']['name'])
{
$arrFileName = explode('.',$_FILES['csv_data']['name']);
if($arrFileName[1] == 'csv')
{
$handle = fopen($_FILES['csv_data']['tmp_name'], "r");
$counter=0;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
if ( $counter == 0 )
{ }
else {
$emp_work_order = $class->escape_string($data[0]);
$emp_code = $class->escape_string($data[1]);
$emp_name = $class->escape_string($data[2]);
$emp_gender = $class->escape_string($data[3]);
$emp_dob = $class->escape_string($data[4]);
$emp_place_of_posting = $class->escape_string($data[5]);
$emp_qualification = $class->escape_string($data[6]);
$emp_father_name = $class->escape_string($data[7]);
$emp_designation = $class->escape_string($data[8]);
$emp_doj = $class->escape_string($data[9]);
$emp_unit = $class->escape_string($data[10]);
$emp_salary = $class->escape_string($data[11]);
$emp_bank = $class->escape_string($data[12]);
$emp_ifsc = $class->escape_string($data[13]);
$emp_account_no = $class->escape_string($data[14]);
$emp_pan = $class->escape_string($data[15]);
$emp_aadhaar_no = $class->escape_string($data[16]);
$emp_permanent_address = $class->escape_string($data[17]);
$emp_local_address = $class->escape_string($data[18]);
$emp_state = $class->escape_string($data[19]);
$emp_city = $class->escape_string($data[20]);
$emp_phone_first = $class->escape_string($data[21]);
$emp_phone_second = $class->escape_string($data[22]);
$emp_email_first = $class->escape_string($data[23]);
$emp_email_second = $class->escape_string($data[24]);
$emp_blood_group = $class->escape_string($data[25]);
$emp_emergency_contact = $class->escape_string($data[26]);
$emp_remark = $class->escape_string($data[27]);
$emp_dob = $class->changeUserToSql_DateFromat($emp_dob);
$emp_doj = $class->changeUserToSql_DateFromat($emp_doj);
$at_table="emp_details";
$sql = "emp_code = '$emp_code',
emp_name = '$emp_name',
emp_gender = '$emp_gender',
emp_dob = '$emp_dob',
emp_work_order = '$emp_work_order',
emp_place_of_posting = '$emp_place_of_posting',
emp_qualification = '$emp_qualification',
emp_father_name = '$emp_father_name',
emp_designation = '$emp_designation',
emp_doj = '$emp_doj',
emp_pan = '$emp_pan',
emp_aadhaar_no = '$emp_aadhaar_no',
emp_unit = '$emp_unit',
emp_salary = '$emp_salary',
emp_account_no = '$emp_account_no',
emp_bank = '$emp_bank',
emp_ifsc = '$emp_ifsc',
emp_blood_group = '$emp_blood_group',
emp_permanent_address = '$emp_permanent_address',
emp_local_address = '$emp_local_address',
emp_city = '$emp_city',
emp_state = '$emp_state',
emp_phone_first = '$emp_phone_first',
emp_phone_second = '$emp_phone_second',
emp_email_first = '$emp_email_first',
emp_email_second = '$emp_email_second',
emp_emergency_contact = '$emp_emergency_contact',
emp_remark = '$emp_remark',
emp_entry_by = '$user_id',
emp_status = 'Active'";
$at_qry=$class->insertData($at_table,$sql);
}
$counter++;
}
$count=$counter-1;
echo"<script>alert('$count DATA SAVED' );</script>";
}
}
}
Comments
Post a Comment