Login   Register  
PHP Classes
elePHPant
Icontem

File: sales7.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 11 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();
?>