PHP - How to update table using auto increment (value++) [duplicate]

Question

someone can tell me how to update the value from 0 to 1, 52 to 53 (value++) using php script? i want to search it on go*gle but i dunno the keyword to find it

You want a query to increment or you are looking for a PHP Script for incrementing the values? — VishalParkash
– VishalParkash, Commented Oct 19, 2016 at 11:34
why you just turn auto increment in the structure settings on? — Luca Jung
– Luca Jung, Commented Oct 19, 2016 at 11:35
Do you want to increase the id column? OR any other column? — masterFly
– masterFly, Commented Oct 19, 2016 at 11:36
i want to update 5_sangat_baik, 4_baik, 3_cukup, 4_buruk, 5_sangat_buruk, but depending on the user which script he/she want to access — Flix
– Flix, Commented Oct 19, 2016 at 11:48

Battle Mage · Accepted Answer · 2016-10-19 11:35:45Z

2

If you want to update one column, for example 5_sagnat_baik - just run the query:

UPDATE `question` SET `5_sagnat_baik` = `5_sagnat_baik` + 1

answered Oct 19, 2016 at 11:35

Battle Mage

3792 silver badges5 bronze badges

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

Comments

user6815451 · Accepted Answer · 2016-10-19 11:56:11Z

1

You may update your auto-increment column (known as 'id') using a "update" sql in your php script using something like:

'UPDATE table_name SET id=(id + 1), [column2]=[value2], ...'

OR with PHP computed values (here $current_value):

'UPDATE table_name SET id=' . $current_value + 1 ', [column2]=[value2], ...'

The SQL update request is explained here: http://www.w3schools.com/SQl/sql_update.asp (or here: https://mariadb.com/kb/en/mariadb/update/#syntax)

edited Oct 19, 2016 at 11:56

answered Oct 19, 2016 at 11:40

user6815451

311 silver badge5 bronze badges

2 Comments

Paper Over a year ago

Welcome to Stack Overflow, here we do not like W3schools links but otherwise, great answer. :)

user6815451 Over a year ago

@4796321 oh ok. Here is the SQL update reference then: mariadb.com/kb/en/mariadb/update/#syntax (I have edited the answer in consequence).

VishalParkash · Accepted Answer · 2016-10-19 12:48:00Z

1

"UPDATE table_name
 SET column_name = column_name+ 1
 WHERE condition";

Hope this help

edited Oct 19, 2016 at 12:48

answered Oct 19, 2016 at 11:36

VishalParkash

4864 silver badges16 bronze badges

1 Comment

Machavity Over a year ago

Please stop using mysql_ functions, as they have been removed from PHP

Collectives™ on Stack Overflow

PHP - How to update table using auto increment (value++) [duplicate]

3 Answers 3

Comments

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Linked

Related