Reports with FPDF.

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Reports with FPDF.

Postby shehan31 » Fri Dec 10, 2010 7:54 am

Hi all;
I have devolop a php code by looking at some examples on fpdf. What this does is it imports data from a mysql server onto a pdf. Unfortunatley it dosent appear as i wanted. cells are overlapping each other. Does anyone know how to solve this problem? Please refer my attachments.
Syntax: [ Download ] [ Hide ]
<?php
  require("C:/wamp/www/fpdf.php");

$connect = mysql_connect ("localhost","root","") or die ("error");
mysql_select_db ("guestbook") or die ("eroor connecting Database");
/*

$queryget = mysql_query ("select * from report ORDER BY Transaction_Number DESC LIMIT 5" ) or die (" error with table");*/

$todayDate = date('Y-m-d');
$queryget = mysql_query ("select * from report WHERE Date='".$todayDate."' " ) or die (" error with table");

$number_of_products = mysql_numrows($queryget);

$column_Customername = "";
$column_Transaction = "";
$column_Time = "";
$column_Weight = "";
$column_Price = "";
$column_Date ="";
$total = 0;
$total1=0;


 while ( $row = mysql_fetch_assoc ($queryget) ){
$id = $row['id'];
  $Customername = $row ['Customer_name'];
  $Transaction_Number = $row ['Transaction_Number'];
  $Price = $row ['Price'];
  $Weight = $row ['Weight'];
  $date = $row ['Date'];
  $time = $row ['Time'];
  $column_Customername = $column_Customername.$Customername."\n";
  $column_Transaction = $column_Transaction.$Transaction_Number."\n";
  $column_Time = $column_Time.$time."\n";
  $column_Weight = $column_Weight.$Weight."\n";
  $column_Price = $column_Price.$Price."\n";
  $column_Date = $column_Date.$date."\n";
 
  $total = $total+$Price;
  $total1 = $total1+$Weight;
  }
 

 $pdf=new FPDF();
$pdf->AddPage();

class PDF extends FPDF
{
//Page header
/*
function Header()
{
    //Logo
    $this->Image('trans.jpeg',10,8,160);
    //Arial bold 15
    $this->SetFont('Arial','B',15);
    //Move to the right
    $this->Cell(80);
    //Title
    /*$this->Cell(30,10,'Title',1,0,'C');
    //Line break
    $this->Ln(20);
}*/


//Page footer
function Footer()
{
    //Position at 1.5 cm from bottom
    $this->SetY(-15);
    //Arial italic 8
    $this->SetFont('Arial','I',8);
    //Page number
    $this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
        $this->setX(10);
         $this->Cell(0,10,'Confidential',0,0,'L');
}
}

//Instanciation of inherited class
$pdf=new PDF();
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetFont('Times','',12);
/*for($i=1;$i<=40;$i++)
    $pdf->Cell(0,10,'Printing line number '.$i,0,1);*/


$pdf->setX(50);
$pdf->sety(32);
$pdf->cell(25,6,$column_Date);

//Fields Name position
$Y_Fields_Name_position = 40;
//Table position, under Fields Name
$Y_Table_Position = 46;

//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',8);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(30);
$pdf->Cell(25,6,'Trans.Number',1,0,'L',1);
$pdf->SetX(55);
$pdf->Cell(50,6,'Name',1,0,'L',1);
$pdf->SetX(105);
$pdf->Cell(25,6,'Time',1,0,'L',1);
$pdf->SetX(130);
$pdf->Cell(25,6,'Weight',1,0,'L',1);
$pdf->SetX(155);
$pdf->Cell(25,6,'Price',1,0,'L',1);
$pdf->Ln();
//Now show the 3 columns
$pdf->SetFont('Arial','',6);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(30);
$pdf->MultiCell(35,6,$column_Transaction,1,'false');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(55);
$pdf->MultiCell(50,6,$column_Customername,1);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(105);
$pdf->MultiCell(25,6,$column_Time,1,'R');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(130);
$pdf->MultiCell(25,6,$column_Weight,1,'R');
$pdf->SetX(130);
$pdf->MultiCell(25,6,'Kg '.$total1,1,'R');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(155);
$pdf->MultiCell(25,6,$column_Price,1,'R');
$pdf->SetX(155);
$pdf->MultiCell(25,6,'Rs '.$total,1,'R');

$i = 0;
$pdf->SetY($Y_Table_Position);
while ($i < $number_of_products)
{
    $pdf->SetX(45);
    $pdf->MultiCell(120,6,'',1);
    $i = $i +1;
       
}

$pdf->Output();

?>
Attachments
mypdf.jpg
please have a look on this
mypdf.jpg (63.37 KiB) Viewed 2407 times
shehan31
Forum Commoner
 
Posts: 59
Joined: Sun Aug 29, 2010 5:24 am

Return to Miscellaneous

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest