php report generate

[akaballa123]

Hi,

I am i nthe process of creating a website using my limited knowledge of php scripting. This website is used to obtain training information from various users. I have a form to obtain the training session they have ben to recently, and another form to add a new training course available. I have also create a database in mysql to store all the information. Some of the table includes columns such as training name, organization, start date, end date, etc. I would like to create another component where I am able to generate reports based on the columns ( information) that a user wants to see. For example, if a user wants to view the training name and all the users that have participated in this traiining I would need to access the training table and the training user session table for information ( this is a bit generic). My question is can someone guide me in a certain direction ads to how I can get started with generating these reports. I would also like to generate these reports in microsoft excel.

Thanks!

 

[vacunita]

To generate the reports you would need to query the database. using Select statements to fetch the information you need.

Once that is done then you can use PHP to output that information and do whatever you want to do with it.

So first I would for to the forum for the Database server you are using and ask for help on constructing the queries that will retrieve the information. Then you can come back here and we can help you with the output.

As for the Excel part, you can deliver the content as a CSV file if needs be that would immediately open in Excel.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.