PHP Classes

What is the best PHP mysql report class?: Build a nice report

Recommend this page to a friend!
  All requests RSS feed  >  What is the best PHP mysql report class?  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

What is the best PHP mysql report class?

Edit

Picture of Yiu 2015 by Yiu 2015 - 1 year ago (2022-12-17)

Build a nice report

This request is clear and relevant.
This request is not clear or is not relevant.

+1

I want to build a nice report from MySQL queries.

Ask clarification

2 Recommendations

PHP ODT Template SQL Reports: Generate report from MySQL data using ODT template

This recommendation solves the problem.
This recommendation does not solve the problem.

0

Picture of Marco Sillano by Marco Sillano package author package author Reputation 220 - 1 year ago (2023-01-25) Comment

This Report generator is based on odt (OpenOffice) templates, giving the user total freedom. Features: - Based on templates created using OpenOffice (.odt files) - Templates can be of any size (A4, A3...) and multipage. - On templates this system can do the following: * Simple substitution based on couples #field#/value. * Blocks and nested blocks duplication (any deep) or deletion. * Pictures substitution. - The HTML User Interface is built by System and can easily be added to an existing php application. Add only 2 lines ( see odtReportSQL-test.php) * <?php include('odtReportSQL.php'); ?> * <?php echo getReportMenu('this_page'); ?> - This system is DB driven, using 2 tables to define all templates substitutions and UI

Example (a big A3 timetable for school exams) see file Notice-example_A3.pdf in github. Example (look and feel) see file 2017-04-19.210908.shot.png in github A Test Template: see file 2017-04-20.075902.shot.png And the resulting report:

see file 2017-04-20.080141.shot.png

I use it to build datasheets for IOT devices (see tuyaDaemon project in gitHub, devices lists.

Hope that can help. m.s.

PHP MySQL Table Information: Creates a PDF report with a MySQL table structure

This recommendation solves the problem.
This recommendation does not solve the problem.

+1

Picture of Stefan Kientzler by Stefan Kientzler package author package author Reputation 370 - 1 year ago (2022-12-17) Comment

Even if the request 'build a nice report' is very general and subjective, I think that the following package can help. Otherwise, the request may should be formulated a little more specifically...

Using this package, you are able to generate a report containing all Inforations to a given MySQL database (including all Tables, Triggers, Stored procedures)

  • 1 Comment

  • 1. Picture of Stefan Kientzler by Stefan Kientzler package author package author - 1 year ago (2022-12-18) Reply

    OK - so i think, the package

    11553-PHP-Generate-PDF-documents-with-tables-displaying-data.html#information

    could give you the ability to generate any report from the result of a SQL query.

    Just replace the following loop in the example

    for ($iRow = 1; $iRow <= 100; $iRow++) {

    with a construction like this:

    $res = $db->query("SELECT * FROM myTable"); while (($row = $res->fetch_array(MYSQLI_ASSOC)) != false) {

Recommend package
: 
: