PHP Classes

File: sales7.php

Recommend this page to a friend!
  Classes of Eustaquio Rangel de Oliveira Jr.   phpreports   sales7.php   Download  
File: sales7.php
Role: Example script
Content type: text/plain
Description: Sales sample file
Class: phpreports
Report Generator
Author: By
Last change:
Date: 21 years ago
Size: 601 bytes
 

Contents

Class file image Download
<?php
   
// include the PHPReports classes on the PHP path! configure your path here
   
ini_set("include_path",ini_get("include_path").":/var/www/html/phpreports/");
    include
"PHPReportMaker.php";

   
$sSQL = "select id,name,city,product,value,concat('http://www.mysite.com/customers.php?id=',id) as url from saleslog order by city,id";
   
$oRpt = new PHPReportMaker();

   
$oRpt->setXML("sales7.xml");
   
$oRpt->setUser("taq");
   
$oRpt->setPassword("******");
   
$oRpt->setConnection("localhost");
   
$oRpt->setDatabaseInterface("mysql");
   
$oRpt->setSQL($sSQL);
   
$oRpt->setDatabase("phpreports");
   
$oRpt->run();
?>