<html>
<head>
<title>How To Import Excel (.xls) File To MySql Database Using PHP</title>
</head>
<body>
<center><h1>TES UPLOAD</h1></center>
<form name="import_export_form" method="post" action="" enctype="multipart/form-data">
<label>Select Excel File : </label><input type="file" name="excelfile"/><br>
<input type="submit" name="form_submit"/>
</form>
</body>
</html>
<?php
if(isset($_POST['form_submit'])){
require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251');
$filename = $_FILES['excelfile']['tmp_name'];
$nf = $_FILES['excelfile']['name'];
$data->read($filename);
$n=0;
for($x =2; $x <=count ($data->sheets[0]["cells"]); $x++){
$v1 = $data->sheets[0]["cells"][$x][2];
$v2= $data->sheets[0]["cells"][$x][3];
$v3= $data->sheets[0]["cells"][$x][4];
$v4= $data->sheets[0]["cells"][$x][5];
$v5= $data->sheets[0]["cells"][$x][6];
$v6= $data->sheets[0]["cells"][$x][7];
$n++;
echo $sql=" INSERT INTO `tb_data` (
``v1` ,`v2` ,`v3` ,`v4` ,`v5` ,`v6`) VALUES
('$v1', '$v2', '$v3', '$v4', '$v5', '$v6')";
}//for
}//isset
Download
Tidak ada komentar:
Posting Komentar