问题描述
我需要计划要在phpmyadmin中运行的以下php脚本.我正在使用cron运行它，但它没有更新表.它也没有给我一个错误，所以我确定我的php文件有问题.这是代码.
I have the following php script that I need to schedule to run in phpmyadmin. I am using a cron to run it but its not updating the table. It is not giving me an error either so I am sure something is wrong with my php file. Here is the code.
<?php
mysql_connect("xxxx", "xxxx", "xxxx") or die(mysql_error());
mysql_select_db("xxxx") or die(mysql_error());
$query = "update events
INNER JOIN tblfeatureddj
ON events.id_user = tblfeatureddj.id_user
set trending ='2'";
?>
推荐答案
您确实可以在phpMyAdmin中安排事件(当然，前提是您具有适当的权限).在数据库中，单击事件"选项卡.从那里，您可以添加一个新事件(如果计划程序已关闭，则打开事件计划程序状态"按钮).像这样的事情应该对您很好:
You can indeed schedule events from within phpMyAdmin (provided you have the proper permissions, of course). From within your database, click the Events tab. From there, you can add a new event (and turn on the "Event scheduler status" button, if the scheduler is turned off). Something like this should do nicely for you:
这篇关于在phpMyAdmin 3.3.8.1中计划php脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！