php - How database server can automatically update -

php - How database server can automatically update -

i making game , want this: every 30 minutes every player must gain coins (online players , offline players too!). there way database automatically update columns after 30 minutes , add together every player coins.

an alternative utilize cronjob - can create script (e.g. in php) on server create cronjob execute script every 30 minutes.

php mysql database server