PHP Classes

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

Recommend this page to a friend!
  Info   View files Example   Screenshots Screenshots   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 272 This week: 1All time: 7,696 This week: 560Up
Version License PHP version Categories
php-report-mysqli 1.0.2GNU General Publi...5HTML, PHP 5, Databases
Description 

Author

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
Age: 68
All time rank: 2948184 in India India
Week rank: 411 Up26 in India India Up

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  
  • report.jpg
  Files folder image Files  
File Role Description
Accessible without login Plain text file usage.php Example example usage file
Plain text file phpReportGen.php Class phpReportGenerator mysqli class

 Version Control Unique User Downloads Download Rankings  
 0%
Total:272
This week:1
All time:7,696
This week:560Up
User Comments (2)