Insert Csv File Data in Mysql using Php with Validation Full Example
Sample Csv File Test.csv
<script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script src="http://jqueryvalidation.org/files/dist/jquery.validate.min.js"></script>
<script src="http://jqueryvalidation.org/files/dist/additional-methods.min.js"></script>
<script type="application/javascript">
$(document).ready(function(e) {
$('#pincodeList').validate({
rules: {
Csv: {
required: true,
extension: "xls|csv"
}
},
messages: {
Csv: {
extension: 'Please upload a csv file!'
}
}
});
});
</script>
<?php
include('connect.php');
if($_POST['submit']){
$csv_file = $_FILES['Csv']['name'];
$tmpFilePath =$_FILES['Csv']['tmp_name'];
$newFilePath="pincodeUpload/";
$mypath = "pincodeUpload/".$csv_file;
move_uploaded_file($tmpFilePath, $mypath);
if ( ! is_dir($newFilePath)) {
mkdir($newFilePath);
}
$csv_file =$mypath;
if (($handle = fopen($csv_file, "r")) !== FALSE) {
fgetcsv($handle);
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
for ($c=0; $c < $num; $c++) {
$col[$c] = $data[$c];
}
$col1 = $col[0];
// SQL Query to insert data into DataBase
$query = "INSERT INTO pincode(Pincode) VALUES('$col1')";
$s = mysql_query($query);
}
fclose($handle);
}
}
?>
<form id="pincodeList" name="pincodeList" method="post" enctype="multipart/form-data">
<div class="row">
<div class="co-md-3 col-sm-6">
<input type="file" name="Csv" >
</div>
<div class="co-md-3 col-sm-6">
<input class="btn btn-success" type="submit" name="submit" value="Upload Csv"/>
</div>
</div>
</form>
Sample Csv File Test.csv
<script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script src="http://jqueryvalidation.org/files/dist/jquery.validate.min.js"></script>
<script src="http://jqueryvalidation.org/files/dist/additional-methods.min.js"></script>
<script type="application/javascript">
$(document).ready(function(e) {
$('#pincodeList').validate({
rules: {
Csv: {
required: true,
extension: "xls|csv"
}
},
messages: {
Csv: {
extension: 'Please upload a csv file!'
}
}
});
});
</script>
<?php
include('connect.php');
if($_POST['submit']){
$csv_file = $_FILES['Csv']['name'];
$tmpFilePath =$_FILES['Csv']['tmp_name'];
$newFilePath="pincodeUpload/";
$mypath = "pincodeUpload/".$csv_file;
move_uploaded_file($tmpFilePath, $mypath);
if ( ! is_dir($newFilePath)) {
mkdir($newFilePath);
}
$csv_file =$mypath;
if (($handle = fopen($csv_file, "r")) !== FALSE) {
fgetcsv($handle);
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$num = count($data);
for ($c=0; $c < $num; $c++) {
$col[$c] = $data[$c];
}
$col1 = $col[0];
// SQL Query to insert data into DataBase
$query = "INSERT INTO pincode(Pincode) VALUES('$col1')";
$s = mysql_query($query);
}
fclose($handle);
}
}
?>
<form id="pincodeList" name="pincodeList" method="post" enctype="multipart/form-data">
<div class="row">
<div class="co-md-3 col-sm-6">
<input type="file" name="Csv" >
</div>
<div class="co-md-3 col-sm-6">
<input class="btn btn-success" type="submit" name="submit" value="Upload Csv"/>
</div>
</div>
</form>
0 komentar:
Post a Comment