session_start();
include('../config.php');
mysql_select_db("syahadmin");
$query = mysql_query("SELECT * FROM staff where staff_name = 'Aidia'");
WHILE ($rows = mysql_fetch_array($query)) :
$staff_name =$rows['staff_name'];
$staff_id =$rows['staff_id'];
$staff_email =$rows['staff_email'];
$staff_telno =$rows['staff_telno'];
$staff_address =$rows['staff_address'];
$staff_district =$rows['staff_district'];
$staff_poscode =$rows['staff_poscode'];
$staff_username =$rows['staff_username'];
$staff_password =$rows['staff_password'];
$staff_picture =$rows['staff_picture'];
require('mysql_table.php');
class PDF extends PDF_MySQL_Table
{
function Header()
{
$this->SetFont('Arial','',18);
$this->Cell(0,6,'Staff Information',0,1,'C');
$this->Ln(10);
parent::Header();
}
}
$pdf=new PDF();
$pdf->AddPage();
$pdf->Table('SELECT `staff_name`, `staff_id`,`staff_email`,`staff_telno`,`staff_address`,`staff_poscode`,`staff_district`,`staff_state`
from staff order by `staff_name`');
$pdf->AddPage();
$pdf->AddCol('staff_name',43,'','C');
$pdf->AddCol('`staff_id`,',40,'staff','C');
$pdf->AddCol('staff_email',40,'','C');
$pdf->AddCol('staff_telno',40,'','C');
$pdf->AddCol('staff_address',40,'','C');
$pdf->AddCol('staff_poscode',40,'','C');
$pdf->AddCol('staff_district',40,'','C');
$pdf->AddCol('staff_state',40,'','C');
$prop=array('HeaderColor'=>array(255,150,100),
'color1'=>array(210,245,255),
'color2'=>array(255,255,210),
'padding'=>2);
$pdf->Table('select staff_name, staff_id, staff_email, staff_telno, staff_address, staff_poscode, staff_district, staff_state,
from staff order by staff_name limit 0,10',$prop);
$pdf->Output($downloadfilename.".pdf");
header('Location: '.$downloadfilename.".pdf");
endwhile;
?>