|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /proc/22697/root/home/queenjbs/junsu/admin/ |
Upload File : |
<?include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";?>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?
/*
$query="select * from user_cash where flag='D' and enddate='2020-12-31'";
$result= mysql_query($query,$db_con);
$i=1;
while ($row=mysql_fetch_array($result)) {
echo $i.". ";
echo $querys = "update user_cash set enddate ='2019-12-31' where id = '$row[id]'";
echo "<br>";
$results = mysql_query($querys, $db_con);
$i++;
//update user_cash set enddate ='2019-12-31' where flag='D' and enddate='2020-12-31'
}*/
$query="select * from user where auth_code='10' and m_enddate='2020-12-31'";
$result= mysql_query($query,$db_con);
$i=1;
while ($row=mysql_fetch_array($result)) {
echo $i.". ";
echo $querys = "update user set m_enddate ='2019-12-31' where id = '$row[id]'";
echo "<br>";
//$results = mysql_query($querys, $db_con);
$i++;
}
//update user set m_enddate ='2019-12-31' where auth_code='10' and m_enddate='2020-12-31'
?>