<?php
include('../connexion.php');
?>
</form>
<?php
//Connexion deja etablie

if(isset($_POST["update"]))
{
    $nom=trim($_POST["nom"]);
    $prenom=trim($_POST["prenom"]);
    $telephone=trim($_POST["telephone"]);
    $password=trim($_POST["password"]);
    //2) requete de mise a jour
    $requpdate=mysqli_query($conn,"update client set nom='$nom' , prenom='$prenom' , telephone='$telephone' , password='$password'") or die ("Erreur de requete update!");
    //3)Analyse  et affichage des resultats de la requete UPDATE
    $nbre=mysqli_affected_rows($conn);
    if($nbre >0)
    {
        echo "Mise ajour ok!";
    }
    else
    {
        echo "Aucune mise a jour faite!";
    }

}
$secselect=mysqli_query($conn,"select * FROM client") or die ("Erreur de requete update!");
?>

<?php
if(isset($_POST["ok"]))
{
    $code=trim($_POST["code"]);
    //2) requete de mise a jour
    $btnselect=mysqli_query($conn,"select client set code='$code'") or die ("Erreur de requete update!");
    //3)Analyse  et affichage des resultats de la requete UPDATE
    $nbre=mysqli_affected_rows($conn);
    if($nbre >0)
    {
        echo "Mise ajour ok!";
    }
    else
    {
        echo "Aucune mise a jour faite!";
    }

}
$secselect=mysqli_query($conn,"select * FROM client") or die ("Erreur de requete update!");
?>

</div>

<div>
<h3> Formulaire de mise a jour des clients</h3>
<form method="post">
    <table>
  <select>
            <?php while($row1 = mysqli_fetch_array($secselect)):;?>
            <option value="<?php echo $row1[0];?>"><?php echo $row1[0];?></option>
            <?php endwhile;?>
        </select><tr><input type="submit" name="ok" value="ok"></tr>
       <tr><td>Nom</td><td> <input type="text" name="nom" value=""></td></tr>
       <tr><td>Prenom</td><td> <input type="text" name=prenom value=""></td></tr>
       <tr><td>Telephone</td><td> <input type="text" name="telephone" value=""></td></tr>
       <tr><td>Password</td><td> <input type="password" name="password" value=""></td></tr>
       <tr><td><input type="submit" name="update" value="Update"></td></tr>
   </table>