在phpMyAdmin 3.3.8.1中计划php脚本 [英] Scheduling php script in phpMyAdmin 3.3.8.1

问题描述

我需要计划要在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脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！