The 4 errors are:
Warning: mysqli_query() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\projectli\cetakpdf.php on line 133
Warning: mysqli_query() [function.mysqli-query]: Empty query in C:\xampp\htdocs\projectli\cetakpdf.php on line 134
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\projectli\cetakpdf.php on line 149
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\projectli\cetakpdf.php:133) in C:\xampp\htdocs\projectli\fpdf16\fpdf.php on line 1017
FPDF error: Some data has already been output, can't send PDF file
Below are the part of the code that I think the problem is from.
Code: Select all
include("connect.php");
$category=$_POST['category'];
$criteria=$_POST['criteria'];
mysqli_select_db($dbcon,$select);
$result=mysqli_query("SELECT * FROM schools WHERE $category = '$criteria'",$dbcon);
$select = mysqli_query($dbcon,$result);
//$jumlah = mysql_num_rows($result);
{
$pdf=new PDF('L','mm','A3');
$pdf->SetMargins('20','20','20');
$pdf->AddPage();
$pdf->TableHeader();
$pdf->Ln();
$pdf->Ln();
$pdf->Row(array("KOD SEKOLAH","NAMA SEKOLAH","PTJ","SERVER","PC","NB","MONO LASER","COLOR LASER","DOT MATRIX","LCD","SET LAN","JUMLAH KOS","DIBAYAR","TANGGUNGAN"));
$pdf->SetFont('Arial','',8);
$count =0;
$jum=0;
while($row = mysqli_fetch_array($result,MYSQL_ASSOC)){
$count++;
$pdf->Row(array($count,$row['kod_sekolah'],$row['nama_sekolah'],$row['ptj'],$row['server'],$row['pc'],$row['nb'],$row['mono_laser'],$row['color_laser'],$row['dot_matrix'],$row['lcd'],$row['set_lan'],$row['jumlah_kos'],$row['dibayar'],$row['tanggungan']));
}
$pdf->ln();
}
$pdf->Output();