PHP Classes

PHP Reporting Library: Generate reports with database data

Recommend this page to a friend!
     
  Info   View files Example   View files View files (19)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 226 All time: 8,195 This week: 455Up
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  
Name: Angel Alberto Briceño ... <contact>
Classes: 2 packages by
Country: Peru Peru
Age: ???
All time rank: 355212 in Peru Peru
Week rank: 295 Up2 in Peru Peru Up

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  
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

  Files folder image Files  /  ReportLib  
File Role Description
  Accessible without login Plain text file autoload.php Aux. Auxiliary script
  Plain text file DetallePagina.php Class Class source
  Plain text file EncabezadoPagina.php Class Class source
  Plain text file EscLib.php Class Class source
  Plain text file FormatoBloque.php Class Class source
  Accessible without login Plain text file index.php Aux. Auxiliary script
  Plain text file MainObject.php Class Class source
  Plain text file Pagina.php Class Class source
  Plain text file PiePagina.php Class Class source
  Plain text file ReportLib.php Class Class source
  Plain text file ResumenPagina.php Class Class source
  Plain text file TituloPagina.php Class Class source

Downloadreportlib-2017-07-25.zip 12KB
Downloadreportlib-2017-07-25.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:226
This week:0
All time:8,195
This week:455Up

  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.