Exporting data to pdf is not working , giving some junk errors

General PHP Help
#1

Hello ,

I am trying to export my data to pdf, but some junk data is getting displayed when i hit print pdf button. Here is the output i am getting

%PDF-1.7 %���� 7 0 obj << /Type /Page /Parent 1 0 R /LastModified (D:20140328100129+05’30’) /Resources 2 0 R /MediaBox [0.000000 0.000000 595.276000 841.890000] /CropBox [0.000000 0.000000 595.276000 841.890000] /BleedBox [0.000000 0.000000 595.276000 841.890000] /TrimBox [0.000000 0.000000 595.276000 841.890000] /ArtBox [0.000000 0.000000 595.276000 841.890000] /Contents 8 0 R /Rotate 0 /Group << /Type /Group /S /Transparency /CS /DeviceRGB >> /Annots [ 6 0 R ] /PZ 1 >> endobj 8 0 obj <> stream x�ř�r�0��y��Lf@�ч�%%�09���$ ��ة����+���c��2��v$�_ڵ�0>6aT��ܜpsg^bs��s�9��@���M�8��m’~����෉��a&�) �XF� ^>5������2�߿��� ��6��H2��/@��(&�r��l buA�Q�l�bD<�.S.��m��}�2��� 3��ƒ���t�rǹ�eS~R�e����(����F�#�6��i�r�쇈zax8K�S%S=s��(��/r�A_�Oc���C !7)o��gw\�8��&�R�c�hUvO>�e���Q�P��uZ���r�gE҅S5�U��,e�IwZ(5Eu-�k.�xwp�� �̽�7N��=k��� �'��|�h��h׫����i�ܑ=n]��%{���&l�l�C��i��yW�V��0w��|��4�;7���ȩ�վ��2�!ʵL��������u����3�v�kf�*x���{��kv5x�fWG�hv5t�f�j���]}�[4��s�3�/7��=�4��/� l�K> endobj 3 0 obj <> endobj 4 0 obj <> endobj 5 0 obj <> endobj 2 0 obj << /ProcSet [/PDF /Text /ImageB /ImageC /ImageI] /Font << /F1 3 0 R /F2 4 0 R /F3 5 0 R >> /XObject << >> >> endobj 6 0

I don’t know why i am getting this and how to resolve this.
My php code is

[php]<?php
include(‘includes/SQL_CommonFunctions.inc’);
//include(‘includes/session.inc’);

if(isset($POST[‘ShowPR’])) {
include(‘includes/session.inc’);
$Title=(‘PhilHealth Monthly Premium Listing’);
include(‘includes/header.inc’);
include(‘includes/prlFunctions.php’);

	$sql = "SELECT employeeid,basicpay,othincome,absent,late,otpay,grosspay,loandeduction,sss,hdmf,philhealth,tax,netpay
		FROM prlpayrolltrans
		WHERE prlpayrolltrans.payrollid='" .$_POST['PayrollID']. "'";
		
$PayResult = DB_query($sql,$db);
if(DB_num_rows($PayResult)>0)
{
	
	echo '<table class="selection">';
echo "<tr>
	<th>" . _('Emp ID') . "</th>
	<th>" . _('Full Name') . "</th>
	<th>" . _('Basic') . "</th>
	<th>" . _('Other Income') . "</th>
	<th>" . _('Overtime') . "</th>
	<th>" . _('Gross') . "</th>
	<th>" . _('SSS ') . "</th>
</tr>";

$k=0; //row colour counter

	while ($myrow=DB_fetch_array($PayResult)) {
	    $EmpID =$myrow['employeeid'];
		$FullName=GetName($EmpID, $db);
		$Basic =$myrow['basicpay'];
		$OthInc = $myrow['othincome'];
		$OT =$myrow['otpay'];
		$Gross =$myrow['grosspay'];
		$SSS =$myrow['sss'];
		$HDMF =$myrow['hdmf'];
		$PhilHealth = $myrow['philhealth'];
		$Loan =$myrow['loandeduction'];
		$Tax = $myrow['tax'];
		$Net =$myrow['netpay'];

		$GTBasic +=$myrow['basicpay'];
		$GTOthInc += $myrow['othincome'];
		$GTOT +=$myrow['otpay'];
		$GTGross +=$myrow['grosspay'];
		$GTSSS +=$myrow['sss'];
		$GTHDMF +=$myrow['hdmf'];
		$GTPhilHealth += $myrow['philhealth'];
		$GTLoan +=$myrow['loandeduction'];
		$GTTax += $myrow['tax'];
		$GTNet +=$myrow['netpay'];
	
	

	if ($k==1){
		echo "<tr class='EvenTableRows'>";
		$k=0;
	} else {
		echo "<tr class='OddTableRows'>";
		$k++;
	}

	
	echo '<td>' . $EmpID . '</td>';
	echo '<td>' . $FullName . '</td>';
	echo '<td>' . $GTBasic . '</td>';
	echo '<td>' . $GTOthInc . '</td>';
	echo '<td>' . $GTOT . '</td>';
	echo '<td>' . $GTGross . '</td>';
	echo '<td>' . $SSS . '</td>';
	echo '<td><a href="'. $RootPath . '/prlCreatePayroll.php?PayrollID=' . $PayrollID . '">' . _('Select') . '</a></td>';
	echo '<a href="' . $RootPath . '/StockStatus.php?StockID=' . $StockID . '">' . _('Show Stock Status') . '</a><br />';
	echo '</tr>';
	
	
	}
}
	

   echo 'Use PrintPDF instead';
   echo "<BR><A HREF='" .$RootPath ."/index.php?" ."'>" . _('Back to the menu') . '</A>';
   include('includes/footer.inc');
   exit;

}

If (isset($_POST[‘PrintPDF’])
AND isset($_POST[‘PayrollID’])) {
include(‘includes/session.inc’);
include(‘includes/PDFStarter.php’);
include(‘includes/prlFunctions.php’);

$pdf->addinfo('Title', _('Payroll Register') );
$pdf->addinfo('Subject', _('Payroll Register') );
$FontSize = 10;
$PageNumber = 0;
$line_height = 12;


$PayDesc = GetPayrollRow($_POST['PayrollID'], $db,1);
$FromPeriod = GetPayrollRow($_POST['PayrollID'], $db,3);
$ToPeriod = GetPayrollRow($_POST['PayrollID'], $db,4);

	    $EmpID ='';
		$Basic = 0;
		$OthInc = 0;
		$Lates = 0;
		$Absent = 0;
		$OT = 0;
		$Gross = 0;
		$SSS = 0;
		$HDMF ='';
		$PhilHealt = 0;
		$Loan = 0;
		$Tax = 0;
		$Net = 0;
include('includes/PDFPayRegisterPageHeader.inc');
$k=0; //row colour counter
$sql = "SELECT employeeid,basicpay,othincome,absent,late,otpay,grosspay,loandeduction,sss,hdmf,philhealth,tax,netpay
		FROM prlpayrolltrans
		WHERE prlpayrolltrans.payrollid='" .$_POST['PayrollID']. "'";
		
$PayResult = DB_query($sql,$db);
if(DB_num_rows($PayResult)>0)
{
	while ($myrow=DB_fetch_array($PayResult)) {
	    $EmpID =$myrow['employeeid'];
		$FullName=GetName($EmpID, $db);
		$Basic =$myrow['basicpay'];
		$OthInc = $myrow['othincome'];
		$OT =$myrow['otpay'];
		$Gross =$myrow['grosspay'];
		$SSS =$myrow['sss'];
		$HDMF =$myrow['hdmf'];
		$PhilHealth = $myrow['philhealth'];
		$Loan =$myrow['loandeduction'];
		$Tax = $myrow['tax'];
		$Net =$myrow['netpay'];

		$GTBasic +=$myrow['basicpay'];
		$GTOthInc += $myrow['othincome'];
		$GTOT +=$myrow['otpay'];
		$GTGross +=$myrow['grosspay'];
		$GTSSS +=$myrow['sss'];
		$GTHDMF +=$myrow['hdmf'];
		$GTPhilHealth += $myrow['philhealth'];
		$GTLoan +=$myrow['loandeduction'];
		$GTTax += $myrow['tax'];
		$GTNet +=$myrow['netpay'];
		
		//$YPos -= (2 * $line_height);  //double spacing
		//$FontSize = 8;
		//$pdf->selectFont('./fonts/Helvetica.afm');
		$LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,50,$FontSize,$EmpID);
		$LeftOvers = $pdf->addTextWrap(100,$YPos,120,$FontSize,$FullName,'left');
		$LeftOvers = $pdf->addTextWrap(221,$YPos,50,$FontSize,number_format($Basic,2),'right');
		$LeftOvers = $pdf->addTextWrap(272,$YPos,50,$FontSize,number_format($OthInc,2),'right');
		$LeftOvers = $pdf->addTextWrap(313,$YPos,50,$FontSize,number_format($Lates,2),'right');
		$LeftOvers = $pdf->addTextWrap(354,$YPos,50,$FontSize,number_format($Absent,2),'right');		
		$LeftOvers = $pdf->addTextWrap(395,$YPos,50,$FontSize,number_format($OT,2),'right');
		$LeftOvers = $pdf->addTextWrap(446,$YPos,50,$FontSize,number_format($Gross,2),'right');
		$LeftOvers = $pdf->addTextWrap(487,$YPos,50,$FontSize,number_format($SSS,2),'right');
		$LeftOvers = $pdf->addTextWrap(528,$YPos,50,$FontSize,number_format($HDMF,2),'right');
		$LeftOvers = $pdf->addTextWrap(569,$YPos,50,$FontSize,number_format($PhilHealth,2),'right');
		$LeftOvers = $pdf->addTextWrap(610,$YPos,50,$FontSize,number_format($Loan,2),'right');
		$LeftOvers = $pdf->addTextWrap(671,$YPos,50,$FontSize,number_format($Tax,2),'right');
		$LeftOvers = $pdf->addTextWrap(722,$YPos,50,$FontSize,number_format($Net,2),'right');
		$YPos -= $line_height;
		if ($YPos < ($Bottom_Margin)){		
			include('includes/PDFPayRegisterPageHeader.inc');
		}
	}
	
}//end of loop

		$LeftOvers = $pdf->line($Page_Width-$Right_Margin, $YPos,$Left_Margin, $YPos);
		$YPos -= (2 * $line_height);
		$LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,150,$FontSize,'Grand Total');
		$LeftOvers = $pdf->addTextWrap(221,$YPos,50,$FontSize,number_format($GTBasic,2),'right');
		$LeftOvers = $pdf->addTextWrap(221,$YPos,50,$FontSize,number_format($GTBasic,2),'right');
		$LeftOvers = $pdf->addTextWrap(272,$YPos,50,$FontSize,number_format($GTOthInc,2),'right');
		$LeftOvers = $pdf->addTextWrap(313,$YPos,50,$FontSize,number_format($GTLates,2),'right');
		$LeftOvers = $pdf->addTextWrap(354,$YPos,50,$FontSize,number_format($GTAbsent,2),'right');		
		$LeftOvers = $pdf->addTextWrap(395,$YPos,50,$FontSize,number_format($GTOT,2),'right');
		$LeftOvers = $pdf->addTextWrap(446,$YPos,50,$FontSize,number_format($GTGross,2),'right');
		$LeftOvers = $pdf->addTextWrap(487,$YPos,50,$FontSize,number_format($GTSSS,2),'right');
		$LeftOvers = $pdf->addTextWrap(528,$YPos,50,$FontSize,number_format($GTHDMF,2),'right');
		$LeftOvers = $pdf->addTextWrap(569,$YPos,50,$FontSize,number_format($GTPhilHealth,2),'right');
		$LeftOvers = $pdf->addTextWrap(610,$YPos,50,$FontSize,number_format($GTLoan,2),'right');
		$LeftOvers = $pdf->addTextWrap(671,$YPos,50,$FontSize,number_format($GTTax,2),'right');
		$LeftOvers = $pdf->addTextWrap(722,$YPos,50,$FontSize,number_format($GTNet,2),'right');
					
		$LeftOvers = $pdf->line($Page_Width-$Right_Margin, $YPos,$Left_Margin, $YPos);


