PHP to PDF?

[raouleduke]

I have a script that displays a report, can I make this into a PDF, I get the concept behind the PDF generation, but don't know if this is possible or not. Here is what I am trying to put into a PDF.

    mysql_connect(""); 
   mysql_select_db(""); 
    $query = "SELECT * FROM KEYCAD WHERE HOLD LIKE 'Y' AND ACTIVE LIKE 'Y' AND DEACTIVATE LIKE '0'"; 
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)) {
//Display results here
}

Any help appreciated.

[barand]

Check out FPDF .

Its free and it works well

[raouleduke]

I have it, but in all the manual and instructions it does not say anything about inserting a query.

<?php
include ('pdf/class.ezpdf.php');
$pdf = new Cezpdf();
$pdf->selectFont('pdf/fonts/Helvetica.afm');
$pdf->ezText('Hello World',50);
$pdf->ezStream();
?>

Hope you can help!

[trooper]

Another option (one i have used in the past) is to use htmldoc. It creates pdf pages from html pages. So as long as you can create an html page then it'll work just fine

HTH

GM