..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!!”;
}

}

include "koneksi.php";
open_connection();

$filename = "".$x."_".$y.".csv";

$sql = "select a.id_ticket,a.t_ticket, a.nik, a.jn_prog,
a.uraian, a.estimasi,a.status,
b.t_giat, b.kegiatan
from ticket a, kegiatan b
where a.t_ticket=b.t_ticket and a.t_ticket >= ‘$tggl1′ and a.t_ticket < = '$tggl2'
and a.jn_prog=b.jn_prog";
//echo $sql;

$query = mysql_query($sql);

while ($row = mysql_fetch_object($query)){

$t_ticket = $row->t_ticket;
$nik = $row->nik;
$jn_prog = $row->jn_prog;
$uraian = $row->uraian;
$estimasi = $row->estimasi;
$t_giat = $row->t_giat;
$kegiatan = $row->kegiatan;

$somecontent .= $t_ticket.”,”.$nik.”,”.$jn_prog.”,”.$uraian.”,”.$estimasi.”,”.$t_giat.”,”.$kegiatan.”\n”;

}

$fp = fopen($filename, “w”);
$oke=fputs($fp , $somecontent);
if ($oke)
{
echo “Data ${x}_${y}.csv Successfully create.”;
echo “
“;
echo “[back]“;
}
else
echo “Data not create”;

include("excelwriter.inc.php");
$conn = OciLogon($db_user,$db_pass,$db_host);

$sql = "select * from table where to_char(tanggal,'dd/mm/yyyy') = '$tgl';
$stm = ociparse($conn,$sql);
ociexecute($stm);

$x = str_replace("/","",$pos);
$excel =new ExcelWriter("".$x.".xls");

if($excel==false)
echo $excel->error;

$myArr = array(”Field1″,”Field2″,”Field3I”);
$excel->writeLine($myArr);

while (ocifetch($stm))
{
$excel->writeRow();
$excel->writeCol(”".ociresult($stm,’field1′).”");
$excel->writeCol(”".ociresult($stm,’field2′).”");
$excel->writeCol(”".ociresult($stm,’field3′).”");
}

$mail = new PHPMailer();
$mail->IsSMTP(); // set mailer utk menggunakan SMTP
$mail->Host = "smtp.nama.com:25"; // spesifikasi alamat smtp server & portnya
$mail->SMTPAuth = true; // mengaktifkan SMTP authentication
$mail->Username = "usernamenya"; // SMTP username,
$mail->Password = "passwordnya"; // SMTP password dari account smtp

$mail->From = $_POST['email']; // Email yang dikirim lewat form
$mail->FromName = 'adminLibrary'; // Nama pengirim email
$mail->AddAddress("irene_indahps@yahoo.com"); // Email yang dituju
$mail->Subject = 'New File upload'; // isi subyek
$mail->Body = 'isi emailnya nih'; // isi email