01.
<?
02.
03.
mysql_connect(
"127.0.0.1"
,
"root"
,
"password"
);
04.
mysql_select_db(
"dddd"
);
05.
mysql_query(
"SET NAMES UTF8"
);
06.
07.
$x
=
"SELECT * FROM time order by id"
;
08.
$xx
= mysql_query(
$x
);
09.
$xa
= mysql_fetch_array(
$xx
);
10.
11.
date_default_timezone_set(
'Asia/Bangkok'
);
12.
$date
=
date
(
"d-m-Y H:i:s"
,
mktime
(
date
(
"H"
),
date
(
"i"
)+0,
date
(
"s"
)+0,
date
(
"m"
)+0 ,
date
(
"d"
)+0,
date
(
"Y"
)+0));
13.
14.
15.
16.
echo
$date
;
17.
echo
'<br>'
;
18.
echo
$xa
[time] ;
19.
20.
21.
?>
22.
23.
<?php
24.
25.
function
get_datetime_diff(
$datetime_start
,
$datetime_end
)
26.
{
27.
$seconds
=
strtotime
(
$datetime_end
) -
strtotime
(
$datetime_start
);
28.
29.
$days
=
floor
(
$seconds
/ 86400);
30.
$hours
=
floor
((
$seconds
- (
$days
* 86400)) / 3600);
31.
$minutes
=
floor
((
$seconds
- (
$days
* 86400) - (
$hours
* 3600))/60);
32.
$seconds
=
floor
((
$seconds
- (
$days
* 86400) - (
$hours
* 3600) - (
$minutes
*60)));
33.
34.
echo
$days
.
" วัน "
.
$hours
.
" ชั่วโมง "
.
$minutes
.
" นาที "
.
$seconds
.
" วินาที"
;
35.
}
36.
37.
38.
echo
'<br>'
;
39.
?>
40.
<?=get_datetime_diff(
$date
,
$xa
[time]); ?>