<?php
$dbhost = '127.0.0.1'; // mysql服务器主机地址
$dbuser = '***'; // mysql用户名
$dbpass = '***'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysqli_error());
}
mysqli_query($conn , "set names utf8");
mysqli_select_db( $conn, '表名' );
ignore_user_abort();//关掉浏览器,PHP脚本也可以继续执行.
set_time_limit(3000);// 通过set_time_limit(0)可以让程序无限制的执行下去
$interval=60*60*24;// 每隔24小时运行
do{
$sql = 'SELECT * FROM cm_users WHERE type=2';
$retval = mysqli_query( $conn, $sql );
foreach ($retval as $key => $value) {
if($value['buy_end'] < time()){
$sqls = 'UPDATE cm_users SET type="3" WHERE id='.$value['id'];
$sqlss = 'UPDATE cm_token SET type="3" WHERE uid='.$value['id'];
$retvals = mysqli_query( $conn, $sqls );
$retvals = mysqli_query( $conn, $sqlss );
}
}
sleep($interval);// 等待5分钟
}
while(true);
《欢迎提问@记忆、QQ137090172》