Update SQL statement in php with javascript on a submit button

Question

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 !

What happens when you run the code? Do you get any error?

ekad
– ekad

2015-07-17 16:06:10 +00:00
Commented Jul 17, 2015 at 16:06 — ekad
– ekad, Commented Jul 17, 2015 at 16:06
Missing '}' in your while statement.

Jibon
– Jibon

2015-07-17 16:22:46 +00:00
Commented Jul 17, 2015 at 16:22 — Jibon
– Jibon, Commented Jul 17, 2015 at 16:22

Dan Bracuk · Accepted Answer · 2015-07-17 16:05:54Z

1

Your while block is missing a closing bracket }.

answered Jul 17, 2015 at 16:05

Dan Bracuk

20.8k5 gold badges30 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Malik Naik · Accepted Answer · 2015-07-17 20:23:44Z

0

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();
?>

edited Jul 17, 2015 at 20:23

answered Jul 17, 2015 at 16:59

Malik Naik

1,50015 silver badges16 bronze badges

4 Comments

tom Over a year ago

Hello all, many thanks for your replies. I did try what you told me, but my query is not working, it should update my table but it doesn't do it. I also noticed that the update is not happening WHEN I click on my Submit button at the end of my formular (I want to only update the table when I validate on Submit).

Malik Naik Over a year ago

@tom Try adding slashes to $var. abcdefghijklmnopqrstuv and remove stripslashes

tom Over a year ago

@ Malik : what do you mean add slashes, like that: vara=/$vara/

tom Over a year ago

@ Malik I don't understand where to put the slashes, I put them in the query like /$vara/ but it is not working either

Collectives™ on Stack Overflow

Update SQL statement in php with javascript on a submit button

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related