Increment value in MySQL update query

by

Simply increment the value that already exists in the database

$sql = "UPDATE member_profile SET points = points + 1 WHERE user_id = ?";
$db->prepare($sql)->execute([$userid]);

This code would work for both PDO and mysqli in the modern PHP versions

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Using PHP data in MySQL [closed]
  4. Save the data into a database and return another value from database using PHP
  5. Checking the availability of rooms
  6. How can I do ‘insert if not exists’ in MySQL?
  7. How to properly set up a PDO connection
  8. Getting raw SQL query string from PDO prepared statements
  9. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  10. MySQL Prepared statements with a variable size variable list
  11. Loading .sql files from within PHP
  12. PDO with INSERT INTO through prepared statements [closed]
  13. PHP MYSQL UPDATE if Exist or INSERT if not?
  14. MySQL “NOT IN” query 3 tables
  15. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  16. Doing a while / loop to get 10 random results
  17. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  18. MYSQL Select from tables based on multiple rows
  19. How to execute raw queries with Laravel 5.1?
  20. Simple PHP SQL login troubleshooting
  21. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  22. MySql PHP select count of distinct values from comma separated data (tags)
  23. Laravel Eloquent get results grouped by days
  24. How to check if a value already exists to avoid duplicates?
  25. SELECT row by DATEPART()
  26. UNION syntax in Cakephp
  27. MYSQL select a piece of a string and order by that piece
  28. How do i search from serialize field in mysql database?
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment