CODEWITHSUNDEEP
javascriptphpmysql
tom
tom

Reputation: 55

Update SQL statement in php with javascript on a submit button

I have a php page (a formular) that I can change the values. When I click on submit, I want to update my table with the new values.

Could you help me do it? I post my code, which does not the work because I am certainly missing something.

    <?php 
    //echo '<input id="input_itf" type="text" value="'.$vara.'"><br>';
    $requete = mysql_query("update `names` set `vara`=$vara, `varb`=$varb, `varc`=$varc, `vard`=$vard, `vare`=$vare, `varf`=$varf, 
    `varg`=$varg, `varh`=$varh, `vari`=$vari, `varj`=$varj, `vark`=$vark, `varl`=$varl, `varm`=$varm, `varn`=$varn
    `varo`=$varo, `varp`=$varp, `varq`=$varq, `varr`=$varr, `vars`=$vars, `vart`=$vart, `varu`=$varu, `varv`=$varv WHERE `id`=$id");
    $sql = stripslashes($requete);
    $req=mysql_query($sql) or die(mysql_error());
        while($d=mysql_fetch_array($req))
                { 
                    $nb_trouve++;                   
                    $id=$d['id'];
    $nb_trouve=0;


    mysql_close();
?>

Many thanks in advance for your help !

Upvotes: 0

Views: 89

Answers (2)

Malik Naik
Malik Naik

Reputation: 1502

You declared mysql_query twice and a closing bracket was } missing too..

Try this...

<?php 

//echo '<input id="input_itf" type="text" value="'.$vara.'"><br>';
$requete = "update `names` set `vara`='$vara', `varb`='$varb',`varc`='$varc', `vard`='$vard', `vare`='$vare', `varf`='$varf',`varg`='$varg', `varh`='$varh', `vari`='$vari', `varj`='$varj', `vark`='$vark', `varl`='$varl', `varm`='$varm', `varn`='$varn'`varo`='$varo', `varp`='$varp', `varq`='$varq', `varr`='$varr', `vars`='$vars', `vart`='$vart', `varu`='$varu', `varv`='$varv' WHERE `id`='$id'";
$req=mysql_query($requete) or die(mysql_error());
while($d=mysql_fetch_array($req)){
    $nb_trouve++;
    $id=$d['id'];
    $nb_trouve=0;
}


mysql_close();
?>

Upvotes: 0

Dan Bracuk
Dan Bracuk

Reputation: 20804

Your while block is missing a closing bracket }.

Upvotes: 1

Related Questions