php - 使用准备好的语句在 MySql 中插入 (DATE(now))

Question

我想使用准备好的语句（PHP）将当前日期插入数据库。这是我目前正在使用的代码

<?php
     if(isset($_POST['confirm'])){
      $user_id = $_SESSION['user_id'];
      $user_name = $_SESSION['customer_name'];
      $user_email = $_SESSION['customer_email'];
      $get_text1 = $_POST['title'];
      $sql = $con->prepare("INSERT into free_ad(user_id, user_name, user_email,title,timenow) values 
     (?,?,?,?,(DATE(now)))");
      $sql->bind_param("isss",$user_id,$user_name,$user_email,$get_text1);
      $sql->execute(); 
 }
?>

标签： phpmysql

Answer 1

您可以尝试以下方法。而不是在 SQL 中绑定使用NOW()来获取当前日期。

   <?php
     if(isset($_POST['confirm'])){
      $user_id = $_SESSION['user_id'];
      $user_name = $_SESSION['customer_name'];
      $user_email = $_SESSION['customer_email'];
      $get_text1 = $_POST['title'];
      $sql = $con->prepare("INSERT into free_ad(user_id, user_name, user_email,title,timenow) values 
     (?,?,?,?,NOW())");
      $sql->bind_param("isss",$user_id,$user_name,$user_email,$get_text1);
      $sql->execute(); 
 }