获取当前时间/日期的时间戳 - Timestamp to get current time/date

Timestamp to get current time/date

本文关键字：日期时间戳时间获取 | 更新日期: 2023-09-27

我需要使用PHP的简单代码来使用TIMESTAMP获取当前日期/时间并将其插入数据库。

我有一个名为"ArrivalTime"的字段在一个数据库作为TIMESTAMP。

编辑:

<?php
$con = mysql_connect("localhost","root","") or die('Could not connect: ' . mysql_error());
mysql_select_db("a&e", $con) or die('Could not select database.');

//验证

$time = time(); $date = date('Y-m-d H:i:s',$time);
$sql="INSERT INTO Patient(Forename, Surname, Gender, Date_Of_Birth, Address,    Patient_History, Illness, Priority, Arrival_Time)
VALUES('$patient_name', '$patient_lastname', '$gender', '$date', '$address', '$history', '$illness', '$priority', '$time')";
mysql_query($sql,$con) or die('Error: ' . mysql_error());
echo "1 record added";
// close connection 
mysql_close($con);
?>

Many thanks

main.php

<?php
    require('connect.php');
    $time = time();

    $sql = "INSERT INTO yourtablename (ArrivalTime) Values ('$time')";
    mysql_query($sql);
    ?>

p。S:在sql语句中，我相信你需要把其他的东西放在其他字段，所以你只需要替换上面的一个:

$sql = "INSERT INTO yourtablename (field1, field2, ArrivalTime) Values ('$value1','$value2','$time')";

connect.php

<?php
$error = "Couldn't connect";
$connect = mysql_connect("localhost","username","password") or die($error);
mysql_select_db("yourdatabase") or die($error);
?>

查询将为:

 INSERT INTO mytable(ArrivalTime) VALUES(UNIX_TIMESTAMP())

mysql有一个函数UNIX_TIMESTAMP()用于获取Unix时间戳作为无符号整数。

的例子:

mysql> SELECT UNIX_TIMESTAMP()-> 1196440210

所以你可以使用这个sql查询:

insert into tableName(ArrivalTime) values(UNIX_TIMESTAMP())