|
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" />
<?
$todayfull = date("YmdHis");
$contents = addslashes($contents); //특수문자db에 들어가게..
$reply_content = addslashes($reply_content); //특수문자db에 들어가게..
$query="SELECT *
FROM user_cash
WHERE flag = 'D'
AND startdate = '2020-01-01'
AND inning = '2'";
$result= mysql_query($query,$db_con);
$i=1;
while ($row=mysql_fetch_array($result)) {
$m_startdate = "2020-02-01";
$m_enddate = "2021-01-31";
//echo $i.". $row[userid]: ".$row[startdate]."~".$m_startdate;
echo $qryss = "update user_cash set startdate='$m_startdate',enddate='$m_enddate' where id = '$row[id]'";
//$qryss_result = mysql_query($qryss,$db_con);
echo "<br>";
echo $qry = "update user set m_startdate='$m_startdate', m_enddate='$m_enddate' where id = '$row[user_id]'";
//$qry_result = mysql_query($qry,$db_con);
echo "<br>";
$i++;
}
echo("END");
?>