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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
|
<?php
if(isset($_POST['NOM']) && isset($_POST['PRENOM']) && isset($_POST['DATE_NAISS']))
{
$sql="UPDATE CLIEN SET NOM= UPPER('".$_POST ['NOM']."'), PRENOM= UPPER('".$_POST ['PRENOM']."'),DATE_NAISS= UPPER('".$_POST ['DATE_NAISS']."')
WHERE UPPER (NOM) like UPPER('".$_POST['ID_NOM']."')
and upper (PRENOM) like upper('".$_POST['ID_PRENOM']."')
and DATE_NAISS like '".$_POST['ID_DATE_NAISS']."'";
$stid = oci_parse($conn, $sql);
oci_execute($stid);
echo $sql;
}
?>
<form method="POST" action="d.php">
<input type="text" name="NOM" value="<?php echo $_POST['NOM'];?>" /><br/>
<input type="hidden" name="ID_NOM" value="<?php echo $_POST['NOM'];?>"/>
<input type="text" name="PRENOM" value="<?php echo $_POST['PRENOM'];?>"/><br/>
<input type="hidden" name="ID_PRENOM" value="<?php echo $_POST['PRENOM'];?>" />
<input type="text" name="DATE_NAISS" value="<?php echo $_POST['DATE_NAISS'];?>"/><br/>
<input type="hidden" name="ID_DATE_NAISS" value="<?php echo $_POST['DATE_NAISS'];?>"/>
<input style= "width:200px" type="submit" value="suppression du dossier" >
<input style= "width:100px"type="submit" value="valider" />
</form>
<input style= "width:150px" type="submit" value="retour" onclick="window.location.replace('p.php')">
<form method="POST" action="d.php">
</div>
<!-- tableau de la situation de la personne -->
<div class="tableau2">
<table>
<tr>
<th style="width: 150px" colspan="3">banque</th>
<th style="width: 80px">date</th>
<th style="width: 80px" colspan="2">Validité</th>
<th style="width: 60px">Référence</th>
<th style="width: 50px">Mise à jour </th>
</tr>
<!-- requete qui permet de de selectionner et récuperer dans un tableau avec utilisation des lés etrangére -->
<?php
$sql = "SELECT * FROM client,banque
WHERE CLIENT.CODECLI= BANQUE.CODEBN
and UPPER (NOM)=UPPER('".$_POST['NOM']."')
and upper (PRENOM) like upper('".$_POST['PRENOM']."')
and DATE_NAISS like '".$_POST['DATE_NAISS']."'
";
echo $sql;
$stid = oci_parse($conn, $sql);
oci_execute($stid);
while ($row = oci_fetch_array($stid)) {
?>
<tr>
<td style="width: 50px"><?php echo $row['BANQUE']?></td>
<td style="width: 50px"><?php echo $row['DATE']?></td>
<td style="width: 50px"> <?php echo $row['VALIDITE']?></td>
<td style="width: 80px"><?php echo $row['REFERENCE']?></td>
</form>
<form method="POST" action="s.php" >
<td > <input type="submit" style= "height: 20px; width: 60px;" value="MISEAJOUR" onclick="window.location.replace('sitvac.php')"/></td>
</tr>
<input type="hidden" id="BANQUE" name="BANQUE"value="<?php echo $row['BANQUE'] ;?>"/>
<input type="hidden" id="DATE" name="DATE"value="<?php echo $row['DATE'] ;?>" />
<input type="hidden" id="REFERENCE" name="REFERENCE"value="<?php echo $row['REFERENCE'] ;?>"/>
<input type="hidden" id="VALIDITE" name="VALIDITE"value="<?php echo $row['VALIDITE'] ;?>"/>
</form>
<?php } ?> |
Partager