PHP Classes

PHP MySQLi Bootstrap Reports: Display results of database queries with Bootstrap

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: 453 All time: 6,158 This week: 36Up
Version License PHP version Categories
bsreports 1.0.0GNU General Publi...5HTML, PHP 5, Databases
Description 

Author

Rajesh Kakkad

This class can display results of database queries with Bootstrap.

It can take a result set handle returned from a database query perform using the MySQLi extension and displays it on a HTML table.

The class returns HTML of a table with the results with a title at the top and footer message at the bottom. The table headers are retrieved from the result set field names.

The table is rendered with Bootstrap CSS styles but several attributes may be configured like the header cell and text color, regular cell and text color, table width, etc..

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

Level 1 Star

Example

<!DOCTYPE html>
<html>
<head>
<title>My Report</title>
    <meta charset="utf-8">
<? include "addbslocal.php" ?>
</head>
<body>
<?
    include_once("phpBSReports.php");
    $rpt = new phpReport();
  $rpt->width = "95%";
    $rpt->header_color = "#4477ff";
    $rpt->header_textcolor="#ffffff";
  $rpt->header_alignment="center";
    $rpt->body_alignment = "left";
    $rpt->body_color = "#ffeeee";
    $rpt->body_textcolor = "#991199";
  $rpt->covered_color="#449999";
    $rpt->covered = '1';
  $rpt->striped='1';
  $rpt->bordered='1';
  $rpt->hover='1';
  $rpt->responsive='0';
  $rpt->inverse='1';
  $rpt->condensed='1';
    $rpt->title = "SMS Groups";
  $rpt->footer="Generated on :".date("d-M-Y");

$con = mysqli_connect("localhost","my_user","my_password","my_db");
//use above code with your database details or include connection file db2.php
//change its values to match your database

//include "db2.php"; //code which makes mysqli connection

include "addjqlocal.php";
echo '<div class="firstdiv" align="center">';
    $res = mysqli_query($con,"select * from msgq");
    $rpt->mysqli_res = $res;
    $rpt->showReport();
    ?>
</div>
</body>
</html>

Screenshots (2)  
  • bsreport1.jpg
  • bsreport3.jpg
  Files folder image Files (11)  
File Role Description
Accessible without login Plain text file addbslocal.php Data for including BS files
Accessible without login Plain text file addjqlocal.php Data for adding jQuery files
Accessible without login Plain text file bootstrap.min.css Data Bootstrap CSS file
Accessible without login Plain text file bootstrap.min.js Data Bootstrap JS file
Accessible without login Plain text file jquery-ui.css Data jQuery UI css
Accessible without login Plain text file jquery-ui.min.js Data jQuery UI JS file
Accessible without login Plain text file jquery.min.js Data jQuery JS file
Plain text file phpBSReports.php Class php Bootstrap Report Class
Accessible without login Plain text file samplereport.php Example Sample report example file

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
Downloadbsreports-2017-02-20.zip 197KB
Downloadbsreports-2017-02-20.tar.gz 200KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:453
This week:0
All time:6,158
This week:36Up

  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.