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. 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>
    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. 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