function query($SQLCmd) { if (!$this->isConnect) { return null; } $cursor = ora_open($this->connection); ora_parse($cursor, $SQLCmd); ora_exec($cursor); $results = array(); $resultName = array(); for ($i = 0; $i < ora_numcols($cursor); $i++) { $resultName[$i] = ora_columnname($cursor, $i); } $cnt = 0; while (ora_fetch($cursor)) { for ($i = 0; $i < ora_numcols($cursor); $i++) { $results[$resultName[$i]][$cnt] = ora_getcolumn($cursor, $i); } $cnt++; } $rs = new ResultSet(); $rs->setHolder($results); ora_close($cursor); return $rs; }
function _initrs() { $this->_numOfRows = -1; $this->_numOfFields = @ora_numcols($this->_queryID); }
$pdf->SetFont('Arial', '', 8); /*$pdf->AddPage(); $pdf->BasicTable($header,$data); $pdf->AddPage(); $pdf->ImprovedTable($header,$data);*/ /* ************************* *************************** */ $isql = "select SGD_RENV_CODIGO, \n\t\t SGD_FENV_CODIGO, \n\t\t SGD_RENV_FECH,\n\t\t SGD_RENV_FECH, \n\t\t RADI_NUME_SAL, \n\t\t SGD_RENV_DESTINO, \n\t\t SGD_RENV_TELEFONO, \n\t\t SGD_RENV_MAIL, \n\t\t SGD_RENV_PESO, \n\t\t SGD_RENV_VALOR, \n\t\t SGD_RENV_CERTIFICADO, \n\t\t SGD_RENV_ESTADO, \n\t\t USUA_DOC from SGD_RENV_REGENVIO "; include "../config.php"; $cursor = ora_open($handle); $resultado = ora_parse($cursor, $isql); $resultado = ora_exec($cursor); $line = 0; $data = array(); $numCols = ora_numcols($cursor); while (ora_fetch($cursor)) { $line = ""; for ($i = 0; $i < $numCols; $i++) { if ($i >= 1) { $line .= ";"; } $line .= ora_getcolumn($cursor, $i); } // echo $line . "<br>"; $data[] = explode(';', chop($line)); } $pdf->AddPage(); $pdf->FancyTable($header, $data, $w); $arpdf_tmp = "../rad_salida/tmp_pdf/22l_jhlc.pdf"; $pdf->Output($arpdf_tmp);