php和mysql时间函数

// 设置PHP时区
date_default_timezone_set('Asia/Shanghai');

// 连接MySQL数据库时设置时区
$mysqli = new mysqli("localhost", "user", "password", "database");
$mysqli->query("SET time_zone = '+8:00'");

// 正确的格式化字符串
$date = date('Y-m-d H:i:s');
echo $date;

// 确保输入的字符串格式正确
$timestamp = strtotime('2023-10-01 12:00:00');
echo date('Y-m-d H:i:s', $timestamp);

<?php
// 设置PHP时区
date_default_timezone_set('Asia/Shanghai');

// 获取当前时间戳
$timestamp = time();
echo "当前时间戳: " . $timestamp . "\n";

// 格式化时间
$date = date('Y-m-d H:i:s', $timestamp);
echo "格式化时间: " . $date . "\n";

// 连接MySQL数据库
$mysqli = new mysqli("localhost", "user", "password", "database");
$mysqli->query("SET time_zone = '+8:00'");

// 查询当前时间
$result = $mysqli->query("SELECT NOW()");
$row = $result->fetch_assoc();
echo "MySQL当前时间: " . $row['NOW'] . "\n";
?>