Conversion code for php timestamp and normal time display_PHP tutorial

lie74火96网(LieHuo03.Net) teaches 23 Cheng in web development, we The time when a form is submitted is often converted into a 10-digit timestamp format, which stumps some students when calling it. So how to call and convert it?

Answer: For example, the variable you call is $liehuo_times, then the statement output in php is: , how about, Simple right?

The time stored in mysql is a timestamp, 10 digits
How can I use a function to convert it into a normal time function output?

time();
is to get the current time, but it is an integer type

You can format this
date("Y-m-d H:i:s" , time());
This way the hours, minutes and seconds are displayed together
date("Y-m-d ", time()); Only the year, month and day are displayed

echo "The time zone of this machine:".date("T")."
";
echo "PHP timestamp (UNIX seconds):".mktime()."
";
echo "PHP time (after local formatting):".date("Y-m-d H:i:s")."

---

";
?>


There are two points for large HP time One is the timestamp type (1228348800), the other is the normal date format (2008-12-4)

So there are two forms of saving to the database (there are really more than two, my application only has two), I save the timestamp type as a string, which is more convenient.

Normal date type is saved as DATE type.

You should pay attention to these two, I usually use two So, the table I built a few days ago saved the time type as DATE. I kept using timestamp to save it, but the data could not be written into the table. After debugging for a long time, I found out what the error was. The type did not match. Write to the library.

A timestamp like the one above is more convenient, but when displaying it, don’t show this 1228348800 string to the customer, GOD NOWS!

So I use it For the conversion of these two, let's first talk about how to get the current timestamp, $date1=time(); in this way, the current timestamp is obtained. If you want to convert it back to the format of 2008-12-4, use date() This function is used. The date() function is commonly used in PHP. To obtain the current date, you can use $date2=date('Y-m-d');. Regarding the meaning of the parameters inside, if you don’t understand, just check the PHP manual. .

Okay, back to the topic, convert 1228348800 to 2008-12-4 format code as follows:

$date3=date('Y-m-d H:i:s',"1228348800");

This is OK. If you still want to get hours, minutes and seconds, just change 'Y-m-d'. However, please note that PHP time still seems to have an error of 8 hours. Add it OK.

The timestamp has been converted to a normal date. On the contrary, to convert the normal date format to a timestamp, please see the following code:

$year=((int)substr( "2008-12-04",0,4));//Obtained year

$month=((int)substr("2008-12-04",5,2));//Obtained Month

$day=((int)substr("2008-12-04",8,2));//Get the day number

echo mktime(0,0,0, $month,$day,$year);

This way you can convert the normal date into a timestamp. The same is true if there are minutes and seconds here.

Note: PHP5.1 or above time The stamp will be 8 hours different from the actual time. The solution is as follows
1. The simplest way is not to use php5.1 or above - obviously this is not an advisable method! ! !

2. Modify php.ini. Open php.ini and search for date.timezone. Remove the semicolon = in front and add Asia/Shanghai at the end. Just restart the apache server. The disadvantage is that if the program
is placed on someone else's server, you cannot modify php.ini. So what can you do? Incredible.

3. Add a time initialization statement in the program, namely: "date_default_timezone_set("Asia/Shanghai");" This can be set arbitrarily by the programmer, which I recommend.
Time zone identifier, available values ​​in mainland China are: PRC, Asia/Chongqing, Asia/Shanghai, Asia/Urumqi (in order China, Chongqing, Shanghai, Urumqi), Etc/GMT-8, Asia/Harbin
Available in Hong Kong and Taiwan: Asia/Macao, Asia/Hong_Kong, Asia/Taipei (in order, Macau, Hong Kong, Taipei)
and Singapore: Asia/Singapore