Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

×Ô¼º½â¾ö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¡£ Ö§³Öһϡ£

Ö§³Öһϣ¬ÐÅÏ¢·ÖÏí£¡ÔÞÒ»¸ö

È¥ÍøÉÏÕÒһϣ¬ÓÐÈ«Ì׵ݲװ¹¤¾ß£¬²»ÓÃÕâôÂé·³µÄ¡£


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

phpʱ¼äÕýÔòÎÊÌâ - PHP / »ù´¡±à³Ì

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:
......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

Çó½ÌPHPÖÐstr_replaceº¯ÊýÎÊÌâ - PHP / »ù´¡±à³Ì

ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