[RESOLVED] PDF Problem

[savagenoob]

I have tried a few different pdf classes on my website, all of them work locally, but when uploaded to my hosting server (Gocrappy-daddy) it doesnt work. Every time it says the PDF is corrupt. The pdf library is not installed on their server and I didnt think it was an issue with classes such as ezpdf. No errors are displaying on the logs either. Here is my code.

<?php 
require_once('config.php');
//Array to store validation errors
	$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");
}

$rnum = $_GET["tra"];
$sql = "SELECT * FROM accounting WHERE ID = '$rnum'";

$itemList = mysql_query($sql);

while($row = mysql_fetch_array($itemList))
{
	$first = $row["FirstName"];
	$last = $row["LastName"];
	$amount = $row["Amount1"];
	$amount = sprintf("%01.2f", $amount);

$amount2 = $row["Amount2"];
$amount2 = sprintf("%01.2f", $amount2);
$method2 = $row["Amount2RS"];

$reason = $row["Amount1RS"];
$method = $row["Amount1Type"];
$polnum = $row["PolNum"];
$totcol = $row["TotalCollected"];

$day = substr($row["Date"], 8, 2);
$month = substr($row["Date"], 5, 2);
$year = substr($row["Date"], 0, 4);
$hour = substr($row["Date"], 11, 2);
$minute = substr($row["Date"], 14, 2);
$second = substr($row["Date"], 17, 2);

if($hour > 12)
{
	$hour = $hour - 12;
	$meridian = "PM";
}
elseif($hour == 12)
{
	$meridian = "PM";
}
elseif($hour == 0)
{
	$hour = 12;
	$meridian = "AM";
}
else
{
	$meridian = "AM";
}

$now = $month."/".$day."/".$year." ".$hour.":".$minute.":".$second." ".$meridian;
}

$text = "Receipt From \n";
$text1 = $_SESSION['SESS_AGENCY'];
$text2 = "This receipt does not guarantee coverage.";

require_once('class.ezpdf.php');
$pdf =& new Cezpdf();
$pdf->selectFont('./fonts/Courier-Bold.afm');
$data = array(
array('Receipt'=>'Client Name', 'Client'=>$first . " " .$last), 
array('Receipt'=>'Amount 1', 'Client'=>$amount),
array('Receipt'=>'Description', 'Client'=>$method),
array('Receipt'=>'Amount 2', 'Client'=>$amount2),
array('Receipt'=>'Description', 'Client'=>$method2),
array('Receipt'=>'Reason', 'Client'=>$reason),
array('Receipt'=>'Total Collected', 'Client'=>$totcol),
array('Receipt'=>'Date', 'Client'=>$now));

$pdf->addText(70, 180, 14, $text.$text1);
$pdf->addText(70, 160, 14, $text2);
$pdf->ezTable($data,array('Receipt'=>'','Client'=>''),''
,array('showHeadings'=>0
,'shaded'=>0
,'width'=>400,'fontSize' => 14));
$pdf->ezStream();
?>

[etully]

First rule of troubleshooting (and posting to the forums) is to try to reduce the problem down to the smallest block of code that still produces the problem. We can't check your Godaddy account to see if the database is functioning or not. Could be the database. Could be the ability to read in the PDF class. Could be that it can't find the fonts.

So, for example, does this work?

<?php
require_once('class.ezpdf.php');
$pdf =& new Cezpdf();
$pdf->selectFont('./fonts/Courier-Bold.afm');
$pdf->addText(70, 180, 14, "testing");
 $pdf->ezStream();
?>

What about if you comment out the selectFont line? If you can't load the font, then the script is going to have problems making a PDF when you try to set it to a font that doesn't exist.

What if you strip ALL the PDF code out of the script and just read from the database and display the contents? If you can't get the data from the database, then you certainly aren't going to be able to make a PDF with that data.

[savagenoob]

actually, yes, it does work. Sorry for the extended post. I've been coding all day and brain is fried. I am actually happy that it works at all, I thought Godaddy was fubar with generating pdf docs. Whats frusterating is that my code works locally...

[savagenoob]

And now, all i did was add "or die(mysql_error)" to my query and it works now... wtf... / wrist... sorry for the post, im a special person.

[etully]

Adding error checking made your script work? Well, that's not right. I mean, I'm happy it works and all... but that shouldn't fix it.

Maybe there was a typo or something in that line? Maybe a hidden character or something?

Frankly, when you're rested and have some time to look at this, I would do a test of removing the "or die" part and do some troubleshooting like querying the database and printing the results. If you can't do that, then it would explain why the PDF isn't getting created.

It's nice that you sort of stumbled into fixing it... but that doesn't really help you for next time.