Get Updated Value in MySQL instead of affected rows

by

You can do it with a stored procedure that updates, and then selects the new value into an output parameter.
The following returns one column new_score with the new value.

DELIMITER $$   -- Change DELIMITER in order to use ; withn the procedure
CREATE PROCEDURE increment_score
(
   IN id_in INT
)
BEGIN
    UPDATE item SET score = score + 1 WHERE id = id_in;
    SELECT score AS new_score FROM item WHERE id = id_in;
END
$$            -- Finish CREATE PROCEDURE statement
DELIMITER ;   -- Reset DELIMITER to standard ;

In PHP:

$result = mysql_query("CALL increment_score($id)");
$row = mysql_fetch_array($result);
echo $row['new_score'];

More Related Contents:

  1. How to find missing attendance from the database table
  2. Php mysql tabs don’t output [closed]
  3. Update Mysql except when field not null
  4. How can I prevent SQL injection in PHP?
  5. PDO get the last ID inserted
  6. How do I use password hashing with PDO to make my code more secure? [closed]
  7. MySQLi prepared statements error reporting [duplicate]
  8. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  9. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  10. How do I import a .sql file in mysql database using PHP?
  11. Laravel-5 ‘LIKE’ equivalent (Eloquent)
  12. PHP Fatal error: Class ‘PDO’ not found
  13. Connect to a MySQL server over SSH in PHP
  14. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  15. PHP Warning: mysqli_connect(): (HY000/2002): Connection refused
  16. Selecting a float in MySQL
  17. mysql query result in php variable
  18. while ($row = mysql_fetch_array($result)) – how many loops are being performed?
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. How do detect that transaction has already been started?
  21. How to get primary key of table?
  22. Simple way to read single record from MySQL
  23. How to insert json array into mysql database
  24. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. Create PHP array from MySQL column
  27. UNION syntax in Cakephp
  28. How do I format numbers to have only two decimal places?
  29. Group mysql results by category and display them into groups under each category
  30. PHP & mySQL: When exactly to use htmlentities?

Leave a Comment