PHP - Need Help Printing To Pdf

Hello,     I am trying to print the invoice in pdf, using fpdf. i am not getting how to do it. I am able to display line items , but its not in proper format. I tried changing X, Y positions, but its not going into my head . Also i want to display Logo and address in left side, invoice number and order date in right side.   Here is the code i have done so far... Please please help me in this    

<?php



require('includes/fpdf/fpdf.php');


//Connect to your database
include("connect/DB_Connect.php");
$id = $_GET['id'];

//Select the Products you want to show in your PDF file
$result=mysql_query("select invoice_no, order_no, order_date, completion_date, artwork, customer_po, order_quantity, comments, order_amount from invoice where invoice_no='".$id."' ") or die(mysql_error());


$number_of_products = mysql_numrows($result);


//Initialize the 3 columns and the total
$column_order_date = "";
$column_order_no = "";
$column_artwork = "";
$column_cpo = "";
$column_order_quantity = "";
$column_order_amount = "";
$column_comments = "";
$total = 0;


//For each row, add the field to the corresponding column
while($row = mysql_fetch_array($result))
{
$order_date = $row["order_date"];
$order_no = $row["order_no"];
$artwork = $row['artwork'];
$cpo = $row['customer_po'];
$oquantity = $row['order_quantity'];
$oamount = $row['order_amount'];
$comments = $row['comments'];
//$price_to_show = number_format($row["Price"],',','.','.');


$column_order_date = $column_order_date.$order_date."\n";
$column_order_no = $column_order_no.$order_no."\n";
$column_artwork = $column_artwork.$artwork."\n";
$column_cpo = $column_cpo.$cpo."\n";
$column_order_quantity = $column_order_quantity.$oquantity."\n";
$column_order_amount = $column_order_amount.$oamount."\n";
$column_comments = $column_comments.$comments."\n";


//Sum all the Prices (TOTAL)
$total = $total+$oamount;
}
mysql_close();




//Create a new PDF file
$pdf=new FPDF();
$pdf->AddPage();


//Fields Name position
$Y_Fields_Name_position = 20;
//Table position, under Fields Name
$Y_Table_Position = 26;


//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',12);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(25,6,'Order Date',1,0,'L',1);


$pdf->SetX(30);
$pdf->Cell(50,6,'Graphixide Order No',1,0,'L',1);


$pdf->SetX(75);
$pdf->Cell(40,6,'Artwork',1,0,'L',1);


$pdf->SetX(110);
$pdf->Cell(20,6,'PO #',1,0,'L',1);


$pdf->SetX(130);
$pdf->Cell(20,6,'Quantity',1,0,'L',1);


$pdf->SetX(150);
$pdf->Cell(25,6,'Amount',1,0,'L',1);


$pdf->SetX(175);
$pdf->Cell(25,6,'Comments',1,0,'L',1);




