PHP Mysql Export to pdf

Question

I have millions of data to be exported to pdf. I am not able to do that. Please suggest me the way. Using inbuilt header(Content-type: application/pdf) is not resolving my problem. I have also tried using TCPDF.With less data tcpdf works fine but with millions it takes very very long time.

Tell me a way where I can easily export mysql data that counts to millions exported in pdf.

How are you attempting to create this export (e.g. via web site or command-line code)? What is the export format (e.g. tabular)? You're talking about a significant amount of data, so a commercial solution might be in order. Barring that, you might have to create each page (or a batch of pages) separately then join them together to prevent significant resource usage and process slowdown. — BrianS
– BrianS, Commented Apr 21, 2011 at 18:54

Community · Accepted Answer · 2017-05-23 12:31:22Z

2

Try using fpdf. Also this question might help you.

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Apr 21, 2011 at 7:19

S L

14.3k18 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shakti Singh Over a year ago

This is not an answer in any way

James Anderson Over a year ago

@Shakti -- poster suggested a php class which could be used to solved Mukta's problem, plus a link to a post which gives an example of how to use the class. Seems like a pretty complete and concise answer to me!

Devart · Accepted Answer · 2011-04-21 07:29:20Z

0

Try to use Data Import (PDF format) in dbForge Studio for MySQL. There is command-line support, that I think you could use in PHP.

answered Apr 21, 2011 at 7:29

Devart

120k23 gold badges172 silver badges189 bronze badges

Comments

Martin Thoma · Accepted Answer · 2023-02-11 14:50:33Z

0

i suggest you move all data to text file and then you can install any application in linux like this ( http://www.eprg.org/pdfcorner/text2pdf/ )

and now use php exec and use command line of text2pdf in run faster than php

also see this link

http://www.linuxquestions.org/questions/linux-software-2/command-line-text-to-pdf-conversion-290058/
pypdf its python library and you can use it like command line with python commands

edited Feb 11, 2023 at 14:50

Martin Thoma

139k174 gold badges687 silver badges1.1k bronze badges

answered Apr 21, 2011 at 7:38

Mohammad Efazati

4,9122 gold badges40 silver badges51 bronze badges

Collectives™ on Stack Overflow

PHP Mysql Export to pdf

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related