Jump to content

Archived

This topic is now archived and is closed to further replies.

jana

Report generation

Recommended Posts

How to generate reports by getting the data from mysql? any idea

Share this post


Link to post
Share on other sites
The question is too non-specific for anything other than a general answer.

1. Retrieve the information you want to display (SELECT query, etc.)
2. Loop through the retrieved information and display it as you see fit

Share this post


Link to post
Share on other sites
i hav a table emp_master as

emp_id
emp_name
tittle
sex
dept_id
active

and i want a report in a a4 paper who are all active.

Share this post


Link to post
Share on other sites
[code]$query = "SELECT * from emp_master WHERE active = 'something that means active'";[/code]

And how your report will look when printed depends on your printer settings, i.e. nothing to do with php.

Share this post


Link to post
Share on other sites
can i integrate crystal reports with php and mysql?

Share this post


Link to post
Share on other sites
[quote author=jana link=topic=110938.msg449643#msg449643 date=1160456306]
can i integrate crystal reports with php and mysql?
[/quote]

No.... I dont think so, why not format your page in a descent view...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.