While loop in FPDF

Question

I'm having some trouble getting a SQL query to work inside fpdf, is this even possible?

I currently have

session_start();
require('fpdf.php');    
class PDF extends FPDF
{
    function Header()
        {
            include('config.php');
            $client_check = $db->prepare("SELECT * FROM clients WHERE client_fullname = '".$_SESSION['client_details']."'");
            $client_check->execute();
            while ($row = $client_check->fetch(PDO::FETCH_ASSOC))
            {
                $client_firstname    = $row ['client_firstname'];
                $client_lastname     = $row ['client_lastname'];
                $client_address      = $row ['client_address'];
                $client_jobaddress   = $row ['client_jobaddress'];
                $client_homephone    = $row ['client_homephone'];

                $this->SetFont('Arial', 'B', 12);
                $this->Cell(10,0,'Ph(H):',0,0,'C');
                $this->Cell(20,0,''.$client_homephone.'', 0,0,'C');
                $this->Line(30,61,100,61);
                $this->Cell(210,0,'Job No:',0,0,'C');
                $this->Cell(-120,0,'Model:',0,0,'C');
                $this->Line(110,61,200,61);
            }
        }
    }
// Instanciation of inherited class
$pdf = new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','',10);
$pdf->Output();

Everything worked nicely before I added the while loop. Now it just spits out a blank pdf to me. How can I fix this?

Can you please tell me what is your actual requirement so i can suggest you a better way. — Praveen kalal, Mar 12 '13 at 04:28
@Praveenkalal I need to make a SQL call to grab data from the database to add to the PDF. — , Mar 12 '13 at 04:35
please first check the loop is working properly and then second thing change position dynamically else it will overwrite the text each time. — Praveen kalal, Mar 12 '13 at 04:39
What ever you are trying is possible with FPDF. You need to check your loop . — Samy, Mar 12 '13 at 05:41
are you checking if the query executed properly near $client_check->execute?? — funtime, Mar 13 '13 at 16:43

score 0 · Answer 1 · answered Mar 14 '13 at 02:22

$con = mysql_connect("localhost", "{username}", "{password}") or die(mysql_error()) ; 
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
$db = mysql_select_db("{db}", $con) or die(mysql_error()) ; 
$client= mysql_query("{SELECT * FROM clients}")or die(mysql_error());
while ($client2= mysql_fetch_array($client)){

$pdf = new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','',10);

$pdf->Cell(20,0,''.$client2["client_homephone"].'', 0,0,'C');
.....

}

mysql_close($con);

$pdf->Output();

Appreciate the reply but mysql_* functions should not be used. See http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php — , Mar 14 '13 at 04:33

score 0 · Answer 2 · answered Mar 18 '13 at 08:12

I am afraid you cant do that

This is because your Header function is run every time a new page is added(which is done automatically if a page overflows) to the pdf

Instead you can do like this

Create a constructor to the PDF class which calls a function say Fill_details
Move the while loop into the function Fill_details
Header and Footer functions should contain only that part of the code that is common to all pages say like page borders,footer copyright ,etc

While loop in FPDF

2 Answers2