How to use the database information in Excel or through the calculation after the page to the administrator to see it?

How to use the database information in Excel or through the calculation after the page to the administrator to see it?
As in the English test site, submitted by the student test data, or the data of the questions are like by reading data, background processing data and then through the form of Excel or Web page to export data? Easy for administrators to view?

Reply to discussion (solution)

It's better to show it in HTML directly than to export it.

But the data is too much, there is a corresponding score, a percentage of the score. Text Documents of each type

But the data is too much, there is a corresponding score, a percentage of the score. Text Documents of each type
Joint query to do pagination

Do you have a sample? or ideas

Do you have a sample? or ideas
The idea is a joint query paging AH

Do you have an example file? No joint queries and pagination

Anyway, the administrator does not require performance, data set big point doesn't matter ...
Union query not difficult statement 1 Union_all Statement 2
Paging is a bit more trouble, php100 tutorial has related video to see it will ...

