嗨，我有这个问题，我已经尝试了所有的解决方案，我可以找到DATE_ADD和更多这样的东西。这是我的代码。
$create_time = date("Y-m-d H:i:s");
if (md5($_POST['norobot']) == $_SESSION['randomnr2'])
{
if ((strlen($usern) >= 5) && (strlen($pass) >= 5)&&(strlen($email) >= 12)&&(strlen($idcard)==7))
{
$usr = mysql_query("Select * from account.account where login='$usern'");
$ema = mysql_query("Select * from account.account where email='$email'");
if ((mysql_num_rows($usr)==1)|| (mysql_num_rows($ema)==1))
{
echo error("Cont sau email utilizate.Incercati altele sau click <a href='index.php?page=recuperare-pw'>aici</a> pentru recuperare parola.");
}
else
{
if ($_POST['read'] == "checked")
{
$rand = rand(99999,9999999999);
$cod_activ = md5($rand);
//$cod_activ= "1";
mysql_query("Insert into account.account (Login,Password,Real_name,Social_id,Email,status,create_time,gold_expire,silver_expire,safebox_expire,autoloot_expire,fish_mind_expire,marriage_fast_expire,money_drop_rate_expire,coins,web_aktiviert) values('$usern',password('$pass'),'$name','$idcard','$email','OK','$create_time','2022-12-31 12:00:00','2022-12-31 12:00:00','2022-12-31 12:00:00','2022-12-31 12:00:00','2022-12-31 12:00:00','2022-12-31 12:00:00','2022-12-31 12:00:00','0','$cod_activ')") or die(mysql_error());
echo succes('Cont creat cu succes.Va puteti loga acum!');
代替2022-12-31 12:00:00，我想添加当前日期+ 30天，请帮助吗?
MySQL DATE_ADD将工作
SELECT DATE_ADD(CURDATE(),INTERVAL 30 DAY)
你的查询应该是:
mysql_query("Insert into account.account (Login,Password,Real_name,Social_id,Email,status,create_time,gold_expire,silver_expire,safebox_expire,autoloot_expire,fish_mind_expire,marriage_fast_expire,money_drop_rate_expire,coins,web_aktiviert) values('$usern',password('$pass'),'$name','$idcard','$email','OK','$create_time',DATE_ADD(CURDATE(),INTERVAL 30 DAY),DATE_ADD(CURDATE(),INTERVAL 30 DAY),DATE_ADD(CURDATE(),INTERVAL 30 DAY),DATE_ADD(CURDATE(),INTERVAL 30 DAY),DATE_ADD(CURDATE(),INTERVAL 30 DAY),DATE_ADD(CURDATE(),INTERVAL 30 DAY),DATE_ADD(CURDATE(),INTERVAL 30 DAY),'0','$cod_activ')") or die(mysql_error());
注意:mysql_*函数已被弃用，并将在未来的版本中删除，使用mysqli或PDO代替
如果需要日期时间，请使用CURRENT_TiMESTAMP而不是CURDATE()。
SELECT DATE_ADD(CURRENT_TIMESTAMP,INTERVAL 30 DAY)