Topic: Data from mysql to a pdf file, using a php script

[Axelvold]

I have a mysql database where I store information from VWS using VWSql, and now I wonder if there is any way to collect any information from the database using a php script to create a pdf file?

I'm going to have a page where you can choose what you want for information in the file, like period of time (from - to), wind, rain, temperature, etc., etc.

anyone know where I can find such a script?

(I am not quite sure that this is the right place for this question, if not please move it to the right place)

[saratogaWX]

PHP does have a library to create PDF files, but I am not sure that all PHP installations have that library installed.  It looks like your script would have 3 parts:

1) display selection form for information requested
2) retrieve the selected information from your mySQL database
3) format the selected information and print output to a new PDF file for viewing

I've not seen a script for that shared from other developers (and I've not really used much SQL) so I'm of little help here

I suggest you work on (1) and (2) with the output presented on the returned webpage, and when that is functional to your satisfaction, then work on adding (3) as an output option for the viewer. 

Personally, I prefer to view websites (and queries to websites) in HTML as it is much faster to load and lower overhead.  PDF is used to retain presentation fidelity across online and print, and should only be used where a typographical format must be preserved, otherwise HTML presentation is prefered.

Best regards,
Ken

[Axelvold]

Thanks Ken, I will check this right away.

[Bushman]

Here's an example of php form-based selection in front of MySQL.  http://shuswaplakewatch.com/php/datasheet.php  Output to pdf is a POC using client based SW.  There are tons of php-based PDF generators BTW.  Like FPDF.

[Axelvold]

Here's an example of php form-based selection in front of MySQL.  http://shuswaplakewatch.com/php/datasheet.php  Output to pdf is a POC using client based SW.  There are tons of php-based PDF generators BTW.  Like FPDF.

Thanks Bushman

I will check those pages

[Axelvold]

anyone know a good php script that can retrieve data from a mysql database?