Help exporting database to pdf

[mattyj10]

😕
I want to export the products table of my mysql database to .pdf format using php so when you click on a link on the site it opens a pdf file showing all the items in the product table.

Ive got as far as getting a .pdf file open and created with just a single line of text in it see code below
<?php
$pdf = PDF_new();
PDF_open_file($pdf,'');
PDF_set_info($pdf, "author", "Auto Weekly");

PDF_set_info($pdf, "title", "Products");

PDF_set_info($pdf, "creator", "Auto Weekly");

PDF_set_info($pdf, "subject", "Code Gallery Spotlight");
PDF_begin_page($pdf, 250, 250);
$font = PDF_findfont($pdf, "Helvetica-Bold", "winansi",0);

PDF_setfont($pdf, $font, 12);

PDF_show_xy($pdf, "Hello, Dynamic PDFs!", 5, 225); 

PDF_end_page($pdf); 
PDF_close($pdf); 
$buffer = PDF_get_buffer($pdf); 
header("Content-type: application/pdf"); 

header("Content-Length: ".strlen($buffer));
header("Content-Disposition: inline; filename=zend.pdf");
echo $buffer;
PDF_delete($pdf);
?>

I can manually export the table from phpmyadmin to pdf but I wanted a link on my site that did the same thing I need to know how to add like the following which selects all the products and outputs them to a simple table but in the above pdf create part.

$query1 = "SELECT * FROM product1 ORDERBY category ";
$result = mysql_query($query1) or die ("Error in query");

if (mysql_num_rows($result)>0) {
echo "<table width='90%' cellpadding='2' cellspacing='0' summary=''>" .
"<tr valign='top'>" .
"<td width='20%'></td>" .
"<td width='70%'></td>" .
"</tr>";
while ($row = @ mysql_fetch_array($result)) {

   print "    <tr>";                                                         
   print "    <td><img src=images/products/satnav/large/".$row["image_name"] ." width='200' height='200'/></td>";       
   print "    <td><b>" . $row["name"] . "<br></b>";
   print      $row["description"] . "</td>"; 
   print "    </tr>" ;        

} //End while
}
print "</table>";
?>

I’ve tried to find some examples of something similar with no luck and I don't really know where to start as it’s the first time I’ve tried to export something to pdf using php.

Any help greatly appreciated 🙂

Thanks

[mattyj10]

Update Ive got it kind of working but it doesnt line the columns up properly this is code ive used:

<?php
define('FPDF_FONTPATH','font/');
require('fpdf.php');
require("connect.inc");
$connection = mysql_connect($hostname, $username, $password) or die ("Unable to connect!");
mysql_select_db($databaseName) or die ("Unable to select database!");
//Connect to your database

//Select the Products you want to show in your PDF file
$result=mysql_query("select name,features,description,price from product1 ORDER BY category");
$number_of_products = mysql_numrows($result);

//For each row, add the field to the corresponding column
while($row = mysql_fetch_array($result))
{
$name = $row["name"];
$features = $row["features"];
$description = $row["description"];
$price = $row["price"];

$column_name = $column_name.$name."\n";
$column_features = $column_features.$features."\n";
$column_description = $column_description.$description."\n";
$column_price = $column_price.$price."\n";

}
mysql_close();

//Create a new PDF file
$pdf=new FPDF();
$pdf->Open();
$pdf->AddPage();

//Fields Name position
$Y_Fields_Name_position = 5;
//Table position, under Fields Name
$Y_Table_Position = 11;

//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(232,232,232);
//Bold Font for Field Name
$pdf->SetFont('Arial','B',12);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(35,6,'Name',1,0,'L',1);
$pdf->SetX(40);
$pdf->Cell(80,6,'Features',1,0,'L',1);
$pdf->SetX(120);
$pdf->Cell(150,6,'Description',1,0,'L',1);
$pdf->SetX(270);
$pdf->Cell(20,6,'Price',1,0,'L',1);
$pdf->SetX(290);

//Now show the 3 columns
$pdf->SetFont('Arial','',12);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(5);
$pdf->MultiCell(35,6,$column_name,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(40);
$pdf->MultiCell(80,6,$column_features,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(120);
$pdf->MultiCell(150,6,$column_description,1);
$pdf->SetX(270);
$pdf->MultiCell(20,6,$column_price,1);
$pdf->SetX(290);

//Create lines (boxes) for each ROW (Product)
//If you don't use the following code, you don't create the lines separating each row
$i = 0;
$pdf->SetY($Y_Table_Position);
while ($i < $number_of_products)
{
$pdf->SetX(5);
$pdf->MultiCell(290,6,'',1);
$i = $i +1;
}

$pdf->Output();
?>

It works but it displays the columns wrongly see attached pic

If someone could help me get the coloumns on the same page please

Thanks