Php et sql

voila DasSium95?,mon code du formulaire
<html>
<head>
<title>modification de données</title>
</head>

<body>
<?php

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)or die('error connecting to mysql');
$dbname = 'asta';
mysql_select_db($dbname);

$id_devis=$_POST["id_devis"];
$jour=$_POST["jour"];
$mois=$_POST["mois"];
$annee=$_POST["annee"];
$description_devis=$_POST["description_devis"];
$montant=$_POST["montant"];
$remise=$_POST["remise"];

$var=$_GET['var'];
// print $_GET['var'];
?><br><br><?php

$date=$annee."-".$mois."-".$jour;

$query="select * from devis where id_devis='$var'";
//echo $query;
$result = mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result)){

?>
<form methode="post" name="deposer" >
<table width="366" border="0" align="center">
<input type="hidden" name="id_devis" value="<?php print("$row[id_devis]");?>">

<tr bgcolor="#969696">
<td width="134" align="right">
Date
</td>
<td width="222">

<input name="date" type="text" maxlength="20" value="<?php

print("$row[date]");

?>">
</td>
</tr>
<tr bgcolor="#969696">
<td width="700" align="right">
Description Devis
</td>
<td width="500">

<input name="date" type="text" maxlength="20" value="<?php

print("$row[description_devis]");

?>">
</td>
</tr>

<tr bgcolor="#969696">
<td width="700" align="right">
Montant
</td>
<td width="500">

<input name="date" type="text" maxlength="20" value="<?php

print("$row[montant]");

?>">
</td>
</tr>
<tr bgcolor="#969696">
<td width="134" align="right">
Remise
</td>
<td width="222">
<input name="remise" type="text" maxlength="20" value=
"<?php

print("$row[remise]");

?>">
</td>
</tr>
</table><br>
<center> <INPUT TYPE="SUBMIT" VALUE="modifier" >

<input type="reset" value= "Annuler" ></center></p>
</form>
<?php
}
?>

</body>
</html>

voila mon code du modification

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Document sans titre</title>
</head>

<body>
<?PHP
$id_devis=$_POST["id_devis"];
$id_client=$_POST["id_client"];
$id_panne=$_POST["id_panne"];
$date=$_POST["date"];
$description_devis=$_POST["description_devis"];
$montant=$_POST["montant"];
$remise=$_POST["remise"];
$var1=$_GET['var1'];
echo $var1;

$var2=$_GET['var2'];
echo $var2;
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)or die('error connecting to mysql');
$dbname = 'asta';
mysql_select_db($dbname);
$query="UPDATE devis SET remise='$remise' where remise='$var2' ";
$result = mysql_query($query) or die(mysql_error());
echo $query;

?>
</body>
</html>

</body>
</html>

4 réponses

  1. la page modification2.php qui contient la requête de modification
    et sa affiche celui ci
    UPDATE devis SET remise='' where remise='10'

    cad qu'il a récupérer la valeur du champ remise afficher dans le formulaire mais pas la nouvelle valeur que j'ai fais entrer pour modifier le champ remise
    1. il te manque toujours l'action dans l'en tête du form
      1. MERCI BIEN J'AIMERAIS TE DIRE QU'ON FIN J AI RÉSOLU MON PROBLÈME .C' ÉTAIS UNE FAUTE TRÈS DÉBILE J'ÉCRIS MÉTHODE AU LIEU DE METHOD
      2. di toi je l'avais même pas vu et en effet tu avais mis un "e"^^
    2. PARDON JE ME SUIS TROMPE VOICI LE CODE

      <html>
      <head>
      <title>modification de données</title>
      </head>

      <body>
      <?php

      $dbhost = 'localhost';
      $dbuser = 'root';
      $dbpass = '';
      $conn = mysql_connect($dbhost,$dbuser,$dbpass)or die('error connecting to mysql');
      $dbname = 'asta';
      mysql_select_db($dbname);

      $id_devis=$_POST["id_devis"];
      $jour=$_POST["jour"];
      $mois=$_POST["mois"];
      $annee=$_POST["annee"];
      $description_devis=$_POST["description_devis"];
      $montant=$_POST["montant"];
      $remise=$_POST["remise"];

      $var=$_GET['var'];
      // print $_GET['var'];
      ?><br><br><?php

      $date=$annee."-".$mois."-".$jour;

      $query="select * from devis where id_devis='$var'";
      //echo $query;
      $result = mysql_query($query) or die(mysql_error());
      while($row=mysql_fetch_array($result)){

      ?>

      <form methode="post" name="deposer" action="modification2.php">
      <table width="366" border="0" align="center">
      <input type="hidden" name="id_devis" value="<?php print("$row[id_devis]");?>">

      <tr bgcolor="#969696">
      <td width="134" align="right">
      Date
      </td>
      <td width="222">

      <input name="date" type="text" maxlength="20" value="<?php

      print("$row[date]");

      ?>">
      </td>
      </tr>
      <tr bgcolor="#969696">
      <td width="700" align="right">
      Description Devis
      </td>
      <td width="500">

      <input name="date" type="text" maxlength="20" value="<?php

      print("$row[description_devis]");

      ?>">
      </td>
      </tr>

      <tr bgcolor="#969696">
      <td width="700" align="right">
      Montant
      </td>
      <td width="500">

      <input name="date" type="text" maxlength="20" value="<?php

      print("$row[montant]");

      ?>">
      </td>
      </tr>
      <tr bgcolor="#969696">
      <td width="134" align="right">
      Remise
      </td>
      <td width="222">
      <input name="remise" type="text" maxlength="20" value=
      "<?php

      print("$row[remise]");

      ?>">
      </td>
      </tr>
      </table><br>
      <center>

      <?php echo'<a href="modification2.php?var1='.$row[id_devis].'& var2='.$row[remise].'">modifier</a>'?>

      <input type="reset" value= "Annuler" ></center></p>
      </form>';

      </form>
      <?php
      }
      ?>

      </body>
      </html>