Import dari XLS ke PHP

Download excel_reader2.php

<?php
ini_set("display_errors",0);
require_once 'excel_reader2.php';

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'simpeg');

$connection = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);

$data = new Spreadsheet_Excel_Reader("sks20161.XLS");

echo "Total Sheets in this xls file: ".count($data->sheets)."<br /><br />";

$html="<table border='0'>";
for($i=0;$i<count($data->sheets);$i++) // Loop to get all sheets in a file.
{
if(count($data->sheets[$i][cells])>0) // checking sheet not empty
{
echo "Sheet $i:<br /><br />Total rows in sheet $i  ".count($data->sheets[$i][cells])."<br />";
for($j=1;$j<=count($data->sheets[$i][cells]);$j++) // loop used to get each row of the sheet
{
$html.="<tr>";
for($k=1;$k<=count($data->sheets[$i][cells][$j]);$k++) // This loop is created to get data in a table format.
{
$html.="<td>";
$html.=$data->sheets[$i][cells][$j][$k];
$html.="</td>";
}
$data->sheets[$i][cells][$j][1];

$thsms = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][1]);
$no_mk = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][2]);
$nama_mk = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][3]);
$sks = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][4]);
$kelas = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][5]);
$kd_dosen = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][6]);
$nama_jurusan = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][7]);
$fakultas = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][8]);
$nama = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][9]);
$jml_mahasiswa = mysqli_real_escape_string($connection,$data->sheets[$i][cells][$j][10]);

$query = "INSERT INTO `sks_mengajar` (`thsms`,`no_mk`, `nama_mk`,`sks`,`kelas`,`kd_dosen`,`nama_jurusan`,`fakultas`,`nama`,`jml_mahasiswa`) VALUES ('$thsms','$no_mk','$nama_mk','$sks','$kelas','$kd_dosen','$nama_jurusan','$fakultas','$nama','$jml_mahasiswa')";

mysqli_query($connection,$query);
$html.="</tr>";
}
}

}

$html.="</table>";
echo $html;
echo "<br />Data Inserted in dababase";
?>