Hi!

Anyone can help please?

I am searching around like crazy to make this work but no luck... There are allot of articles with some solutions but nothing works for me... Here is my code

<?php
require_once('../tcpdf/config/lang/eng.php');
require_once('../tcpdf/tcpdf.php');


// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);

// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Dario Balas');
$pdf->SetTitle('PDF');
$pdf->SetSubject('PDF');
$pdf->SetKeywords('PDF');

// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);

//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

//set some language-dependent strings
$pdf->setLanguageArray($l);

// ---------------------------------------------------------

// set default font subsetting mode
$pdf->setFontSubsetting(true);

// Set font
// dejavusans is a UTF-8 Unicode font, if you only need to
// print standard ASCII chars, you can use core fonts like
// helvetica or times to reduce file size.
$pdf->SetFont('dejavusans', '', 14, '', true);

// Add a page
// This method has several options, check the source code documentation for more information.
$pdf->AddPage();




// Set some content to print
$tbl_header = '<table border="1">';
$tbl_footer = '</table>';
$tbl ='';

$con=mysqli_connect("localhost","user","pass","db");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
$result = mysqli_query($con,"SELECT * FROM fl_account_fields");

while($row = mysqli_fetch_array($result))
  {
  $id = $row['ID'];
  $key = $row['Key'];


$tbl = '<tr><td>'.$id.'</td><td>'.$key.'</td></tr>';
}

// Print text using writeHTMLCell()
$pdf->writeHTML($tbl_header . $tbl . $tbl_footer, true, false, false, false, '');

// ---------------------------------------------------------

// Close and output PDF document
// This method has several options, check the source code documentation for more information.
$pdf->Output('', 'I');

//============================================================+
// END OF FILE
//============================================================+
?>

I can display only last record. What do i need to do to display all the records? There is no difference if i put $tbl in or outside of the loop...

Thank you!

Recommended Answers

Change line 68 to:

$tbl .= '<tr><td>' . $id . '</td><td>' . $key . '</td></tr>';

You are overwriting the last line with every loop, instead of concatenating.

Jump to Post

All 3 Replies

Change line 68 to:

$tbl .= '<tr><td>' . $id . '</td><td>' . $key . '</td></tr>';

You are overwriting the last line with every loop, instead of concatenating.

Thank you!!!!!

Hi, I'm facing the same problem and cannot understanding how to separate the table. can you share details.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.