jana Posted October 9, 2006 Share Posted October 9, 2006 How to generate reports by getting the data from mysql? any idea Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/ Share on other sites More sharing options...
AndyB Posted October 9, 2006 Share Posted October 9, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106173 Share on other sites More sharing options...
brown2005 Posted October 9, 2006 Share Posted October 9, 2006 can u post the table structure and what sort of report u want? Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106174 Share on other sites More sharing options...
jana Posted October 9, 2006 Author Share Posted October 9, 2006 i hav a table emp_master as emp_idemp_nametittlesexdept_idactiveand i want a report in a a4 paper who are all active. Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106198 Share on other sites More sharing options...
AndyB Posted October 9, 2006 Share Posted October 9, 2006 [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. Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106202 Share on other sites More sharing options...
jana Posted October 10, 2006 Author Share Posted October 10, 2006 can i integrate crystal reports with php and mysql? Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106633 Share on other sites More sharing options...
php_coder_dvo Posted October 10, 2006 Share Posted October 10, 2006 [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... Quote Link to comment https://forums.phpfreaks.com/topic/23412-report-generation/#findComment-106649 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.