php如何把date更新到数据库

1. 使用mysqli_query()函数执行一个UPDATE语句，其中包含要更新的日期值：

$date = date('Y-m-d')

$sql = "UPDATE table_name SET date_column = '$date' WHERE id = 1"

mysqli_query($conn, $sql)

2. 使用PDO类的prepare()方法和execute()方法，其中包含要更新的日期值：

$date = date('Y-m-d')

$stmt = $conn->prepare("UPDATE table_name SET date_column = :date WHERE id = 1")

$stmt->execute(array(':date' =>$date))

//连接、查询

try {

$dbh = new PDO('mysql:host=localhostdbname=test', $user, $pass)

foreach($dbh->query('SELECT * from FOO') as $row) {

print_r($row)

}

$dbh = null//释放资源

} catch (PDOException $e) {

print "错误!: " . $e->getMessage() . "<br></br>"

die()

}

//执行删除 *** 作，插入、修改与此类似，更改SQL语句即可

$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'")

---