如何在php-mysql上插入当前日期 - How can i insert current date on php mysql

How can i insert current date on php mysql

本文关键字：插入当前日期 php-mysql | 更新日期: 2023-09-27

我试图插入当前日期、间隔25天的到期日期和间隔20天的电子邮件飞行日期。但这些数据没有保存在数据库中。原因是什么？

这是我的代码

<?php
include_once 'dbconnect.php';
if(isset($_POST['btn-signup']))
{
    $reqnum = $_POST['reqnum'];
    $Mnumber = $_POST['Mnumber'];
    $email = $_POST['email'];
    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $emailErr = "Invalid email format";
    }
    $fname = $_POST['fname'];
    $address = $_POST['address'];
    $sitename = $_POST['sitename'];
    $payment = $_POST['payment'];
    $title = $_POST['title'];
    $descr = $_POST['descr'];
    $regdate = $_POST['reg_date'];
    $exp_date =$_POST['exp_date'];
    $emailflydate = $_POST['emailflydate'];
    //if()
    //{
    $new_fname= $_POST['sitename'];
    $xxx = mysql_query("SELECT sitename FROM gotest WHERE sitename = '$new_fname'")or die(mysql_error());
    $yyy = mysql_fetch_row($xxx);
    if(mysql_num_rows($xxx) > 0)
    {
        echo "<script type='text/javascript'>alert('gdrhh !')</script>";
    }
    else
    {
        $query = mysql_query("INSERT INTO gotest(Mnumber,email,fname,address,sitename,reqnum,payment,title,descr,reg_date,exp_date,emailflydate) VALUES('$Mnumber','$email','$fname','$address','$sitename','$reqnum','$payment','$title','$descr', CURDATE(), DATE_ADD(CURDATE(), INTERVAL 25 DAY ), DATE_ADD(CURDATE(), INTERVAL 20 DAY ))");
        $r = mysql_insert_id();

    }
}
?>

如果愿意，您可以随时插入NOW()或UTC_TIMESTAMP()。

试试看：-

<?php
include_once 'dbconnect.php';
if(isset($_POST['btn-signup']))
{
    $reqnum = $_POST['reqnum'];
    $Mnumber = $_POST['Mnumber'];
    $email = $_POST['email'];
    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $emailErr = "Invalid email format";
    }
    $fname = $_POST['fname'];
    $address = $_POST['address'];
    $sitename = $_POST['sitename'];
    $payment = $_POST['payment'];
    $title = $_POST['title'];
    $descr = $_POST['descr'];
    $regdate = $_POST['reg_date'];
    $exp_date =$_POST['exp_date'];
    $emailflydate = $_POST['emailflydate'];
    //if()
    //{
    $new_fname= $_POST['sitename'];
    $xxx = mysql_query("SELECT sitename FROM gotest WHERE sitename = '$new_fname'")or die(mysql_error());
    $yyy = mysql_fetch_row($xxx);
    if(mysql_num_rows($xxx) > 0)
    {
        echo "<script type='text/javascript'>alert('gdrhh !')</script>";
    }
    else
    {
        $query = mysql_query("INSERT INTO gotest(Mnumber,email,fname,address,sitename,reqnum,payment,title,descr,reg_date,exp_date,emailflydate) VALUES('$Mnumber','$email','$fname','$address','$sitename','$reqnum','$payment','$title','$descr', '".date('Y-m-d h:i:s')."', '".date('Y-m-d h:i:s')."', INTERVAL 25 DAY ), DATE_ADD(CURDATE(), INTERVAL 20 DAY ))");
        $r = mysql_insert_id();

    }
}
?>