Mengimport File Excel Ke MySQL dengan Script PHP

CREATE TABLE IF NOT EXISTS `mesin` (
  `mesinID` int(11) NOT NULL AUTO_INCREMENT,
  `mesin_code` varchar(11) NOT NULL,
  `desc` text NOT NULL,
  `seri` varchar(11) NOT NULL,
  `created_by` varchar(12) NOT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`mesinID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

<title>Script Import File Excel</title>
<h1>Script Import File Excel</h1>
<form method="post" enctype="multipart/form-data" action="jalan.php">
Pilih File Excel*: <input name="fileexcel" type="file"> <input name="upload" type="submit" value="Import">
</form>
* file yang bisa di import adalah .xls (Excel 2003-2007).

<?php
include "excel_reader2.php";
$username = "root";
$password = "aksesroot";
$database = "kacibang";
 
mysql_connect("localhost", $username, $password);
mysql_select_db($database);
 
// file yang tadinya di upload, di simpan di temporary file PHP, file tersebut yang kita ambil
// dan baca dengan PHP Excel Class
$data = new Spreadsheet_Excel_Reader($_FILES['fileexcel']['tmp_name']);
$hasildata = $data->rowcount($sheet_index=0);
// default nilai 
$sukses = 0;
$gagal = 0;
 
for ($i=2; $i<=$hasildata; $i++)
{
  $data1 = $data->val($i,2); 
  $data2 = $data->val($i,3);
  $data3 = $data->val($i,4);
  $created_by = 'Admin'; 
  $date = date('Y-m-d H:i:s');
  $rand = rand();
 
$query = "INSERT INTO mesin  VALUES (null,'$data1','$data2','$rand', '$created_by', '$date')";
$hasil = mysql_query($query);
 
if ($hasildata) $sukses++;
else $gagal++;
 
echo "< pre>";
print_r($query);
echo "< /pre>";
 
}
echo "<b>import data selesai.</b>";
echo "Data yang berhasil di import : ".$sukses.;
echo "Data yang gagal diimport : ".$gagal.;
echo "back import";
?>