search

SIMITGROUP / phpjasperxml

This is a php wysiwyg report library
BSD 3-Clause "New" or "Revised" License
44 stars 47 forks source link

Oracle Support? #6

Closed vbspcoder closed 7 years ago

vbspcoder commented 7 years ago

How to make $PHPJasperXML->transferDBtoArray to connect to Oracle

kstan79 commented 7 years ago

Hi,

Latest version we did tried use pdo but never test it properly, u may use it and feed back.

<?php
include_once '/class/PHPJasperXML.inc.php';
include_once '/class/tcpdf/tcpdf.php';
$PHPJasperXML = new PHPJasperXML("en","TCPDF"); //if export excel, can use PHPJasperXML("en","XLS OR XLSX"); 
//$PHPJasperXML->debugsql=true; 
$PHPJasperXML->arrayParameter = array('para1'=>'1','para2'=>'2');
$PHPJasperXML->load_xml_file('file1.jrxml'); //if xml content is string, then $PHPJasperXML->load_xml_string($templatestr);
//$PHPJasperXML->sql = $sql;  //if you wish to overwrite sql inside jrxml
$PHPJasperXML->transferDBtoArray(DBSERVER,DBUSER,DBPASS,DBNAME,"pdo");
$PHPJasperXML->outpage('I');  //$PHPJasperXML->outpage('I=render in browser/D=Download/F=same as file','filename.pdf or filename.xls or filename.xls depends on constructor');
kstan79 commented 7 years ago

Close ticket due to no reply sometimes

SergioRe commented 2 years ago

@kstan79 Could you put what version of PHP and what version of iReport do you use?

kstan79 commented 2 years ago

this phpjasperxml end. use latest method.