<?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();
?>
|
Download
