01.
<?php
02.
include
"connect.php"
;
03.
function
duration(
$begin
,
$end
){
04.
$remain
=
intval
(
strtotime
(
$end
)-
strtotime
(
$begin
));
05.
$wan
=
floor
(
$remain
/86400);
06.
$l_wan
=
$remain
%86400;
07.
$hour
=
floor
(
$l_wan
/3600);
08.
$l_hour
=
$l_wan
%3600;
09.
$minute
=
floor
(
$l_hour
/60);
10.
$second
=
$l_hour
%60;
11.
return
"ผ่านมาแล้ว "
.
$wan
.
" วัน "
.
$hour
.
" ชั่วโมง "
.
$minute
.
" นาที "
.
$second
.
" วินาที"
;
12.
}
13.
$today
=
date
(
"Y-m-d ,H:i:s"
);
14.
$sql
=
"select * from cusorder where Status_member='No'ORDER BY Status_member='No'"
;
15.
$result
=mysql_query(
$sql
)
or
die
(
"erro=$sql"
);
16.
while
(
$row
=mysql_fetch_array(
$result
)){
17.
echo
(duration (
"$row[Date]"
,
"$today"
)).
"<br>"
;
18.
}
19.
?>