PHP Classes

PHP Reporting Library: Generate reports with database data

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 228 All time: 8,180 This week: 54Up
Version License PHP version Categories
reportlib 1.0.0BSD License5.6PHP 5, Databases, Printing
Description 

Author

Angel Alberto Briceño Obregón

This package can generate reports with database data.

It can compose reports from data that is configurable through a JSON file that defines table records to be queried and how their contents will be displayed in the report output.

The package can perform database queries to retrieve report data from either MySQL, PostgreSQL and Microsoft SQL Server.

Picture of Angel Alberto Briceño Obregón
  Performance   Level  

Level 1 Star

 Innovation award
Innovation award
Nominee: 1x

 

Recommendations

quick report / dashboard
Able to report real time behind the scene is sql/mysql

Example

<?php
require_once('ReportLib/autoload.php');

$Reporte = new ReportLib();
$Reporte->formatSource["tipo"] = "file";
$Reporte->formatSource["sourcelocation"] = "Formato1.json";
//$Reporte->setVariables(
// "clave: contraseña", "campo: valor", "numero: 56", "tema: psicologia"
//);
$Reporte->setVariables("fecha_inicio: $Reporte->datenow");
$Reporte->formVariables();
$Reporte->CargarFormato();
if ($link = mysqli_connect("thedbhost", "userdb", "thepassword", "thedbname", "3306")) {
    $Reporte->LoadData($link);
} else {
    echo "No podemos conectarnos.\n";
    exit;
}

$Reporte->ToPrint();

Details

ReportLib

A PHP library for print ESC/P2


  Files folder image Files (19)  
File Role Description
Files folder imageReportLib (12 files)
Accessible without login Plain text file chars_utils.php Aux. Auxiliary script
Accessible without login Plain text file Design-Reports.svg Data Auxiliary data
Accessible without login Plain text file example1.php Example Example script
Accessible without login Plain text file Formato1.json Data Auxiliary data
Accessible without login Plain text file index.php Aux. Auxiliary script
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Data Auxiliary data

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadreportlib-2017-07-25.zip 12KB
Downloadreportlib-2017-07-25.tar.gz 9KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:228
This week:0
All time:8,180
This week:54Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.