changing statement into pdf file

[PiiiTeeeR]

Hi,

I have a piece of code, which display a statement through the header function. How to "change" the code to open this data in pdf file?

 

 

 

1. $query = "SELECT licznik, suma, technika FROM dane"
2.  
3. $result = $this->bean->db->query($query, true);
4. $row = $this->bean->db->fetchByAssoc($result);
5. if($row[licznik]==0) $row[licznik]=0;
6. if($row[suma]==0) $row[suma]=0;
7. if($row[technika]==0) $row[technika]=0;
8.  
9. $blad = "Licznik : ".str_pad($row[licznik],3,' ',STR_PAD_LEFT).
10. '\n'.' Suma : '.str_pad($row[suma],5,' ',STR_PAD_LEFT).',00'.
11. '\n'.' technika : '.str_pad($row[technika],5,' ',STR_PAD_LEFT).',00';
12.  
13.  
14. Header('Location: index.php='.$this->bean->id."&error=".$blad);

 

[ginerjm]

This doesn't look like "working" php code (and it's not posted as code here correctly either).  Fix it up so it runs and tell us what errors you get.

 

As for opening in a pdf file - you have to make it a pdf first.

[PiiiTeeeR]

<?php

 

require_once('/home/agentCRM_PDF/tcpdf/tcpdf.php');

 

 

$rekord = $_REQUEST['record']; 

$GLOBALS['log']->fatal(" Cart = ".$rekord."  user = ".$user->id);

 

1. $query = "SELECT licznik, suma, technika FROM dane"
2.  
3. $result = $this->bean->db->query($query, true);
4. $row = $this->bean->db->fetchByAssoc($result);
5. if($row[licznik]==0) $row[licznik]=0;
6. if($row[suma]==0) $row[suma]=0;
7. if($row[technika]==0) $row[technika]=0;
8.  
9. $blad = "Licznik : ".str_pad($row[licznik],3,' ',STR_PAD_LEFT).
10. '\n'.' Suma : '.str_pad($row[suma],5,' ',STR_PAD_LEFT).',00'.
11. '\n'.' technika : '.str_pad($row[technika],5,' ',STR_PAD_LEFT).',00';
12.  
13.  
14. Header('Location: index.php='.$this->bean->id."&error=".$blad);

 

?>

 

This is the whole code. It  works for me.

 

It displays in pop-up window

 

 

               Licznik: 0
               Suma: 0
               Technika: 0

 

I don't get errors but I don't know hot to make it pdf....

[Psycho]

I have a lot of experience with generating PDFs ia a web interface, but this was with the use of custom PostScript files and a backend processor. This would be well outside what you are looking to do.

 

You'll need to run the output through an additional process to make it a PDF. There is built-in PDF handling in PHP (http://php.net/manual/en/book.pdf.php), but I don't think it is the easiest to work with. Fo rexample, you can't just send the output for PDF, you basically have to tell the code where to put each piece of information. For example, for the first line you would provide code to set the position on the page, set the font to use, the color of the font, and then pass the text to output. Then you would set the position for the 2nd line and send the text for that line. Unless you are going to build your own PDF framework, I don't think it is worth your time.

 

However, there are plenty of other frameworks/classes that are available which would be easier. I don't have on to suggest though. Alternatively, there are also applications out there that allow you to prepare a "page" using HTML and then pass that output to an application that will generate it into a PDF. Most of these (at least the ones that do a good job) cost money.

 

Here are a couple resources you can take a look at to see if any meet your needs:

http://www.tcpdf.org/

http://www.fpdf.org/

http://mpdf.bpm1.com/