Prompt, please, as when you press the button to change the value in the database ('users') from the user.
The user has logged on. Got your id. And with it your (game) by "Balance" which is 0. Then he presses the button. And now his account is "Balance: 1".
I was advised to do so:
Php-first get the column value, and then add the desired value to overwrite the result in the column.
$value1=$bd->query("SELECT `balance` FROM `table_name` WHERE `id`='userid'")->fetch_array(MYSQLI_ASSOC);
$value=$value1+$value2//value2 can be any value that you need to add
$bd->query("UPDATE `table_name` SET `balance`='".$value."' WHERE `id`='user_id'");
But something what day it is impossible to implement. Help, please.