Generate PDF from MySQL Data.

Asked By georgehurse 0 points N/A Posted on - 08/07/2011

I create a report using PHP. I use MySQL database here.

But now I want to generate a PDF report from it. I have no idea how to create the PDF report.

How can I make that PDF?

 

Exactly I want a PDF report from MySQL data.

• Status: Open
• Question Views: 2204
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by AnnaAlexis

Go To Solution

Best Answer

Best Answer

Answered By AnnaAlexis 0 points N/A #111530

Generate PDF from MySQL Data.

Create a connection with MySql through PHP.

Retrieve required data from database using queries.

After retrieving data from database, you will have to create a new PDF file.
$newPDF=PDF_new(); creates handle for new PDF document.

Then give name to the document:
PDF_open_file($newPDF,”Report.pdf”);

Start a new page by using PDF_begin_page() function and similarly PDF_end_page() is used to end the page. PDF_show_xy() function is to write contents on PDF page at specified position.

Here you will pass the data you retrieved from databases. Do not forget to pass x and y positions. PDF_close () function is to close the PDF file. There are many other functions to add styles and formats.

You can use them to make your PDF report attractive.

About AnnaAlexis

Questions
0

Answers
5

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/08/2011
• Question Category: MySQL Server

Answered By Carl Jack 10 points N/A #111531

Generate PDF from MySQL Data.

Hello George,

You can use fpdf heaps to do just exactly that. Note that there are lots of extra codes that you can get to do things like rounded rectangles, ploygons and so forth.

The following class of code should help you generate PDF from MySQL data:

    $results = $chmdb->query("SELECT * FROM " . DB . "members WHERE active = 1");

    // Standard format
    $pdf = new PDF_Label('5160');
    $pdf->Open();

    // Print labels
    while($row = $results->fetch_object()) {
    $text = sprintf("%s %sn%s %sn%s %s, %s", "$row->first_name", "$row->last_name", "$row->address1",  "$row->address2", "$row->city", "$row->state", "$row->zip");
    $pdf->Add_PDF_Label($text);
    }
    $pdf->Output();

Hopefully this will help you generate PDF from the MySQL data.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 09/06/2012
• Question Category: MySQL Server