//Now show the 3 columns
$pdf->SetFont('Arial','',12);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(5);
$pdf->MultiCell(25,6,$column_order_date,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(30);
$pdf->MultiCell(80,6,$column_order_no,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(75);
$pdf->MultiCell(40,6,$column_artwork,1);




$pdf->SetY($Y_Table_Position);
$pdf->SetX(110);
$pdf->MultiCell(20,9,$column_cpo,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(130);
$pdf->MultiCell(20,6,$column_order_quantity,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(75,6,$column_order_amount,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(175);
$pdf->MultiCell(25,10,$column_comments,1);


$pdf->SetY($Y_Table_Position);
$pdf->SetX(150);
$pdf->MultiCell(130,6,'$ '.$total,1,'R');


//Create lines (boxes) for each ROW (Product)
//If you don't use the following code, you don't create the lines separating each row
$i = 0;




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

Here is the output of this code  ss.PNG   32.3KB   7 downloads  

Here is my code...

<?php

    $to = "email@email.com"; //obviously not real
    $from = "noreply@domain.com";  //obviously not real
    $firstName = $_REQUEST['firstName'];
    $headers = "From: $from";
    $subject = "Product Sheet Request";

    /*
    $fields = array();
    $fields{"firstName"} = "firstName";
    $fields{"lastName"} = "lastName";
    $fields{"email"} = "email";
    $fields{"phone"} = "phone";
    $fields{"affiliation"} = "affiliation";
    $fields{"interest"} = "interest";
    $fields{"productSheets"} = "productSheets";
    $fields{"referredBy"} = "referredBy";
    $fields{"additional"} = "additional";
    */
    
    $firstName = $_REQUEST['firstName'];
    $lastName = $_REQUEST['lastName'];
    $email = $_REQUEST['email'];
    $phone = $_REQUEST['phone'];
    $affiliation = $_REQUEST['affiliation'];
    $interest = $_REQUEST['interest'];
    if($interest == 'inclusion'){
        $interest = 'Evaluating for inclusion in product';
    } elseif($interest == 'general'){
        $interest = 'Interested in the technology generally';
    } elseif($interest == 'research'){
        $interest = 'Performing market research';
    } elseif($interest == 'solutions'){
        $interest = 'Looking for competitive solutions';
    }
    $referredBy = $_REQUEST['referredBy'];
    $additional = $_REQUEST['additional'];
    $productSheets[] = $_REQUEST['productSheets'];
    $sheets = print_r($productSheets);
    

    /*
    $body = "A user has requested product sheet(s). Please review their information and respond:\n\n"; foreach($fields as $a => $b){   $body .= sprintf("%20s: %s\n",$b,$_REQUEST[$a]); }
    */
    
    $body = "A user has requested product sheet(s). Please review their information and respond:\n
    
    First Name: ".$firstName."\r
    Last Name: ".$lastName."\r
    Email: ".$email."\r
    Phone Number: ".$phone."\r
    Affiliation: ".$affiliation."\r
    Reason for Interest: ".$interest."\r
    Referred By: ".$referredBy."\r
    Additional Questions/Comments: ".$additional."\r
    Product Sheet(s) Requested: ".$sheets."\n
    ";
    
    
    $send = mail($to, $subject, $body, $headers);

?>

I'm not quite sure how to display the values of the $productSheets array in the email message. Everytime it either outputs "Array" or "1". The $productSheets array is from a checkbox on a form. Everything else is working as expected.

Hello,
I need help with this issue, I am displaying <a href='index.php?cat=h & r'>text</a> when I do print $_GET['cat'] it only displays h, why ?
Thanks

Hi,

I really need to find a way to print the code below in php.

Code: [Select]
<script>
$(document).ready(function()
  {
    $.sticky('The page has loaded!');
  });
</script>

i tried

Code: [Select]
print"<script>
$(document).ready(function()
  {
    $.sticky('The page has loaded!');
  });";
</script>

any help would be great.

is there a way to make a link or button that will print the current page, but only page 1, landscape with no headers or footers?

or print between two tags?

thanks

Hi, I want to echo an image depending on a value. This is the code I'm using
Code: [Select]
<?php if ($row_cliente_RS['estadofactura_titulo']) == 'yes'     
echo '<img src="img/pagada.jpg" width="70" height="15">';
?>...but nothing echoes. What am I doing wrong?
Thanks

I've got a database file from sqlite, there is a multidimensional array in it with 10 metals.
I just want two print out each element in a table

It won't get all the separate data inside a HEREDOC


foreach ($product_prices as $metal => $prices)

"<tr><td>$metal</td><td align = 'right'>".
round($prices[wire][28]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[wire][36]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[wire][45]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[dust][100]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[dust][10]*$l_conv*$w_conv,4).
"<tr><td>$metal</td><td align = 'right'>".
round($prices[dust][1]*$l_conv*$w_conv,4).
"</td></tr>";

Hi there!

I found this code to parse a MySQL query to PDF, but it's for small address labels and I was wondering how to make it for 4x6 labels?
<?php
define('FPDF_FONTPATH','/home/directory/public_html/sub/font/');
require_once('fpdf.php');
//Connect to your database
mysql_connect("localhost", "db_user","db_pw") or
    die ("Could not connect to database");
mysql_select_db("database_name") or
    die ("Could not select database");

$query  = "SELECT employee_name, street_address, City, state, zip_code FROM employees ORDER BY `employee_name` ";
$result = mysql_query($query) or die('Error, query failed');
$num_rows = mysql_num_rows($result);

function PrintAddressLabels($result){ 


  $pdf=new FPDF(); 

  $pdf->Open();
  $pdf->AddPage(); 
  $pdf->SetFont('Arial','B',14);
  $pdf->SetMargins(0,0); 
  $pdf->SetAutoPageBreak(false); 
  $x = 0;
  $y = 0;
  $i=0;

  while (TRUE) {

    if ($row=$result[$i]) {

      //positions set above 
      $LabelText = sprintf("%s\n%s %s\n%s, %s, %s", 
      $row['employee_name'],
      $row['street_address'],
      $row['City'],
      $row['state'],
      $row['zip_code']);


      Avery5160($x,$y,&$pdf,$LabelText);

      $y++; // next row 
      if ($y == 10 ) { // end of page wrap to next column 
        $x++; 
        $y = 0; 
        if ($x == 3 ) { // end of page 
          $x = 0; 
          $y = 0; 
          $pdf->AddPage(); 
        }
      }
      $i++; //counter through result
    } else {
      // Error quit printing 
      break; 
    }

  {
  $pdf->Output('mailing_labels.pdf','D');
}
?>

Does anyone know where I can find some good resources/tutorials that covers how to use the PDF stuff with PHP or know how I can change this up to match for 4x6 at all?

Any help or info is greatly appreciated!

Thanks!

Hi All,

I am trying to generate a PDF report using the below code. the report is being generated perfectly. The problem that I face is that, while printing the report the browser disregards the "IF" condition that I have given in the code.

Explanation :
-----------------
It prints all the data in the MySQL database wherein I wanted the data to be printed only on a certain condition. How do I achieve this?


Quote

<?php
mysql_connect('localhost','user','pass');
mysql_select_db('vaccine');
$array = mysql_query("SELECT cattle_n FROM vactbl");
$num_rows = mysql_num_rows($array);
$array = mysql_query("SELECT * FROM vactbl");
$num_rows = mysql_num_rows($array);
while($info = mysql_fetch_array( $array ))
{
$mas_date = $info['masdt'];
$mas_time = strtotime($mas_date);
$two_week = strtotime("+2 week");
$rpt_date = abs($two_week - $mas_time);
if ($rpt_date >= 7776000)
{
require('mysql_table.php');

class PDF extends PDF_MySQL_Table
{
function Header()
{
    //Title
    $this->SetFont('Arial','B',40);
    $this->Cell(0,6,'Cattle List',0,1,'C');
    $this->Ln(10);
    //Ensure table header is output
    parent::Header();
}
}

//Connect to database
$pdf=new PDF();
$pdf->AddPage();
//First table: put all columns automatically
//$pdf->Table('select * from cattle_det order by no');
//$pdf->AddPage();
//Second table: specify 3 columns
$pdf->AddCol('cattle_n',20,'Cattle','C');
$pdf->AddCol('masdt',40,'Mastitis Date', 'C');
$pdf->AddCol('fmdt',40,'FM Date','C');
$pdf->AddCol('onedt',40,'Vaccine1 Date','C');
$pdf->AddCol('twodt',40,'Vaccine2 Date','C');
$prop=array('HeaderColor'=>array(255,150,100),
            'color1'=>array(210,245,255),
            'color2'=>array(255,255,210),
            'padding'=>2);
$pdf->Table('select cattle_n, masdt, fmdt, onedt, twodt from vactbl order by cattle_n limit 0,10',$prop);
$pdf->Output();
}
else {}
}

?>

hi i have this code here and i was wondering how i could make it print out the values from my database using a drop down menu.
i no this is probably very basic but im a real novice at php and sql.


<?php
mysql_connect('localhost', 'root', '');
mysql_select_db('charity_data');
$result = mysql_query('select * from donations');
?>
<select name="selectname">
<?php
$i = 0;
while ($i < mysql_num_fields($result)){
  $fieldname = mysql_field_name($result, $i);
  echo '<option value="'.$fieldname.'">'.$fieldname.'</option>';
  $i++;
}



?>




</select>

Hi guys,
I'm using this EOD thingi in order to print a table and get it PDF. I am using TCPDF and following their examples to get the PDF output.
I need to print a php variable's value within the EOD.
Can you please help me out.
Below is the piece of code I'm running.

Code: [Select]
$tbl = <<<EOD
<table cellspacing="0" cellpadding="1" border="1">
    <tr>
        <td rowspan="4"><img src="images/m24.jpg"></td>
        <td align="right" width="150">From the desk of</td>
        <td>: $contat</td>
    </tr>
    <tr>
        <td align="right">E-Mail</td>
<td>: $email</td>
    </tr>
    <tr>
       <td align="right">Telephone</td>
   <td>: $telephone</td>
    </tr>
      <tr>
       <td align="right">Mobile</td>
   <td>: $mobile</td>
    </tr>
</table>
EOD;

the $variables are simply ignored. or even if I echo, there is no PHP value.
Can you guys please shed some light on this issue.
Pretty pleeeaaassseee

Hey guys.

I have ran into a problem once again. I want to print a list of data I have in my database being monsters (ID, Name, HP, attack) I want to be able to print them fromt he database then get the "ID" of the monster being selected by a submit button to give the id of that row in some form (a POST?) so i can get the information for that monster in a SELECT when the button is hit.

I will try show you what im trying to do.

Code: [Select]
   
        //Grt the id from the table print at the bottom.
$monster_id = $_POST["monsterid"];


                //this is at the top to get stats on the monster the user has selected to fight
$query="SELECT * FROM monsters WHERE id='$monster_id'";
  $result=mysql_query($query);
    $result=mysql_fetch_array($result);
$monster_exp=$result["exp"];
$exp_dead = round(($monster_exp/100) * 10);
$monster_hp =$result["hp"];
$goldwon =$result["gold"];
$mindam =$result["mindam"];
$maxdam =$result["maxdam"];


 // my battle code goes here using the stats I want above.
------------------------------------------------------------------------------

//This is where the user selects the monster they want to fight.

$query="SELECT * FROM monsters";
$result=mysql_query($query);

$num=mysql_numrows($result);
mysql_close();

$i=0;

<form action="training.php" method="post">
<table border='0' width="400" class="tablee">
<tr>
<th>Monster</th>
<th>Level</th>
<th>HP</th>
    <th>Protection</th>
    <th>Fight?</th>
</tr>
    <?
$query="SELECT * FROM monsters";
$result=mysql_query($query);

$num=mysql_numrows($result);
mysql_close();

$i=0;

while ($i < $num) {

$id=mysql_result($result,$i,"id");
$name=mysql_result($result,$i,"name");
$level=mysql_result($result,$i,"lvl");
$hp=mysql_result($result,$i,"health");
$pro=mysql_result($result,$i,"pro");
?>
<tr>
<th><? echo $mon_name; ?> </th>
    <th><? echo $mon_level; ?> </th>
<th><? echo $mon_hp; ?> </th>
    <th><? echo $mon_pro; ?> </th>
    <th><input type="hidden" value="<? echo $mon_id; ?>" name="monsterid" />
    <input type="submit" value="Fight!" name="submit" /></th>
</tr>
<?
$i++;
}
?>
</table>
    </form>

I hope this makes sense because I am really having problems. My gues is use an array but I could get it to work.

PS: I did a get and it sends ALL the IDs instead of the selected row.

Thanks for any help guys,
Ruddy

Hi I have a problem that I must admit I have come across before but I can't remember the fix.

When I do a simple select query then print it out using a while statement, I can't get it to print out the first record of my results.

I am sure this is to do with the execute statement but I can't get it to work properly.

I currently have test data in so I know this should bring out 6 records but it only lists 5

Hi,

Firstly, these are my tables:

CLASS
class_id                class_name
1                           Donkeys
2                           Monkeys
4                           Classic
9                           Humans

COURSES
class_id                courses_number
9                           6
9                           2
1                           3
2                           2


I would like to print average course_number for each class_name.
So for class_name Donkeys would have average course_number 3.
And for clasS_name Humans, average course_number is 4.

Do you get my point?

Gah, can anyone help. We've written a web app, it was all tested and doing what it should and at the eleventh hour I've hit a snag.

We use TCDPF to create printed reports from a MySQL database. It does what it should when accessed over the 'net however I've just been informed that their firewall won't allow Activ X content through and they won't (as opposed to can't) create an exception to trust our site.

So, I need a workaround.

Option 1) Host a complete copy on their internal network (exceptionally undesirable as it becomes unmanageable).
Option 2) Split the printing components out and host that on a web server on their internal network.
Option 3) Find another way of producing PDF output from a MySQL web app that can traverse a strict firewall.

My preference is for option 2, but I'd like some opinions/thoughts on the best way to proceed before I code myself into a corner once more

Thus far I've tried using an include to a different server but it is spitting it's dummy at the moment.

Does anyone have any opinions on the *easiest* way to work around the problem?

Thanks,

Rob