PHP FPDF ForEach loop

Question

The goal I am trying to achieve is to run a mysql query, place the output into a foreach and then dump all the results into a pdf document using the awesome FPDF library. However only the last result record is making it into the pdf library. Here is mysql query:

 $sql1 = "SELECT 
 mytable.AddressLine1,
 mytable.OrgID
 FROM
 mytable";
 $results = $db->query($sql1);

Here is my PHP:

foreach ($results as $all_data) {
$border = 0;
$cardWidth = 1;
$cardHeight = 1;
require_once('fpdf/fpdf.php');
require_once('fpdf/fpdi.php');
$pdf = new FPDI('P','in','Letter');
$pdf->setSourceFile(realpath(ROOT_DIR . 'view' . URL_PATH . 'snTemplate.pdf'));
$pdf->AddPage();
$template = $pdf->importPage(1);
$pdf->useTemplate($template);
$pageNumber = 1;
$pdf->SetFont('Arial', '', 6);
$pdf->SetXY(0, 9.8); 
$pdf->MultiCell(8.5, .2, 'Page ' . $pageNumber, $border,'C');
$pdf->SetXY(0, 9.9);
$pdf->MultiCell(8.5, .2,' Report Form ', $border, 'C');
$pdf->SetXY(0, 10);
$pdf->MultiCell(8.5, .2,
$all_data['AddressLine1'] . ' - ' . $all_data['OrgID'], $border, 'C');
$pdf->Output('Name' . 'sanctionReport' . '.pdf','I');
}

Again there are four results in the table, but only the last recordset is output into the PDF, I would like all results to appear on their individual page, all with in the same report, really dont want to have multiple download boxes on the users screen... they tend to get frightened!

blejzz · Accepted Answer · 2012-04-25 19:19:47Z

2

in each for iteration you recreate the pdf. Move the $pdf = new FPDI(..) before the for loop. And move the pdf->Output after the for loop (Output generate the pdf from the data you give it).

answered Apr 25, 2012 at 19:19

blejzz

3,3575 gold badges43 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Matthew Colley Over a year ago

@ blejzz - that did it. thank you for pointing me in right direction!

Collectives™ on Stack Overflow

PHP FPDF ForEach loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related