What script can be used to add different formula-calculated values ​​to an entire database column?

Question

PHP

There is a table:
id login password ferm apple
1 test1 123 1 0
2 test2 123 4 5
3 test3 123 5 15
It is necessary to make it so that after pressing the conditional button, the script would work, which would recalculate in the entire apple column and update the value according to the formula: apple= ferm*5+apple

Answer 1

php.net/manual/en/function.simplexml-load-string.php
php.net/manual/en/simplexmlelement.xpath.php

Answer 2

UPDATE [Есть таблица] SET apple= ferm*5+apple