php+mysql processing time

This article mainly introduces the processing time of php mysql, which has certain reference value. Now I share it with everyone. Friends in need can refer to it

Although mysql has its own time type, for For compatibility reasons, the time function is generally used in PHP to retrieve unixtimestamp. Save to database.
1.unix timestamp
The time function in PHP returns unix timestamp. By default, PHP parses and displays Greenwich Mean Time.
is the number of seconds since January 1, 1970 (midnight UTC/GMT).
2. Convert unix timestamp to human recognition date

$str = date(“Y-m-d H:i:s”, time())得出的是格林威治时间，非中国时间。加上8小时即可。
$str = date(“Y-m-d H:i:s”, time()+8*3600)

Convert unix timestamp to Chinese time:
3. Convert human recognition date to unix timestamp

$int = strtotime(“2014-11-8 08:12:24”);

4. Database type
Since the int range of mysql database is the same as the unix timestamp type, just crime int is enough. create time is represented by int. Some SQL files show crime int(11). The 11 in the brackets is the default display length of MySQL, not the length of the data size.
The default value of int in mysql is (-2 147 483 648, 2 147 483 647), and 10 bits can meet the needs.
5. Write the current time into the database

$n = time();
$query = "insert into time_test values( $n )";
$ret = mysql_query($query, $con);

6. Display the database time as China time

$query = "select ctime from time_test;";
$ret = mysql_query($query, $con);
if(!$ret)
{
die("query error: " . mysql_error());
}

while ( $arr = mysql_fetch_array($ret))
{
//数据库中取出的是字符串，为保险起见，转换为int类型。
echo date("Y-m-d H:i:s", intval($arr["ctime"]) + 8*3600) . "<br>";
}

dd3e47eb3f38eda43203ddc7cf6442d1

The above is the entire content of this article, thank you for reading.

Related recommendations:

php mysql implements login registration and password modification web page

php mysql jquery method to implement calendar sign-in function

The above is the detailed content of php+mysql processing time. For more information, please follow other related articles on the PHP Chinese website!