Skip to main content

Restrict File Type on File Upload

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>

Comments

Popular posts from this blog

Upload Csv To Mysql By PHP

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="fi

Search Menu Using JavaScript In Php and Html

  Search Menu Using JavaScript In Php and Html <div class="left" style="background-color:#bbb;">     <h2>Menu</h2>     <input type="text" id="mySearch" onkeyup="myFunction()" placeholder="Search.." title="Type in a category">     <ul id="myMenu">       <li><a href="#">HTML</a></li>       <li><a href="#">CSS</a></li>       <li><a href="#">JavaScript</a></li>       <li><a href="#">PHP</a></li>       <li><a href="#">Python</a></li>       <li><a href="#">jQuery</a></li>       <li><a href="#">SQL</a></li>       <li><a href="#">Bootstrap</a></li>       <li><a href="#">Node.js</a></li>