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 - 2 years ago (2022-12-17)

Build a nice report

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

+2

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 package can generate report from MySQL data using ODT template.

It can process document templates in the ODT format used by OpenOffice and replaces the template placeholder values with data from MySQL database query results.

The template engine supports variable substitution by text or even pictures, blocks to iterate over data, nested blocks, picture substitution.
This recommendation solves the problem.
This recommendation does not solve the problem.

+1

Picture of Marco Sillano by Marco Sillano package author package author Reputation 255 - 2 years 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 package can be used to creates a PDF report with a MySQL table structure.

It provides a class to access a MySQL database using MySQLi and query the structure of a database table.

Another class can generate a PDF document to display the details of the MySQL database structure like the table name, MySQL engine, rows, create time, update time and comment.
This recommendation solves the problem.
This recommendation does not solve the problem.

+2

Picture of Stefan Kientzler by Stefan Kientzler package author package author Reputation 425 - 2 years 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 - 2 years 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
: 
: