Invité
Invité n'ayant pas de compte PHPfrance
16 mars 2006, 12:02
voil mon code
<?php
$ora_conn = ora_logon("*****@***","*****");
$cursor = Ora_Open ($ora_conn);
$query="SELECT * FROM ma_table Where DTCOmmande > '07/03/2006'
" ;
$result = ora_parse($cursor, $query);
$result = ora_exec ($cursor);
$erow = (Ora_Fetch_Into ($cursor, $values,ORA_FETCHINTO_ASSOC));
?>
<html>
<body>
<form action="index2.php" method="post" name="recherche" id="recherche">
<h1 align="center" class="Style5"> COMMAND </h1>
<h1> </h1>
<h1><span class="Style4">Entrez N° De Command </span>:</h1>
<h1>
<input name="numero" type="text" id="numero" size="15">
<input name="Envoyer" type="submit" value="Rechercher" alt="Lancer la recherche!">
</h1>
</form>
</body>
</strong>
<form action="../index.php" method="post" name="" id="">
<table width="221" height="10" border="1">
<tr>
<tr>
<th width="6" scope="col">NUCOCO</th>
<th width="6" scope="col">ACHECO</th>
<th width="6" scope="col">NUFOCO</th>
<tr>
<? do { ?>
<tr>
<? for($i=0;$i<$erow;++$i) { print('<td >'.ora_getcolumn ( $cursor, $i ).'</td>'); } ?>
</tr>
<? } while ($erow = (Ora_Fetch_Into ($cursor, $values)));
?>
<?php
// Se déconnecter de la base
ora_logoff($ora_conn);
?>
</table>
</form>
</html>