How to update multiple columns in mysql using php

Question

Here i am trying to update update multiple column values in mysql table using php.

$product_id = mysqli_real_escape_string($link, $_POST['product_id']);
$product_name = mysqli_real_escape_string($link, $_POST['product_name']);
$product_category = mysqli_real_escape_string($link, $_POST['product_category']);

$sql = "UPDATE product_list (product_name, product_category, product_price,product_description,product_size_category) VALUES ('$product_name', '$product_category', '$product_price', '$product_description', '$size_category')";
}"

i have 5 column values to be updated in table, i am using variable to save data and using that variable want to update the values in table how can i do that?

possible duplicate of PHP: Update multiple MySQL fields in single query — Insane Skull
– Insane Skull, Commented Sep 7, 2015 at 12:02
your query is insert query. not update query. Use update table_name set column_name = 'value' — Shailesh Katarmal
– Shailesh Katarmal, Commented Sep 7, 2015 at 12:03
@Mithun Please check your query. I think, you are confused with INSERT and UPDATE query. Refer the UPDATE query syntax here — Sivaprakash
– Sivaprakash, Commented Sep 7, 2015 at 12:10

Shailesh Katarmal · Accepted Answer · 2015-09-07 12:08:47Z

19

 $sql = "UPDATE `product_list` SET 
       `product_name` = '$product_name', 
       `product_category` = '$product_category', 
       `product_price` = '$product_price', 
       `product_description` = '$product_description', 
       `product_size_category` = '$size_category' 
  where clause..... (if required) ";

answered Sep 7, 2015 at 12:08

Shailesh Katarmal

2,7931 gold badge15 silver badges16 bronze badges

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

Comments

Toretto · Accepted Answer · 2015-09-07 12:13:15Z

5

Try like this :

$sql = "UPDATE product_list SET product_name='".$product_name."',product_category='".$product_category."',product_price='".$product_price."',product_description='".$product_description."',size_category='".$size_category."' WHERE product_id=".$product_id;

Reference : https://dev.mysql.com/doc/refman/5.0/en/update.html

edited Sep 7, 2015 at 12:13

answered Sep 7, 2015 at 12:06

Toretto

4,7115 gold badges29 silver badges46 bronze badges

Comments

ata · Accepted Answer · 2019-10-11 17:56:11Z

4

Update SQL query, see following method:

Update database_tablename SET column_name1 = column_value1 , column_name2 = column_value2

$sql = "UPDATE product_list SET product_name='".$product_name."',product_category='".$product_category."',product_price='".$product_price."',product_description='".$product_description."',size_category='".$size_category."'";

edited Oct 11, 2019 at 17:56

ata

3,6935 gold badges22 silver badges32 bronze badges

answered Sep 7, 2015 at 12:46

Jakir Hossain

2,51720 silver badges24 bronze badges

1 Comment

Reeno Over a year ago

Please consider editing your post to add more explanation about what your code does and why it will solve the problem. An answer that mostly just contains code (even if it's working) usually won't help the OP to understand their problem.

KAD · Accepted Answer · 2015-09-07 12:07:50Z

2

You are mixing up query syntax between INSERT and UPDATE queries, the UPDATE syntax is ;

UPDATE TABLE SET col1 = val1, col2=val2... WHERE col1 = val

You shall use the UPDATE query as follows :

$sql = "UPDATE product_list SET product_name = '$product_name', 
product_category = '$product_category' WHERE product_id = $product_id";

answered Sep 7, 2015 at 12:07

KAD

11.2k4 gold badges34 silver badges75 bronze badges

Comments

Rifai · Accepted Answer · 2015-09-07 12:08:09Z

2

Your query must be something like this :

"UPDATE product_list 
set 
product_name='$product_name', 
product_category ='$product_category', 
product_price='$product_price',
product_description='$product_description',
product_size_category='$size_category'
where product_id='$product_id'
"

make sure you define the variable you need like $size_category etc, cause i didn't see it.
use conditions like where to update specific record

answered Sep 7, 2015 at 12:08

Rifai

19411 bronze badges

Collectives™ on Stack Overflow

How to update multiple columns in mysql using php

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related