1

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.

Mukta
  • 11
  • 1
  • 2
  • Are you talking about millions of rows? – Adam Arold Apr 21 '11 at 07:17
  • 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 Apr 21 '11 at 18:54

3 Answers3

2

Try using fpdf. Also this question might help you.

Community
  • 1
  • 1
S L
  • 14,262
  • 17
  • 77
  • 116
  • This is not an answer in any way – Shakti Singh Apr 21 '11 at 07:20
  • @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! – James Anderson Apr 21 '11 at 08:20
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.

Devart
  • 119,203
  • 23
  • 166
  • 186
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

Martin Thoma
  • 124,992
  • 159
  • 614
  • 958
Mohammad Efazati
  • 4,812
  • 2
  • 35
  • 50