PHP Indonesia - Facebook: [ tanya ] maaf kak,. saya baru belajar :( saya ma...

PHP Indonesia - Facebook PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

[ tanya ] maaf kak,. saya baru belajar :( saya ma... Apr 22nd 2013, 15:48, by Muhammad Taufiq Hidayat Muhammad Taufiq Hidayat 3:48pm Apr 22 [ tanya ] maaf kak,. saya baru belajar :( saya mau nanya.. cara melooping $worksheet1 , bagaimana ya..? <?php require_once('../db/coonn.php'); require_once('Worksheet.php'); require_once('Workbook.php'); function HeaderingExcel($filename) { header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=$filename" ); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('test.xls'); $workbook = new Workbook(""); $d=mysql_query("SELECT * FROM pk_kelas WHERE kelas='$kls' ORDER by seri ASC"); while ($dk=mysql_fetch_assoc($d)) { $dc=$dk['kode_kelas']; $kj=$dk['jurusan']; $f=mysql_query("SELECT * FROM tbl_jurusan WHERE kode_jurusan='$kj'"); while ($dd=mysql_fetch_assoc($f)) { $dfd=$dk['kelas'].'-'.$dk['seri'].' '.$dd['alias'] ; $worksheet1 =& $workbook->add_worksheet($dfd); $format =& $workbook->add_format(); $format->set_align('vcenter'); $format->set_align('center'); $format->set_color('white'); $format->set_bold(); $format->set_italic(); $format->set_pattern(); $format->set_fg_color('red'); $worksheet1->set_row(0, 15); $worksheet1->set_column(0, 0, 10); $worksheet1->write_string(0, 0, "No", $format); $worksheet1->set_column(0, 1, 30); $worksheet1->write_string(0, 1, "Nama Lengkap", $format); $worksheet1->set_column(0, 2, 20); $worksheet1->write_string(0, 2, "Nama Pelajaran", $format); $worksheet1->set_column(0, 3, 20); $worksheet1->write_string(0, 3, "Nilai", $format); $worksheet1->set_column(0, 4, 20); $worksheet1->write_string(0, 4, "Benar", $format); $worksheet1->set_column(0, 5, 20); $worksheet1->write_string(0, 5, "Salah", $format); $worksheet1->set_column(0, 6, 20); $worksheet1->write_string(0, 6, "Kosong", $format); $worksheet1->set_column(0, 7, 20); $worksheet1->write_string(0, 7, "IP Addres", $format); $d1=mysql_query("SELECT * FROM pk_siswa WHERE kelas='$dc' ORDER by nama_lengkap ASC"); while ($ds=mysql_fetch_assoc($d1)) { $nisn=$ds['nisn']; $d4=mysql_query("SELECT * FROM tbl_nilai WHERE nisn='$nisn'"); while ($dn=mysql_fetch_assoc($d4)) { $plj=$dn['kode_pelajaran']; $d7=mysql_query("SELECT * FROM pk_pelajaran WHeRe kode_pelajaran='$plj'"); $baris = 1; while ($pld=mysql_fetch_assoc($d7)) { $worksheet1->write_number($baris, 0, $c=$c+1); $worksheet1->write_string($baris, 1, $ds['nama_lengkap']); $worksheet1->write_string($baris, 2, $pld['nama_pelajaran']); $worksheet1->write_string($baris, 3, $dn['hasil']); $worksheet1->write_string($baris, 4, $dn['benar']); $worksheet1->write_string($baris, 5, $dn['salah']); $worksheet1->write_string($baris, 6, $dn['kosong']); $worksheet1->write_string($baris, 7, $dn['ip_masuk']); $baris++; } } $workbook->close(); } } } ?> Budi Sasongko 5:18pm Apr 22 itu sdh betul worksheet1 didalam loop while { },cuman $workbook->close() digeser keluar dari loop while { } kalo ane biasa pake $workbook = new Workbook("-"); misal disederhanakan: <?php require_once('../db/coonn.php'); require_once('Worksheet.php'); require_once('Workbook.php'); function HeaderingExcel($filename) { header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=$filename" ); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('test.xls'); $workbook = new Workbook("-"); $d=mysql_query("SELECT * FROM pk_kelas WHERE kelas='$kls' ORDER by seri ASC"); while ($dk=mysql_fetch_assoc($d)) { $dc=$dk['kode_kelas']; $kj=$dk['jurusan']; $f=mysql_query("SELECT * FROM tbl_jurusan WHERE kode_jurusan='$kj'"); while ($dd=mysql_fetch_assoc($f)) { $dfd=$dk['kelas'].'-'.$dk['seri'].' '.$dd['alias'] ; $worksheet1 =& $workbook->add_worksheet($dfd); $worksheet1->set_row(0, 15); $worksheet1->set_column(0, 0, 10); $worksheet1->write_string(0, 0, "No", $format); $worksheet1->set_column(0, 1, 30); $worksheet1->write_string(0, 1, "Nama Lengkap", $format); } } $workbook->close(); ?> Muhammad Taufiq Hidayat 10:00am Apr 23 oke kak . makasih :D Hardi Wantoro Slepet 3:05am Aug 12 --saya kok sering error disini $worksheet1 =& $workbook->add_worksheet($dfd); -- Hardi Wantoro Slepet 3:05am Aug 12 ^_^

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions