File: usage.php

Recommend this page to a friend!
  Classes of Rajesh Kakkad  >  PHP MySQLi Report Generator class  >  usage.php  >  Download  
File: usage.php
Role: Example script
Content type: text/plain
Description: example usage file
Class: PHP MySQLi Report Generator class
Generate HTML reports from queries using MySQLi
Author: By
Last change: used little bit more complex query to show users that it can use more complex queries to generate report
Date: 4 years ago
Size: 994 bytes
 

Contents

Class file image Download
<!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>


For more information send a message to info at phpclasses dot org.