..Csv to MySql..

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 :


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'])) {
?> 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)) { ?>

Source : irene87.blogsome.com/csv2mysql

..MySql to Csv..

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 :

= '$tggl1' and a.t_ticket 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