| | [ 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();
}
}
}
?> |
| | 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();
?> |
