×Ô¼º½â¾ö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¡£ Ö§³Öһϡ£
Ö§³Öһϣ¬ÐÅÏ¢·ÖÏí£¡ÔÞÒ»¸ö
È¥ÍøÉÏÕÒһϣ¬ÓÐÈ«Ì׵ݲװ¹¤¾ß£¬²»ÓÃÕâôÂé·³µÄ¡£
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
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:
......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......