使用php在mysql中保存日期时间

$datetime = date('Y-m-d H:i:s');

CREATE TABLE example (
    id INT PRIMARY KEY AUTO_INCREMENT,
    datetime DATETIME
);

// 使用mysqli扩展
$conn = new mysqli('localhost', 'username', 'password', 'database');
$stmt = $conn->prepare('INSERT INTO example (datetime) VALUES (?)');
$stmt->bind_param('s', $datetime);
$stmt->execute();

// 使用PDO扩展
$conn = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');
$stmt = $conn->prepare('INSERT INTO example (datetime) VALUES (:datetime)');
$stmt->bindParam(':datetime', $datetime);
$stmt->execute();

$stmt = $conn->prepare('SELECT datetime FROM example WHERE id = ?');
$stmt->bind_param('i', $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$datetime = strtotime($row['datetime']);