:: Someday i will understand ::

Nah akhirnya jadi juga semua program dah kelar, sebenernya sih dah kelar dari sebelum libur lebaran kmrn tapi krn blom sempet update blog, yo wes jadinya skrng deh di lengkapinnya. Yup kmrn dah bikin Mysql ke Csv. Nah sekarang cara ngebalikinnya.

Csv to Mysql Code :


< ?php
include "upload_class.php";
include "koneksi.php";
$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!!"; }
}
}
?>


Source : irene87.blogsome.com/csv2mysql

eMmm ini script Mysql ke Cvs, yah niatnya mo di jadiin koleksi *halah barang kalee koleksi *. Dari kemaren keq ketemu ilhamnya *semalem ketemu ilham dikampus*, ilham orang beneran tp dia bukan inspirasi codingnya koq jd ga ada hubungannya. Tinggal bikin Csv ke Mysqlnya, yang ini masih underconstruction belum nemu ilham2 yang lain *halah *.

Mysql to CSV code :

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”;
?>


source : My old blogsome Mysql2csv