trato d imprimir un query en la pagina pero no me imprime nada , si alguno sab pq o si conoc un metodo d abrir la conexion ejecutar y cerrar no me molesto q me ayuden . gracias.
<?php
$conn = ora_logon("dbo", "dbodesa");
$ociquery = 'SELECT * FROM documentos_tipo';
function execute_query ($query,$conn){
// ouveture du curseur , create a cursor
if (!($cursor= ora_open($conn)))
{ reportError ($conn, " Cursor could not be opened! ");
exit; // Termine le script courant , end the script
}
// parse query // analyse la requete et l'associe au curseur, analyse the query and use the cursor for it
if (!ora_parse ($cursor, $query))
{ reportError ($cursor, " Statement could not be parsed! ");
exit;
}
// execution de la query, execution of the query
if (!ora_exec($cursor))
{ reportError ($cursor, " Statement could not be executed! ");
exit;
}
// ferme le curseur oracle, close the cursor
ora_close($cursor);
// valide la transaction, validation of the transaction (if any)
ora_commit($conn);
}
ora_exec ($ociquery,$conn);
echo '<table border="1">';
while(ora_fetch($cursor) == 1){ // WHILE THERE IS A ROW
for($i=0; $i < $numCols;$i++){ // PARSE THROUGH THE COLUMNS
echo ora_getcolumn($cursor,$i); // PRINT THE RESULTS
}
} echo '</tr>';
}
echo '</table>';
ora_logoff ($conn) ;
?>