×Ô¼º½â¾öPHPÁ¬½ÓSQL SERVERµÄ°ì·¨
ÊÔÁ˺ܶàÍøÉϵķ½·¨£¬ÒÀ¾É²»ÄÜÁ¬ÉÏ£¬ËùÒÔÎÒ×Ô¼ºÑ¡ÓÃODBCÁ¬½Ómssql£¬³É¹¦£¬¼òµ¥¡£
·ÖÏíһϡ£
$server = "localhost";
$name="sa";
$ps="admin";
$database="ICD_DB_BILL";
$constr = "Driver={SQL SERVER};server=$server;Database=$database";
$conn= odbc_connect($constr,$name,$ps,SQL_CUR_USE_ODBC);
¸øÄã·¢ÕźÃÈË¿¨ ¶¥
ÓÃpdo°É
¸÷ÖÖ·½·¨¶¼ÊÔÊÔ¡£¡£
²»¹ýÄãÕâÑù×ö½«¶ªÊ§ºÜ¶¼Êý¾Ý¿âÌØÓй¦ÄÜ
Ö÷ÒªÊÇ×Ô¼ºÊÔÁ˺ܾö¼Ã»³É¹¦£¬ÏàÐźܶàÐÖµÜÒ²¶¼ÓÐÕâÑùµÄÇé¿ö£¬Ç¡ºÃÓÖ׿±½øÐÐÏîÄ¿£¬ÎÒÌù³öÀ´Ö÷ÒªÊÇΪÁËÈôó¼ÒÄܶàÒ»ÖÖÑ¡Ôñ¶øÒÑ£¬ºÇºÇ
ÎÒÏÖÔÚ»¹ÔÚÏë·½Éè·¨Á¬MSÄØ
ODBC¡£ Ö§³Öһϡ£
Ö§³Öһϣ¬ÐÅÏ¢·ÖÏí£¡ÔÞÒ»¸ö
È¥ÍøÉÏÕÒһϣ¬ÓÐÈ«Ì׵ݲװ¹¤¾ß£¬²»ÓÃÕâôÂé·³µÄ¡£
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
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:
......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......