Not all cells in FPDF showing

[Gwenne Moses]

Hello there,
Pls help me with this.
I want to output data from database(mySql).Output them in pdf form using FPDF (like a report). My problem is that, Not all the data from the db are being outputted. Just a row(4 cells) is showing. I dont know how to fix this anymore. pls help me..am just a newbie...
Here is my code...

<?php 
//connection
include "config.php";
 
 
$contents="";
 
//Mysql query to get records from database
 
$user_query = mysql_query('SELECT * FROM CMS');
//While loop to fetch the records
while($row = mysql_fetch_array($user_query))
{
$contents.=$row['ID'].",";
$contents.=$row['name'].",";
$contents.=$row['amount'].",";
$contents.=$row['date']." ";
}
 
 
$contents = strip_tags($contents); 
 
 
require('fpdf.php');
 
class PDF extends FPDF
{
// Load data
function LoadData($contents)
{  
    $data = array();
 $fromdata= array(array());
 
       $data[] = explode(',',trim($contents));
 
        $i=0;
        $x=0;
    foreach ($data as $value)
    {
        $fromdata[$i][$x] = $value;
        $x++;
        if ($x%4==0)
        {
            $i++;
            $x=0;
            }
    }
    return $fromdata;    
}
// Colored table
function FancyTable($header,$fromdata)
{
    // Colors, line width and bold font
    $this->SetFillColor(255,0,0);
    $this->SetTextColor(255);
    $this->SetDrawColor(128,0,0);
    $this->SetLineWidth(.3);
    $this->SetFont('','B');
    // Header
    $w = array(40, 35, 40, 45);
    for($i=0;$i<count($header);$i++)
        $this->Cell($w[$i],7,$header[$i],1,0,'C',true);
    $this->Ln();
    // Color and font restoration
    $this->SetFillColor(224,235,255);
    $this->SetTextColor(0);
    $this->SetFont('');
    // Data
    $fill = false;
  //  foreach($data as $row)
 
  for($x=0;$x<count($fromdata);$x++){
        foreach($fromdata[$x] as $row)
    {
        $this->Cell($w[0],6,$row[0],'LR',0,'L',$fill);
        $this->Cell($w[1],6,$row[1],'LR',0,'L',$fill);
        $this->Cell($w[2],6,$row[2],'LR',0,'R',$fill);
        $this->Cell($w[3],6,$row[3],'LR',0,'R',$fill);
        $this->Ln();
        $fill = !$fill;
 
    }
 
  }
    // Closing line
    $this->Cell(array_sum($w),0,'','T');
 
}
}
$pdf = new PDF();
// Column headings
$header = array('ID', 'Name', 'Amount', 'Date');
// Data loading
$fromdata = $pdf->LoadData($contents);
$pdf->SetFont('Arial','',14);
$pdf->AddPage();
$pdf->FancyTable($header,$fromdata);
$pdf->Output();
?>
 

PLEASE!
THANK YOU!!!
:-)

[Rabbit]

The first thing you should do is check that your $fromdata array is being populated correctly.

[Gwenne Moses]

@Rabbit,
Yes sir. I knew from the beginning that the two arrays are causing the problem. I have been trying to alter the loops; remove the $fromdata and the like but still won't work.
Arrays and Loops in PHP are a bit weird. This could have been easy using JAVA. :-(

[Rabbit]

I'm not sure you responded completely to my suggestion. Are you saying the $fromdata array is not populating correctly? What is in the array instead?

[Gwenne Moses]

Hello sir.I have fixed the problem couple of weeks ago. Am sorry, I forgot to post it.Really sorry.
Tnx a lot. :-D

[Rabbit]

Can you post your solution? That way someone else who comes across the same problem can benefit from your solution.