[Ilugc] Any report making tools in php for MYSQL database?

[Ganesh Kumar]

Hi Guys,

I am new to php mysql report report making. Any tools available?. I
basically need to have a layout setup. It can be making pdf.give any
clues.
My database table having four columns when user select date.
particular date, data will generated to pdf file.

-Ganesh.
Did I learn something today? If not, I wasted it.
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

[Balachandran Sivakumar]

Hi,

On Sun, Apr 1, 2012 at 9:03 AM, Ganesh Kumar <bugc...@gmail.com> wrote:
> Hi Guys,
>
> I am new to php mysql report report making. Any tools available?. I
> basically need to have a layout setup. It can be making pdf.give any
> clues.

Should it be specifically in PHP? If not, you can try
Python's report lab. Another option is to use phpmyadmin. IIRC, it has
options to generate some reports. For multiple users, you can provide
logins with restricted privileges. But it needs to be tried out
because I am not sure of the exact set of features that it supports.
Thanks

--
Thank you
Balachandran Sivakumar

Arise Awake and stop not till the goal is reached.
                                                             - Swami Vivekananda

Mail: benig...@gmail.com
Blog: http://benignbala.wordpress.com/

[Girish Venkatachalam]

On Sun, Apr 1, 2012 at 9:03 AM, Ganesh Kumar <bugc...@gmail.com> wrote:

> Hi Guys,
>
> I am new to php mysql report report making. Any tools available?. I
> basically need to have a layout setup. It can be making pdf.give any
> clues.
> My database table having four columns when user select date.
> particular date, data will generated to pdf file.
>

Dunno what you mean by layout.

You have several different PDF generation Perl modules on CPAN.

They take input in various forms, text is obviously the default choice.

So you can use an SQL query tool that can get you text output
of your columns and you can generate a table from it as a PDF file.

I use PDF::Table, PDF::API2.

-Girish

[Mohan L]

On Sun, Apr 1, 2012 at 9:33 AM, Girish Venkatachalam <
girishven...@gmail.com> wrote:

> On Sun, Apr 1, 2012 at 9:03 AM, Ganesh Kumar <bugc...@gmail.com> wrote:
> > Hi Guys,
> >
> > I am new to php mysql report report making. Any tools available?. I
> > basically need to have a layout setup. It can be making pdf.give any
> > clues.
> > My database table having four columns when user select date.
> > particular date, data will generated to pdf file.
> >
>

I am not PHP guy to help you. Not sure this what you want. I am just
sharing what I seen from my friend portal. He is using wkhtmltopdf via PHP
bindings in reporting portal to prepare pdf reports from html:

If you want to use specifically php, You may look wkhtmltopdf

wkhtmltopdf : http://code.google.com/p/wkhtmltopdf/
PHP bindings : https://github.com/mreiferson/php-wkhtmltox

There is also some pure php modules available to convert html to pdf.

Thanks
Mohan L