..Someday i will understanD..

$max_size = 1024*1000;
$my_upload = new file_upload;
$my_upload->upload_dir =”xls/”;
$my_upload->extensions = array(”.xls”,”.txt”,”.csv”);
$my_upload->max_length_filename = 50;
$my_upload->rename_file = false;

if(isset($_POST[’Submit’])) {
if(empty($_FILES[’upload’][’name’]))
{ ?>

< ?
}
else
{
$my_upload->the_temp_file = $_FILES[’upload’][’tmp_name’];
$my_upload->the_file = $_FILES[’upload’][’name’];
$my_upload->http_error = $_FILES[’upload’][’error’];
$my_upload->replace = (isset($_POST[’replace’])) ? $_POST[’replace’] : “n”;
$my_upload->do_filename_check = (isset($_POST[’check’])) ? $_POST[’check’] : “n”;
$new_name = (isset($_POST[’name’])) ? $_POST[’name’] : “”;

$my_upload->upload($new_name);

$data_j=$my_upload->file_copy;
echo $data_j;

open_connection();
if(empty($data_j))
{
?>

< ?
}
else
{
$dbname='logbook';
mysql_select_db("$dbname");

$CSVFile = $_GET['data_j'];
echo $CSVFile;
if (file_exists("xls/".$CSVFile)) {

$row = 1;
$handle = fopen ("$CSVFile","r");

while ($data = fgetcsv ($handle, 1000, ","))
{

$sql = "INSERT INTO ticket (t_ticket,jn_prog,uraian,estimasi,nik,status,id_ticket)
VALUES ('".$data[0]."','".$data[2]."','".$data[3]."','".$data[4]."'
,'".$data[1]."','".$data[7]."','".$data[8]."');
INSERT INTO kegiatan (t_ticket,t_giat,kegiatan,jn_prog)
VALUES ('".$data[0]."','".$data[5]."','".$data[6]."','".$data[2]."')";

$do = mysql_query($sql) or die(mysql_error());

echo "
$sql
“;

echo “\n”;
echo “\n”;

}

fclose ($handle);
}
else
{
echo “No file in folder!!”;
}

}