Page 1 of 1
Printing a MYSQL CRUD report
Posted: Mon Apr 24, 2023 5:16 am
by trevorm
Hi
I have several pages in my business web site built using WWB that incorporate reports generated by using the MYSQL CRUD extension.
Is there a simple way to print the report that is displayed. i.e. add a print button.
I have to report to staff on occasions and currently I am using a screen print app. It would be more convenient to be able to print to pdf.
Thank you.
Re: Printing a MYSQL CRUD report
Posted: Mon Apr 24, 2023 6:17 am
by Pablo
There is no dedicated print option for the extensive itself, but you can use the standard browser print functionality.
For example, via events.
Printing to PDF is not a standard HTML option.
Re: Printing a MYSQL CRUD report
Posted: Mon Apr 24, 2023 6:23 am
by trevorm
Thanks Pablo - I’ll investigate.
I did have a good look across the forum and the various tutorials. Just wanted to make Sue I wasn’t missing something.
Re: Printing a MYSQL CRUD report
Posted: Mon Apr 24, 2023 6:41 am
by BaconFries
As already mentioned by Pablo this is not directly related to the program but a feature of the browser. Link to how it is done using the browser(s)
https://www.tomsguide.com/how-to/how-to ... e-as-a-pdf
or see the following. Haven't tested the code offered at it.
https://www.tutorialspoint.com/how-to-g ... ml-webpage#
See also the followin. To use some knowledge of htmland javascript need to add to the page.
https://dev.to/climentea/simple-way-to- ... -html-21mh
Re: Printing a MYSQL CRUD report
Posted: Mon Apr 24, 2023 8:49 am
by trevorm
Baconfries - Thank you for the leads - looks promicing
Re: Printing a MYSQL CRUD report
Posted: Tue Apr 25, 2023 8:51 pm
by dustyboots
@trevorm - you may also want to consider free bullzip pdf printer
It’s pretty good and I think you might be able to automate some things as well…
https://www.bullzip.com/products/pdf/info.php
https://www.youtube.com/@bullzip8704/videos
https://www.bullzip.com/kb/
Re: Printing a MYSQL CRUD report
Posted: Tue Apr 25, 2023 9:42 pm
by trevorm
Thanks for that - I’ll check it out. I have had some success with the other help given as well.