if(isset($_POST['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_code = $class->escape_string($data[0]);
$emp_name = $class->escape_string($data[1]);
$emp_deapartment = $class->escape_string($data[2]);
$at_table="outsource_attendance";
$data="emp_code='$emp_code',
emp_name='$emp_name',
emp_department='$emp_deapartment'";
$at_qry=$class->insertData($at_table,$data);
}
$counter++;
}
}
}
}
<form class="form-horizontal" method="post" action="" onsubmit="return Validate(this);" enctype="multipart/form-data" >
<div class="col-sm-6"><input type="file" name="csv_data" class="form-control" data-icon="false"></div>
<div class="col-sm-6"><input type="submit" name="upload" value="Upload" class="btn btn-primary"></div>
</form>
<script type="text/javascript">
var _validFileExtensions = [".csv"];
function Validate(oForm) {
var arrInputs = oForm.getElementsByTagName("input");
for (var i = 0; i < arrInputs.length; i++) {
var oInput = arrInputs[i];
if (oInput.type == "file") {
var sFileName = oInput.value;
if (sFileName.length > 0) {
var blnValid = false;
for (var j = 0; j < _validFileExtensions.length; j++) {
var sCurExtension = _validFileExtensions[j];
if (sFileName.substr(sFileName.length - sCurExtension.length, sCurExtension.length).toLowerCase() == sCurExtension.toLowerCase()) {
blnValid = true;
break;
}
}
if (!blnValid) {
alert("Sorry, " + sFileName + " is invalid, allowed extensions is: " + _validFileExtensions.join(", "));
return false;
}
}
}
}
return true;
}
</script>
{
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_code = $class->escape_string($data[0]);
$emp_name = $class->escape_string($data[1]);
$emp_deapartment = $class->escape_string($data[2]);
$at_table="outsource_attendance";
$data="emp_code='$emp_code',
emp_name='$emp_name',
emp_department='$emp_deapartment'";
$at_qry=$class->insertData($at_table,$data);
}
$counter++;
}
}
}
}
<form class="form-horizontal" method="post" action="" onsubmit="return Validate(this);" enctype="multipart/form-data" >
<div class="col-sm-6"><input type="file" name="csv_data" class="form-control" data-icon="false"></div>
<div class="col-sm-6"><input type="submit" name="upload" value="Upload" class="btn btn-primary"></div>
</form>
<script type="text/javascript">
var _validFileExtensions = [".csv"];
function Validate(oForm) {
var arrInputs = oForm.getElementsByTagName("input");
for (var i = 0; i < arrInputs.length; i++) {
var oInput = arrInputs[i];
if (oInput.type == "file") {
var sFileName = oInput.value;
if (sFileName.length > 0) {
var blnValid = false;
for (var j = 0; j < _validFileExtensions.length; j++) {
var sCurExtension = _validFileExtensions[j];
if (sFileName.substr(sFileName.length - sCurExtension.length, sCurExtension.length).toLowerCase() == sCurExtension.toLowerCase()) {
blnValid = true;
break;
}
}
if (!blnValid) {
alert("Sorry, " + sFileName + " is invalid, allowed extensions is: " + _validFileExtensions.join(", "));
return false;
}
}
}
}
return true;
}
</script>
Comments
Post a Comment