create pdf doc from mysql table data using php

Question

Ritesh_4 71 Posting Pro

13 Years Ago

Hello
I need to create a pdf doc which will look like the word doc attached, and have to use php to do so.
In the doc, the blue texts will need to be filled from data fetched from table User in mysql, and the Autofill part as well will be filled from another table, ADDRESS, which does contain a foreign key, IDMEMBER, to relate to the MEMBER table primary key. The table shown in the attached doc needs to be present as template, with the columns shown, along with the other texts.
I've also been given futher php classes to use (see members_....zip file)

Anyone can help me on how to proceed with this?

mysql pdf php

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with msword files.

exampledoc.doc (39.5 KB)

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

members_controller.zip (12.96 KB)

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

members_models.zip (4.99 KB)

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

members_views.zip (8.34 KB)

Edited 13 Years Ago by Ritesh_4 because: n/a

2 Contributors
2 Replies
472 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by Ritesh_4

chrishea 182 Nearly a Posting Virtuoso

13 Years Ago

There are other ways to produce a PDF file but I find it simplest to create the output in html first, make sure that it is all displaying correctly and then let HTML2PDF convert it. You need to ensure that the HTML is complete (e.g. every opening tag has a closing tag) but as long as you do that, it works pretty well.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Ritesh_4 71 Posting Pro · Answer 1 · 2011-10-20T12:34:29+00:00

There are other ways to produce a PDF file but I find it simplest to create the output in html first, make sure that it is all displaying correctly and then let HTML2PDF convert it. You need to ensure that the HTML is complete (e.g. every opening tag has a closing tag) but as long as you do that, it works pretty well.

thanks will give it a go