<?php 

include("tcpdf/tcpdf.php");
include("db.php");

$link = @mysqli_connect("localhost","","","admin");

$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true);

$pdf->SetTitle("Title");
$pdf->SetAuthor("Author");
$pdf->SetSubject("Subject");
$pdf->SetKeywords("Keyword");

//Set Page
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$pdf->SetImageScale(PDF_IMAGE_SCALE_RATIO);

//Set FONT
$pdf->SetFontSubsetting(true);
$pdf->SetFont("helvetica", "", 14, "", true);

//Set Header
$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, "Header Description");
$pdf->SetHeaderFont(Array(PDF_FONT_NAME_MAIN, "", PDF_FONT_SIZE_MAIN));
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);

//SetFooter
$pdf->SetHeaderFont(Array(PDF_FONT_NAME_DATA, "", PDF_FONT_SIZE_DATA));
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);


$pdf->AddPage();
$html = "<h1> Ini Halaman 1 </h1>";
$pdf->writeHTML($html);

$sql = "SELECT * FROM notajual ORDER BY idnotajual";
$result = mysqli_query($link, $sql);


$pdf->AddPage();
$html = "<table border='1px'>";
$html .= "<tr>";
$html .= "<td>ID</td>";
$html .= "<td>Nama</td>";
$html .= "<td>Status</td>";
$html .= "</tr>";
$sql = "SELECT * FROM notajual";
$result = mysqli_query($link, $sql);

while($row = mysqli_fetch_array($result)) {
	$html .= "<table>";
	$html .= "<tr>";
	$html .= "<td>". $row["tanggal"] ."</td>";
	$html .= "<td>". $row["grandtotal"] ."</td>";
	$html .= "<td>". $row["nama_customer"] ."</td>";
	$html .= "</tr>";
}
$pdf->writeHTML($html);

//mode "i" supaya pdf tampil (tidak langsung di DL)
$pdf->Output("ubaya.pdf", "i");




?>