php¼ÆËãÁ½ÌìÈÕÆÚ²îʱ°üÀ¨ÌìÊýСʱ·ÖÊý
php¼ÆËãÁ½ÌìÈÕÆÚ²îʱ°üÀ¨ÌìÊýСʱ·ÖÊý
±ÈÈ磨2009-12-30 10:45 ºÍ 2009-12-01- 11:45£©Ïà²î¶àÉÙʱ¼ä°üÀ¨ÌìÊýСʱ·ÖÊý
datediff(),¾ßÌå²ÎÊý²»ÔÚÕâÀïºÍÄã½²,ÄãÉÔ¶¯ÏÂÊÖËÑË÷ϾͻáºÜÇå³þÁË!
Çë¾ÙÀý˵Ã÷£¬Ð»ÁË
Ïë͵¸öÀÁÒ²²»Ðа¡,ÔÎ~~~
//2009-11-30 10:45 ºÍ 2009-12-30 10:45
//MYSQL DATADIFF()
$day=datediff("2009-11-30 10:45","2009-12-30 10:45"); //·µ»ØÌìÊý
echo $day;
$Date_1="2009-12-30 10:45";
$Date_2="2009-12-01 11:45";
$d1=strtotime($Date_1);
$d2=strtotime($Date_2);
date("Y-m-d H:i:s",$d1-$d2);
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÔÚmySqlÖÐÓÐÒ»×ֶοɴæhtml±êÇ©£¬±ÈÈç˵ÀïÃæÓÐa±êÇ©
µ«ÊÇÎÒÊäÈë²éѯÌõ¼þaµÄʱºò²¢²»Ïë²é³öÕâÌõ¼Ç¼£¬Ò²¾ÍÊÇ˵²éѯµÄʱºò²»¿¼ÂDZêÇ©,Ö»¿¼ÂÇÄÚÈÝ¡£
ÇëÎÊ´ó¼ÒÔõÑù½â¾ö£¿
¿ÉÒÔÔÙŪһ¸ö×Ö¶ÎÀ´±£´æ¹ýÂ˱êÇ©ºóµÄÄÚÈÝ¡£ ......
ÇëÎÊÈçºÎÓÃphp¸øÊÖ»úÓû§·¢ËͶÌÐŰ¡¡£
¾ßÌåÈçÏ£º
1.Èç¹û¿ÉÒÔ·¢£¬ÊÇͨ¹ýAPI»¹ÊÇ˵ÎÒÃÇ·¢Óʼþ¸ø´úÀíÉÌ£¬ÈôúÀíḚ́ïÎÒÃÇ·¢¶ÌÐÅ£¿
2.Èç¹ûÊÇͨ¹ý´úÀíÉÌÀ´·¢£¬ÄÇôÊÇÔõôÊշѵİ¡£¿ÊÇÒ» ......
PHP code:
$date = '2009-12-25';
$ptn = '/([\d]{4})[- \/](0?[\d]|1[0-2])[-\/ ](0?[\d]|[1-2][\d]|3[0-1])/';
if (preg_match($ptn,$date,$out))
{
print_r($out);exit();
}
½á¹ûΪ:
PHP code:
......