php 5.3 Á¬½ÓmssqlÊý¾Ý¿â
×î½üÓиöС¶«Î÷Òª²é¿´mssqlÊý¾Ý¿âÊÇÓÃphpʵÏֵģ¬ÒÔǰÎÒÓÃphp5.2ʱ¸Ð¾õͦ¼òµ¥µÄËùÒÔÏëphp5.3Ò²Ó¦¸ÃºÜ¼òµ¥µÄ
ΪʲôҪÓÃphp5.3ÄØÒòΪÎÒÏëÓÃsqlite3.0µÄ°¡£¬ÒòΪphp5.2µÄ²»Ö§³Ösqlite3.0µÄ°¡£¬ËùÒÔÎÒÌØÒâÈ¥ÏÂÁË5.3ÁËÏÂÔØ»ØÀ´Á˲ŷ¢ÏÖ5.3ÀïûÓÐmssqlµÄdllÀ©Õ¹ÁË£¬ÓôÃÆ°¡£¬²»¹ÜÕâô¶àÏÈÓÃÆðÄÇsqlite3.0ÔÙ˵ÁË
sqlite3.0µÄ²¿·Ö³ÌÐò»ù±¾Ð´ÍêÁË£¬ÏÖÔÚÒª¿ªÊ¼Á¬½ÓmssqlÊý¾Ý¿âÁË£¬ÎÒÏëûÓÐmssqlÄǾÍÓÃodbc°É£¬¿¿Á¬odbcÒ²ÕÒ²»µ½°¡£¬Ö»ÓÐpdo_odbcµÄ£¬Ã»Óа취ÁËÄǾÍÓÃpdo_odbcÁË£¬ÔõôÁ¬½Ó»¹Ã»ÓÐÓùýÄØ£¬Ö±½Ó²éphpµÄÊֲᣬ¸ù¾ÝÊÖ²áÊǵÄʵÀýÁ¬½ÓһϷ¢ÏÖÓÐÎÊÌâ°¡
¾¹È»ËµÃ»ÓÐodbcÇý¶¯°¡£¬Ôõô»ØÊ°¡£¬¸ãÁËÒ»»áûÓÐÕûÃ÷°×£¬ËãÁËÖ±½ÓÓÃ΢Èí¶ÔphpÀ©Õ¹Á½¼ÒsqlserverµÄ°É£¬ÊÇSQLServerDriverForPHP11ÏÂÔØÁ˰²×°Ò»Ï£¬Æäʵ¾ÍÊÇ×Ô½âѹµÄѹËõ°ü°¡£¬¸ù¾Ý×Ô¼º¶ÔÓ¦µÄphp°æ±¾µÄsqlserverdriverµÄdll¿½±´µ½extĿ¼ÏÂÈ»ºóÔÚphp.iniÖмÓһϠextension=php_sqlsrv_53_nts_vc9.dll ¼ÓÔØÊ§°Ü£¬ÓôÃÆ°¡£¬ºóÀ´¿´ÁËÎÒµÄphp°æÊÇphp-5.3.2-Win32-VC9-x86.zip²»ÊÇnts£¨Õâ¸öºÃÏñÊÇ·ÇḬ̈߳²È«°É£©ÎҾͻ»Á˸öextension=php_sqlsrv_53_ts_vc9.dll ûÓб¨´íÁË£¬¿´À´Ó¦¸Ã¿ÉÒÔÁ˰ɣ¬¸ù¾ÝÕâÏÂÔØÇý¶¯Îĵµ¿´¿´ÔõôÁ¬½ÓÊý¾Ý¿âµÄ£¬ÀÏÊÇÏÔʾÁ¬½Ó³¬Ê±°¡£¬ÒòΪÊǶ˿ڸÄÁ˵ģ¬ËùÒÔÎÒÖ±½ÓÊÇÔÚipºóÃæ¼ÓÁËðºÅ¼Ó¶Ë¿Ú £¬È»ºóÓÃϵͳ×Ô´øµÄÊý¾ÝodbcÁ¬½ÓÊý¾Ý¿âÊÇ¿ÉÒԵİ¡£¬¿´À´ÓпÉÄܶ˿ڲ»ÊÇÕâÑù¼ÓµÄ°¡ £¬ÍøÉϲéÁ˺ÃÏñÊÇÓöººÅ·Ö¸ôµÄ°¡£¬¿´ÁËÊÔÊÔÁË¡£
ÓиøÎÒÌáʾûÓÐMicrosoft SQL Server 2008 Native ClientÇý¶¯ÁË£¬Ã»°ì·¨ÎҾͰ²×°°É£¬ÏÂÔØÁ˰²×°ÁË£¬ÔÚÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âûÓÐÏÔʾ´íÎóÁË£¬¿´ÁË»ù±¾Ã»ÓÐÎÊÌâÁË£¬ºÃÁË×ÜËã½â¾öÁË£¬¸ãµÄÎÒºÃÐÁ¿à°¡
Ïà¹ØÎĵµ£º
Sql2005ÖÐʹÓÃow_number() partition½øÐзÖ×éʵÑ飬
SQL£º
select * from stu
select id,row_number() over (partition by snm order by id) from stu
½á¹û£º
id snm
----------------
111 111V
111 111W
222 222N
333 3123
444 3123
555 3123
666 3232
777 3232
--·Ö×éºóµÄ½á¹û
id &n ......
ÏÖÔÚÊг¡ÉϵÄoa»ù±¾ÉϿɹé½áΪÁ½´óÕóÓª£¬¼´phpÕóÓªºÍjavaÕóÓª¡£µ«¶Ô½Ó´¥oa²»¾ÃµÄÓû§À´Ëµ£¬¿´µ½µÄÍùÍùÖ»ÊÇËüÃǵıíÏֻ࣬ÊÇÃ÷ÏԵļ۸ñ²îÒ죬ȴºÜÄÑ¿´³öËüÃÇÖ®¼äµÄʵ¼Ê²îÒì¡£Æäʵ£¬ PHP + MYSQL ²»ÖµÇ®²»½ö½ö¾ÖÏÞÓÚoaÈí¼þ£¬¶øÊÇÕûÌåÉÏPHP + MYSQL¿ª·¢µÄÈí¼þ¶¼²»Èçjava¿ª·¢µÄÈí¼þֵǮ¡£ÎªÊ²Ã´PHP + MYSQL µÄOAΪʲô²»ÖµÇ®Ä ......
ÏÖÔÚÓкܶàµÄrss¶©ÔÄ£¬ÎÒÃÇÖ±½Ó¿ÉÒÔ¶©Ôĵ½ÓÊÏä¡£¼ÈȻѧÁËPHP£¬ÄÇôÓÐûÓÐÒ»ÖÖ·½·¨¿ÉÒÔÖ±½Ó½«rssµÄÐÂÎÅÐÅÏ¢ÏÔʾÔÚ×Ô¼ºµÄÍøÒ³ÉÏÄØ£¿Óе쬱ØÐëµÄ£¬ÏÂÃæ¾ÍÊÇÕâ¸örss½Å±¾£º
<?php
//RSSÔ´µØÖ·ÁбíÊý×é
$rssfeed = array("http://blog.csdn.net/heavenopener/category/668064.aspx/rss");
for($i=0;$i<sizeof($rssfee ......
½ñÌìÓöµ½ÁËÒ»¸öºÜÆæ¹ÖµÄÂÒÂëÎÊÌ⣬×Ô¼ºÎÞÒâÖнâ¾öÁË£¬µ«²»ÖªµÀÊÇʲôÔÒò£¬Ö»ºÃ¼ÇÏÂÀ´£¬·ÀÖ¹ÒÔºóÔÙ³öÏÖÕâÑùµÄÎÊÌâ¡£
µ±ÎÒ°ÑphpÓï¾äдµ½ÏÂÃæµÄÒ³ÃæÍ·ÐÅϢ֮ǰµÄʱºò£¬ÕâЩphpÊä³öÓï¾ä¶¼Êä³öµÄÊÇÂÒÂ룬°üÀ¨ÓÃechoÊä³öµÄjs¡£È磺echo "<script languge=javascript> alert('Ìí¼Ó³É¹¦!');location.href = 'device_add.php ......
ÔÚÏîÄ¿¿ª·¢Öз¢ÏÖ¶ÔphpµÄÎĵµÈ±ÉÙ¹ÜÀí,±ðÈËдÁËÒ»¸ö,¹¦Äܲ»¶à
<?php
/**
* ˈ̞: doc
*
ÃèÊö: ÎĵµÉú³ÉÀà
* ÆäËû: ¿ÉÒÔ¶ÔĿ¼½øÐйýÂË,ÉèÖúÃԴĿ¼ºó,ÇëÓþø¶Ô·¾¶Ö¸¶¨Éú³ÉĿ¼,ģʽ¿Éµ÷,ģʽ
*
1Ϊ³£¹æÀàÐÍ,¼´ÒÔ Ð±Ïß**¿ªÍ·,ÒÔ*бÏß ½áÊø
* 2ΪÀ©Õ¹ÀàÐÍ,·²ÊÇ Ð±Ïß*¿ªÍ·ÒÔ*бÏß ½áÊøµÄ²¿·Ö¶¼½«³ÉΪÎÄ ......