PHPһЩÓÐÒâ˼µÄÐ¡Çø±ð
µ¥ÒýºÅ'ºÍË«ÒýºÅ"µÄÇø±ð£º
Ê×ÏÈÊǵ¥ÒýºÅÒª±ÈË«ÒýºÅÖ´ÐÐЧÂÊÒª¸ß£¬ÒòΪ˫ÒýºÅ»á¶ÔÄÚÈݽøÐÐÔ¤´¦Àí¡£
ÀýÈ磺'$value' Êä³ö×Ö·û $value ; "$value"Êä³ö±äÁ¿$valueµÄÖµ¡£
charºÍvarcharµÄÇø±ð£º
charÊǶ¨³¤¶øvarcharÊDZ䳤£¬charµÄÖ÷ÒªÌØµãÊÇ´æ´¢·½Ê½Ô¤·ÖÅ䣬varcharµ±ËüµÄÊý¾Ý³¤¶È·¢Éú±ä»¯Ê±»áÓ°ÏìÆä´æ´¢µÄÒ³·ÖÅä¡£
charÓëvarchar2ÊÇÒ»¶Ôì¶ÜµÄͳһÌ壬Á½ÕßÊÇ»¥²¹µÄ¹ØÏµ.
varchar2±Èchar½ÚÊ¡¿Õ¼ä£¬ÔÚЧÂÊÉÏ±È char»áÉÔ΢²îһЩ£¬¼´ÒªÏë»ñµÃЧÂÊ£¬¾Í±ØÐëÎþÉüÒ»¶¨µÄ¿Õ¼ä£¬ÕâÒ²¾ÍÊÇÎÒÃÇÔÚÊý¾Ý¿âÉè¼ÆÉϳ£ËµµÄ‘ÒԿռ任ЧÂÊ'¡£
varchar2
ËäÈ»±È char½ÚÊ¡¿Õ¼ä£¬µ«ÊÇÈç¹ûÒ»¸övarchar2Áо³£±»Ð޸쬶øÇÒÿ´Î±»Ð޸ĵÄÊý¾ÝµÄ³¤¶È²»Í¬£¬Õâ»áÒýÆð‘ÐÐÇ¨ÒÆ'(Row
Migration)ÏÖÏ󣬶øÕâÔì³É¶àÓàµÄI/O£¬ÊÇÊý¾Ý¿âÉè¼ÆºÍµ÷ÕûÖÐÒª¾¡Á¦±ÜÃâµÄ£¬ÔÚÕâÖÖÇé¿öÏÂÓà char´úÌævarchar2»á¸üºÃһЩ¡£
mysql_connectºÍmysql_pconnectµÄÇø±ð
ÒýÓÃexceed php clubÂÛ̳ÉϵÄÅóÓÑÔ»°£º
phpÖÐmysql_pconnect()µÄʵÏÖ·½Ê½:
Æäʵmysql_pconnect()±¾Éí²¢Ã»ÓÐ×öÌ«¶àµÄ´¦Àí, ËüΨһ×öµÄÖ»ÊÇÔÚphpÔËÐнáÊøºó²»Ö÷¶¯closeµômysqlµÄÁ¬½Ó.
mysql_pconnect()Óë´Ëͬʱmysql_connect()µÄÇø±ð:
cgi·½Ê½ÏÂ:
ÔÚphp¾cgi·½Ê½ÔËÐÐʱpconnectºÍconnectÊÇ»ù±¾Ã»ÓÐÇø±ðµÄ, ÒòΪcgi·½Ê½ÊÇÿһ¸öphp·ÃÎÊÆðÒ»¸ö½ø³Ì, ·ÃÎʽáÊøºó½ø³ÌÒ²¾Í½áÊøÁË, ×ÊԴҲȫÊÍ·ÅÁË.
apacheÄ£¿é·½Ê½ÏÂ:
Çø±ðÔÚÓÚµ±phpÒÔapacheÄ£¿é·½Ê½ÔËÐÐʱ, ÓÉÓÚapacheÓÐʹÓýø³Ì³Ø, Ò»¸öhttpd½ø³Ì½áÊøºó»á±»·Å»Ø½ø³Ì³Ø, ÕâÒ²¾ÍʹµÃÓÃpconnect´ò¿ªµÄµÄÄǸömysqlÁ¬½Ó×ÊÔ´²»±»ÊÍ·Å, ÓÚÊÇÓÐÏÂÒ»¸öÁ¬½ÓÇëÇóʱ¾Í¿ÉÒÔ±»¸´ÓÃ.
Õâ¾ÍʹµÃÔÚapache²¢·¢·ÃÎÊÁ¿²»´óµÄʱºò, ÓÉÓÚʹÓÃÁËpconnect, php½ÚÊ¡ÁË·´¸´Á¬½ÓdbµÄʱ¼ä, ʹµÃ·ÃÎÊËٶȼӿì. ÕâÓ¦¸ÃÊDZȽϺÃÀí½âµÄ.
µ«ÊÇÔÚapache²¢·¢·ÃÎÊÁ¿´óµÄʱºò, Èç¹ûʹÓÃpconnect, »áÓÉÓÚ֮ǰµÄһЩhttpd½ø³ÌÕ¼ÓõÄmysqlÁ¬½ÓûÓÐclose, Ôò¿ÉÄÜ»áÒòΪmysqlÒѾ´ïµ½×î´óÁ¬½Ó×Å, ʹµÃÖ®ºóµÄһЩÇëÇóÓÀÔ¶µÃ²»µ½Âú×ã.
ÀýÈç:
Èômysql×î´óÁ¬½ÓÊýÉèΪ500, ¶øapacheµÄ×î´óͬʱ·ÃÎÊÊýÉèΪ2000
¼ÙÉèËùÓзÃÎʶ¼»áÒªÇó·ÃÎÊdb, ¶øÇÒ²Ù×÷ʱ¼ä»á±È½Ï³¤
µ±Ç°500¸öÇëÇóµÄhttpd¶¼Ã»ÓнáÊøµÄʱºò...Ö®ºóµÄhttd½ø³Ì¶¼ÊÇÎÞ·¨Á¬½Óµ½mysqlµÄ(ÒòÒѾ´ïµ½mysql×î´óÁ¬½ÓÊý). Ö»Óе±Ç°500¸öhttpd½ø³Ì½áÊø»ò±»¸´ÓòſÉÒÔÁ¬½ÓµÃµ½ÁËmysql.
ÆäÊ
Ïà¹ØÎĵµ£º
ºÍºÜ¶àÓïÑÔ²»Í¬£¬ÔÚPHPÖÐʹÓñäÁ¿Ö®Ç°²»ÐèÒªÉùÃ÷£¬Ö»ÐèҪΪ±äÁ¿¸³Öµ¼´¿É£¬PHPÖеıäÁ¿Ãû³ÆÓÃ$ºÍ±êʶ·û±íʾ,±äÁ¿ÃûÊÇÇø±ð´óСдµÄ¡£
±äÁ¿¸³Öµ£¬ÊÇÖ¸¸ø±äÁ¿Ò»¸ö¾ßÌåµÄÊý¾ÝÊý¾ÝÖµ£¬¶ÔÓÚ×Ö·û´®ºÍÊý×ÖÀàÐ͵ıäÁ¿£¬¿ÉÒÔͨ¹ý"="À´ÊµÏÖ¡£
³ýÁËÖ±½Ó¸³ÖµÍâ,»¹ÓÐÁ½ÖÖ·½Ê½À´¸ø±äÁ¿ÉùÃ÷»ò¸³Öµ¡£Ò»ÖÖÊDZäÁ¿¼äµÄ¸³Öµ¡£ÁíÒ»ÖÖÊÇÒýÓø³Öµ¡£ ......
µ±Ç°ÍøÖ·ÊÇä¯ÀÀÆ÷ÀíÏÔʾµÄÍøÖ·£¬ÊÇÓû§¿´µ½µÄ¡£
¸ù·¾¶ÊÇphpÎļþÔÚ·þÎñÆ÷ÉϵÄ·¾¶£¬ÊÇÕæÊµµÄÎļþ·¾¶¡£
(ÓëjavaÊDz»Ò»ÑùµÄ)
Èç¹ûÓжà²ãincludeÓï¾ä£¬±ØÐëÓøù·¾¶£¬·ñÔò³ö´í¡£
Ìá½»±íµ¥Ê±ÒªÌá½»µ½µ±Ç°ÍøÖ·µÄÏà¶Ô»òÕß¾ø¶ÔµÄÍøÖ·ÀïÃæ¡£
---------------------------------------------------------------------
Ò»¸öÊÇÍ ......
±¾ÕÂ˵˵±äÁ¿µÄ¶¨Òå¡£
Èç¹û¶ÔÓÚ±äÁ¿ºÍ³£Á¿µÄ¶¨Ò壬Äã»á×¢Ò⼸¸ö·½ÃæÄØ£¿Äã¿ÉÄÜ»áÏëµ½£º
ÈçºÎ¶¨Òå±äÁ¿£¬ËüºÍC# µÈÓïÑÔÓÐʲô²»Í¬ÄØ£¿
±äÁ¿Çø·Ö´óСдÂð£¿
PHPµÄ±äÁ¿»¹ÓÐÆäËûÖØÒªµÄÂð£¿
³£Á¿ºÍ±äÁ¿µÄ¶¨ÒåÒ»ÑùÂð£¿
·Ö±ð½²Êö°É¡£
1.ÈçºÎ¶¨Òå±äÁ¿£¬ËüºÍC# µÈÓïÑÔÓÐʲô²»Í¬ÄØ£¿
PHP ÖеıäÁ¿ÓÃÒ»¸ ......
ÀࣨClass£©£ºÊÇһЩ±äÁ¿ÓëһЩʹÓÃÕâЩ±äÁ¿µÄº¯ÊýµÄ¼¯ºÏ¡£
¿É¼òµ¥Àí½âΪº¯ÊýºÍ±äÁ¿µÄ¼¯ºÏ£¬»ò±äÁ¿ºÍº¯ÊýµÄ¶¨ÒåµÄ¼¯ºÏ¡£
Óï·¨ÊÇ£º
class Class_name //ϰ¹ßÉÏÀàµÄµÚÒ»¸ö×Ö·ûΪ´óд£¬²¢ÇÒ±ØÐë·ûºÏ±äÁ¿µÄÃüÃû¹æÔò¡£
{
//º¯ÊýÓë±äÁ¿µÄ¼¯ºÏ(һЩ±äÁ¿(Àà³ÉÔ±)ºÍº¯Êý(ÐÐΪ·½·¨)µÄ¶¨Òå)¡£
}
Êý¾Ý³ÉÔ±(±äÁ¿)ÔÚÀ ......