phpÎÞ·¨²åÈëÊý¾Ýµ½mssql2005,µ«¿ÉÒÔÑ¡Ôñ£¬¾ÍÊÇinsertʱ£¬Ìáʾ³É¹¦£¬µ«±íÖÐûÓÐÊý¾Ý¡£ÏÔʾ±íÖеÄÊý¾ÝÕý³££¬ÊÇʲôÔÒò£¿ÇëÖªµÀµÄ˵һÏ£¬Ð»Ð»ÁË¡£
phpÎÞ·¨²åÈëÊý¾Ýµ½mssql2005,ºÍÊý¾Ý¿â·ÅÔÚÒ»Æð¾ÍûÓÐÎÊÌ⣬·Ö¿ª¾Í²»ÐУ¬·Ö¿ªÖ»ÄÜÑ¡Êý¾Ý¿â£¬²»ÄܲåÈëºÍ¸üС£
ÄãÊÇÈçºÎ×öµÄ£¿
ÎÞ·¨Àí½â£º
µ«±íÖÐûÓÐÊý¾Ý¡£ÏÔʾ±íÖеÄÊý¾ÝÕý³£
ºÍÊý¾Ý¿â·ÅÔÚÒ»Æð¾ÍûÓÐÎÊÌâ
·Ö¿ª¾Í²»ÐÐ
ºÜÓпÉÄÜÊÇ,µ±Ç°Á¬½ÓµÄÓû§,¶ÔÄã²Ù×÷µÄÊý¾Ý¿â,ûÓбíµÄinsertȨÏÞ,Ö»ÓÐselectµÄȨÏÞ.
ÎÒ˵ÁË£¬ÓÐȨÏÞ£¬ÓÃ.netдͬÑùµÄÓû§Ã»ÓÐÎÊÌâ
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
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:
......
ÕÐÆ¸Ö°Î»£ºÉè¼ÆÈËÔ±
ѧ Àú£º²»ÏÞ
Ö÷Òª¹¤×÷£ºÍøÒ³Éè¼Æ£¬Æ½ÃæÉè¼ÆµÈÉè¼ÆÀ๤×÷¡£
×îµÍÒªÇó£ºÖÁÉÙÓо«Í¨Ò»ÃÅÊìÁ·µÄÉè¼Æ¹¤¾ß£¬È磺PS¡¢AI¡¢FWµÈ¡£
н Ë®£ºÃæÒ飬ÊÔ¹¤×÷ÄÜÁ¦¶ø ......