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]); ?>
