<?php

require_once "Excel.class.php";

$tanggal = date("d - m - Y");

$tahun_ajaran = date("Y");

#koneksi ke mysql

$mysqli = new mysqli("localhost","root","","wasis");

if ($mysqli->connect_error) {

 die('Connect Error (' . $mysqli->connect_error . ') ');

}

#akhir koneksi

#ambil data

$query = "SELECT no, nama, no_ujian, no_komputer, satker FROM absen";

$sql = $mysqli->query($query);

$arrabsen = array();

while ($row = $sql->fetch_assoc()) {

 array_push($arrabsen, $row);

}

[color=red][B]#ambil data acara

//-------------------------------------------

$query = "SELECT seleksi FROM acara ";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

//--------------------------------------------

[/B][/color]

#akhir data



$excel = new Excel();

#Send Header

$excel->setHeader('Laporan Absensi.xls');

$excel->BOF();



#header tabel

$excel->writeLabel(0, 0, " DIVISI TEKNOLOGI INFORMASI POLRI GELOMBANG : 1");

$excel->writeLabel(1, 0, " BIRO TEKNOLOGI INFORMASI");

$excel->writeLabel(2, 0, "___________________________________");

$excel->writeLabel(4, 1, "DAFTAR HADIR PESERTA UJI KOMPETENSI KOMPUTER");

$excel->writeLabel(5, 2, "SELEKSI [color=red][B]$row ['no_komputer'][/B][/color] T.A $tahun_ajaran ");

$excel->writeLabel(6, 2, " TANGGAL $tanggal ");

$excel->writeLabel(8, 1, "NO");

$excel->writeLabel(8, 2, "NAMA");

$excel->writeLabel(8, 3, "NO UJIAN");

$excel->writeLabel(8, 4, "NO KOMPUTER");

$excel->writeLabel(8, 5, "SATKER");



#isi data

$i = 9;

foreach ($arrabsen as $baris) {

 $j = 1;

 foreach ($baris as $value) {

 $excel->writeLabel($i, $j, $value);

 $j++;

 }

 $i++;

}



$excel->EOF();



exit();

?>