In linux, the PHP file is automatically executed. I now have a php file (retrieve the address information in the record from the database, use google to find the longitude and latitude, and then update the database). This file has the database connection method, there are database update functions. Due to the limit on the number of google queries, the PHP file needs to be executed every 6 minutes. It is equivalent to entering the php address in the browser url address bar and refreshing it every 6 minutes. However, the browser method is very difficult and you need to always watch the linux system automatically execute the php file.
I now have a php file (retrieve the address information in the record from the database, and then use google to find the longitude and latitude, and then update the database). This file includes the method for connecting to the database and updating database functions.
Due to the limit on the number of google queries, the PHP file needs to be executed every 6 minutes.
It is equivalent to entering the php address in the browser url address bar and refreshing it every 6 minutes. However, the browser method is very difficult and requires constant watching.
Now you need to write a script to automatically execute the file.
------ Solution --------------------
Use the crontab command
------ Solution --------------------
Discussion
This operation is only executed at startup.
What about scheduled execution?
