1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| <?php
$conn = oci_connect("hopital","hopital","//localhost/XE");
if(!$conn){
$e = oci_error();
print'erreur! : '.htmlentities($e['message']);
exit;
}
else{
if(isset($_GET['operation'])) $num_op = $_GET['operation'];
else $num_op = "";
if(isset($_GET['acte'])) $num_acte = $_GET['acte'];
else $num_acte = "";
$stmt = oci_parse($conn, "call pack_operation.recup_medecin(:operation, :acte, :num, :nom, :prenom, :ville, :rue, :cp)");
oci_bind_by_name($stmt,":operation",$num_op,4);
oci_bind_by_name($stmt,":acte",$num_op,4);
oci_bind_by_name($stmt,":num",$num,4);
oci_bind_by_name($stmt,":nom",$nom,4);
oci_bind_by_name($stmt,":prenom",$prenom,4);
oci_bind_by_name($stmt,":ville",$ville,4);
oci_bind_by_name($stmt,":rue",$rue,10);
oci_bind_by_name($stmt,":cp",$cp,4);
oci_execute($stmt);
oci_close($conn);
echo 'num : '.$num.'<br />';
echo 'nom : '.$nom.'<br />';
echo 'prenom : '.$prenom.'<br />';
echo 'adresse : <br />';
echo ' '.$rue.'<br />';
echo ' '.$cp.' '.$ville;
}
echo '<center><a href="http://127.0.0.1/Hopital/listeactes.php?numero='.$num_op.'">Retour aux actes</a></center>';
?> |
Partager