<?php 
   if(isset($_POST['updateData']))
    {
            $id = mysqli_real_escape_string($conn, $_POST['update_bil']);
            error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
            $myDate = mysqli_real_escape_string($conn, $_POST['myDate']);
            $subject = mysqli_real_escape_string($conn, $_POST['subject']);
            $announcement = mysqli_real_escape_string($conn, $_POST['announcement']);

            $sql = "UPDATE announcement SET myDate='$myDate(CURDATE())', subject='$subject', announcement='$announcement' WHERE id=$id";
            $results = mysqli_query($conn, $sql) or die(mysql_error());


            if($results)
            {
                 echo '<script> alert("Data Updated"); </script>';
                    header('Location:announcement.php'); //redirect to announcement page
            }
            else
            {
                echo '<script> alert("Data Not Updated"); </script>';
            }

        }
?>

我想使用curdate（）更新日期。 它的更新除了mydate。 因此，这是我的代码的输出:UPDATE announcement SET mydate='(CURDATE())'，