How to add same value with help of update query using PHP?

Question

I have records on my table and I have to update the records.if records are available then add the same value which is already in a database.

For example: I have column name aMan and value is 30 so I have to update same value and new values will be 60.

//Total column value=column value + column value 

if ($check_record >0) { 
    // will check the records available or not
    $sql="UPDATE man SET aMan = '$action_points' where user_id='$id'";
} else {
    $new=$column_value + $column_value;
    $sql="UPDATE man SET aMan = '$new' where user_id='$id'";
}

In short I have to add the value.Would you help me in this?

Yury Fedorov · Accepted Answer · 2017-01-02 12:28:15Z

1

The following will double the aMan value:

$sql = "UPDATE man SET aMan=aMan*2 WHERE user_id='$id'";

If you only need to add a specific value and not the same value as the column already has, use:

$sql = "UPDATE man SET aMan=aMan+30 WHERE user_id='$id'";

If you need to update multiple columns at the same time, use something like this:

$sql = "UPDATE man SET aMan=aMan+30, bMan=bMan+20 WHERE user_id='$id'";

Also, I suggest you to use prepared statements with mysqli or PDO instead of adding an $id variable diretly into your query string, which is very unsafe.

edited Jan 2, 2017 at 12:28

answered Jan 2, 2017 at 12:09

Yury Fedorov

15k6 gold badges56 silver badges70 bronze badges

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

7 Comments

Naren Verma Over a year ago

Thanks for replying Mr.Yury, In case i have to update every time 30 than what qyery i have to use it?

Naren Verma Over a year ago

Where should I use that query inside if or else?

Yury Fedorov Over a year ago

Inside your else statement, instead of both lines

Naren Verma Over a year ago

Mr.Yury, I have one more doubt.In case there are more than on column then what will be update query i have to use it?

Naren Verma Over a year ago

I don't know Mr.Yury, I am getting lots of doubt now.

|

Manoj Sharma · Accepted Answer · 2017-01-02 12:10:53Z

0

This can be a another approach.

$sql="UPDATE man SET aMan = aMan + aMan where user_id='$id'";

answered Jan 2, 2017 at 12:10

Manoj Sharma

1,4552 gold badges13 silver badges20 bronze badges

Collectives™ on Stack Overflow

How to add same value with help of update query using PHP?

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related