<?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 * from saleslog order by city,id"; $oRpt = new PHPReportMaker();
$oRpt->setXML("sales.xml"); $oRpt->setUser("taq"); $oRpt->setPassword("******"); $oRpt->setConnection("localhost"); $oRpt->setDatabaseInterface("mysql"); $oRpt->setSQL($sSQL); $oRpt->setDatabase("phpreports"); $oRpt->run(); ?>
|