$pdfcode = $pdf->output();

$len = strlen($pdfcode);
if ($len<=20){
	$Title = _('Payroll Register Error');
	include('includes/header.inc');
	echo '<p>';
	prnMsg( _('There were no entries to print out for the selections specified') );
	echo '<BR><A HREF="'. $RootPath.'/index.php?' . '">'. _('Back to the menu'). '</A>';
	include('includes/footer.inc');
	exit;
} else {
	header('Content-type: application/pdf');
	header('Content-Length: ' . $len);
	header('Content-Disposition: inline; filename=PayrollRegister.pdf');
	header('Expires: 0');
	header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
	header('Pragma: public');

	$pdf->Stream();

}
exit;

} else { /*The option to print PDF was not hit */

include('includes/session.inc');
$Title=_('Payroll Register');
include('includes/header.inc');

		echo "<form method='post' action='" . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . "'>";
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
	echo '<table class="selection"><TR><TD>' . _('Select Payroll:') . '</TD><TD><SELECT Name="PayrollID">';
	
	$sql = 'SELECT payrollid, payrolldesc FROM prlpayrollperiod';
	$result = DB_query($sql, $db);
	DB_data_seek($result, 0);
	while ($myrow = DB_fetch_array($result)) {
		if ($myrow['payrollid'] == $_POST['PayrollID']) {  
			echo '<OPTION SELECTED VALUE=';
		} else {
			echo '<OPTION VALUE=';
		}
		echo $myrow['payrollid'] . '>' . $myrow['payrolldesc'];
	} //end while loop
echo '</SELECT></TD></TR>';
echo "</TABLE><INPUT TYPE='Submit' NAME='ShowPR' VALUE='" . _('Show Payroll Register') . "'>";
echo "<INPUT TYPE='Submit' NAME='PrintPDF' VALUE='" . _('PrintPDF') . "'>";

include('includes/footer.inc');;

} /*end of else not PrintPDF */

?>[/php]

Please somebody help me in resolving this.
Thanks

#2

Since you are using a PDF library to create your PDF, the error may be inside that library.

The simplest way to debug it would be to comment out sections of the PDF “content” a few lines at a time to see exactly where the error line is. Then trace back that data to see what is bad inside of it.

Not sure what the $leftovers variable does as you do not check it for errors, but, it appears that if you comment out these lines a bit at a time, you should fine the one line causing the errors.

Hope that helps. If not, maybe try the PDF Library site’s forum. OR, ask further questions here…

Sponsor our Newsletter | Privacy Policy | Terms of Service