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: 271 All time: 7,691 This week: 333Up
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
Age: 68
All time rank: 2944184 in India India
Week rank: 658 Up51 in India India Up

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

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