每个星期一我都需要清空 MYSQL 数据库的几个字段。
首先我考虑使用 cron 作业，但我的虚拟主机提供商 (fatcow.com) 既不支持 SSH 也不支持通过命令行进入共享服务器。
我还考虑过检查 date() 以查看是否是星期一并执行某些操作，但随后我需要连续运行该特定页面，并且我了解到这是一个问题。
所以现在我问你，我该怎么做？
感谢您的解答
every Monday I need to empty few fields of a MYSQL database I have
Firstly I thought about using a cron job, but my Web Hosting provider (fatcow.com) doesn't support neither SSH or Command Lines into shared servers.
I've also thought about checking the date() to see if it's monday and perform something, but then I need to run that specific page continuously and I've read that it's a problem.
So now I ask you, how can I do this ?
Thanks for answers
发布评论
评论（6）
如果您有权访问任何其他允许运行 cron 作业的服务器，您可以在那里创建一个 php 文件并运行要从该服务器执行的 url。使用curl、wget 或streams 来执行此操作。
If you have access to any other server that will allow to run cron job, you can create a php file there and run your url to be executed from that server. Use curl, wget or streams to do this.
如果您有权访问任何其他允许 cron 的服务器（因为 FatCow 不允许），您可以创建一个 cron 作业，在您的服务器上的 php 脚本上调用 wget - 例如 wget http://example.com/fake-cron.php
If you have access to any other servers that do allow cron, since FatCow doesn't, you could make a cron job that calls wget on a php script on your server -- eg wget http://example.com/fake-cron.php
如果您的工作可以通过 URL 到达，您可以尝试注册免费的 crontab 服务，例如 onlinecronjobs.com
If your job can reached via a URL, you might try to sign up with a free crontab service like onlinecronjobs.com
应该可以在 mysql 本身中设置某种作业。不是 100% 确定，但是阅读一下
也许你会找到一种从 MySQL 而不是 PHP 来做到这一点的方法。抱歉，我无法提供更多帮助，只是认为您可能想查看一下
MySQL 事件
Should be possible to setup some kind of job in mysql itself. Not 100% sure about it, but read up on
And maybe you find a way to do it from MySQL instead of PHP. Sorry I can't be of more help, just thought you'd might want to check it out
MySQL Events
如果您可以访问另一台服务器（使用 ssh），只需在其上添加一个 cron 作业，每周运行一次您的 php 脚本。
不幸的是，我认为没有办法直接在你的 php 脚本上做到这一点。
If you have access to another server (with ssh) just add a cron job on it that hit your php script once a week.
Unfortunately i don't think there is a way to do it directly on your php script.
该主机的控制面板是什么？面板？如果是这样，cPanel 几乎总是在 Advanced 下有一个 Cron 工具。也可能执行 exec 或 system 来自 php 脚本的命令来设置 Cronjob（除非这就是您不支持“命令行”的意思） 。
What's the control panel for that host? cPanel? If so, cPanel almost always has a Cron tool under Advanced. Could also potentially do an exec or system command from a php script to set up the Cronjob (unless that's what you mean by not supporting 'command lines').