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: 2003-03-13 15:13
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();
?>