ÔõÑù¼ÆËãphpÀïµÄʱ¼ä²î - PHP / »ù´¡±à³Ì
ÁôÑÔ時間: 2010-05-17 15:46:41
µê長»Ø¸²: 2010-05-19 08:03:37
¹²»¨費 1ÈÕ 16С時 17·Ö鐘 »Ø¸²
СµÜÏëÒª這楊µÄÒ»個Ч¹û ²»ÖªµÀÔõ麼實現 請¸ßÊÖÖ¸點Ò»ÏÂ
$date1 = "2010-05-17 15:46:41";
$date2 = "2010-05-19 08:03:37";
$diff = strtotime($date2) - strtotime($date1);
$day = $diff/(3600*24);
$hour = ($diff%(3600*24))/3600;
$m = (($diff%(3600*24))%3600)/60;
$sec = $diff%60;
´æÈëtimestamp¼´¿É
Â¥ÉϵÄÇ¿£¬ÕâÖÖ·½·¨È·ÊµºÜºÃ¡£
µ«ÊÇÈç¹ûʱ¼ä¼ä¸ôÔÚ1ÄêÒÔÉÏ£¬¾Í»á³öÏÖÎÊÌâÁË£¨Ëä˵һ°ã²»»á³öÏÖ1ÄêµÄʱ¼ä²îÕâÖÖÇé¿ö¹þ£©¡£
<?
function calculate_time_past($start_time, $end_time, $format = "s") {
$time_span = strtotime($end_time) - strtotime($start_time);
if ($format == "s") { // is default format so dynamically calculate date format
if ($time_span > 60) { $format = "i:s"; }
if ($time_span > 3600) { $format = "H:i:s"; }
}
return gmdate($format, $time_span);
}
$date1 = "2010-05-17 15:46:41";
$date2 = "2010-05-19 08:03:37";
echo calculate_time_past($date1, $date2, "d H:i:s");
?>
Ïà¹ØÎÊ´ð£º
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
ÏÖÓÐÒ»PHP¿Õ¼ä£¬Ö§³ÖMYSQLÊý¾Ý¿â
Ϊ½ÚÊ¡·ÑÓã¬ÏÖÏëͨ¹ýÓòÃûתÏòĿ¼ÐÎʽ½øÐйÜÀí£¨¼´½«ÓòÃûA¼Ç¼£Û°üÀ¨¶¥¼¶ÓòÃû¼°¶þ¼¶ÓòÃû£Ý¶¼Ö¸Ïòͬһ¿Õ¼ä£©
È磺·ÃÎÊÓòÃû abcd.cn Ö±½Ó·ÃÎÊÍøÕ¾¸ùĿ¼
·ÃÎʶþ¼¶ÓòÃû ef.abcd.cn ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......