PHP Classes

PHP MySQLi Report Generator class: Generate HTML reports from queries using MySQLi

Recommend this page to a friend!
     
  Info   Example   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 274 All time: 7,679 This week: 64Up
Version License PHP version Categories
php-report-mysqli 1.0.2GNU General Publi...5HTML, PHP 5, Databases
Description 

Author

Rajesh Kakkad

This class can generate HTML reports from queries using MySQLi.

It can execute database queries using MySQLi and output HTML to display the results in tables.

The presentation aspects of your report like text color, header color, table border, size, etc..

This class is based on the original written Hasin Hyder but uses the MySQLi instead.

Picture of Rajesh Kakkad
  Performance   Level  
Name: Rajesh Kakkad <contact>
Classes: 2 packages by
Country: India India

Level 1 Star

Example

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
    <?
$con = mysqli_connect("localhost","agent","agent_123","r4agent");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
    include_once("phpReportGen.php");
    $prg = new phpReportGenerator();
    $prg->width = "100%";
    $prg->cellpad = "0";
    $prg->cellspace = "0";
    $prg->border = "0";
    $prg->header_color = "#666666";
    $prg->header_textcolor="#FFFFFF";
    $prg->body_alignment = "left";
    $prg->body_color = "#CCCCCC";
    $prg->body_textcolor = "#800022";
    $prg->surrounded = '1';


    $res = mysqli_query($con,"select * from agents where id>500");
    $prg->mysqli_resource = $res;
    $prg->title = "Test Table";
    $prg->generateReport();
   
    ?>
</body>
</html>


Screenshots (1)  
  • report.jpg
  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file usage.php Example example usage file
Plain text file phpReportGen.php Class phpReportGenerator mysqli class

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
Downloadphp-report-mysqli-2016-11-13.zip 22KB
Downloadphp-report-mysqli-2016-11-13.tar.gz 22KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:274
This week:0
All time:7,679
This week:64Up
User Comments (2)
 

  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.