Report Generation with PHP and sqlyog?

how to make reports online from a database then print

Page 1 of 1

3 Replies - 4640 Views - Last Post: 10 July 2010 - 04:42 AM Rate Topic: -----

#1 kitsu   User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 23
  • Joined: 26-February 09

Report Generation with PHP and sqlyog?

Posted 08 July 2010 - 05:24 AM

Is there a way or possibility to print a report generated from a database of a website?
like making a report to a pdf file, and the elements on the file is from the mysql/sqlyog database
example is a report of the logged-in members for that week.
I'm using php and sqlyog for a site I'm making... we were assigned to have a report generation function for the site's admin and I want it to do online but I don't know if its possible and how.

I cant find a good way from search engines, they have this kind of codes but for mysql and php only and they didn't mind explaining the code well or show a demo. - _ -

Please Help Me!

This post has been edited by kitsu: 08 July 2010 - 05:31 AM


Is This A Good Question/Topic? 0
  • +

Replies To: Report Generation with PHP and sqlyog?

#2 CTphpnwb   User is offline

  • D.I.C Lover
  • member icon

Reputation: 3802
  • View blog
  • Posts: 13,800
  • Joined: 08-August 08

Re: Report Generation with PHP and sqlyog?

Posted 08 July 2010 - 05:38 AM

Yes. You need to set up the proper query(ies) to retrieve information you've been storing in the database. What have you tried?
Was This Post Helpful? 1
  • +
  • -

#3 Motoma   User is offline

  • D.I.C Addict
  • member icon

Reputation: 452
  • View blog
  • Posts: 798
  • Joined: 08-June 10

Re: Report Generation with PHP and sqlyog?

Posted 08 July 2010 - 08:05 AM

While your posting was not entirely clear, I'm guessing you are looking for a way to get data from a query that you make in SQLyog into another format.

SQLyog has an export feature; once you execute a query, you can right-click in the results pane and there is an Export function in that menu. You can expor tthe data as CSV, HTML, SQL, and Excel. I'm guessing Excel would be the best choice for you, as it would allow you to copy and paste into whatever document you are looking to have the report in.

I hope this helps,
Motoma
Was This Post Helpful? 0
  • +
  • -

#4 kitsu   User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 23
  • Joined: 26-February 09

Re: Report Generation with PHP and sqlyog?

Posted 10 July 2010 - 04:42 AM

If the whole website is online, which is much better? the report generation would be on a windows-based application or use a create pdf code to create a report for a system website?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1