ÈçºÎµ÷ÊÔPhp?
×î¼òµ¥µÄ˶¼»áµÄµ÷ÊÔ(ÊÇô?):
±¾À´°²×°phpÊÇûÎÊÌâ Ò²ÄÜÓÃÁË µ«ÊÇÓÖ´ÓÊéÉϳÁËһЩ´úÂëÀ´·¢ÏÖ²»ÄÜÓÃ, ÄǾÍÓÃÑÛ¾¦×ÐϸµÄ¶Ô×ÅÊé±¾¾ÀÕýһϴúÂë¹þ ¿Ï¶¨ÊÇÄã³´íÁË ÒªÃ´ÊÇÓ¡Ë¢´íÁË
±ÈÈç 1(yi)¸úl(el) 0(ling)¸úO(´óдo)µÈ
±ðЦ¹þ ÕæµÄÓÐÈ˳´í¹ý »¹ÈÃÎÒ¹ýÈ¥°ïæµ÷ÊÔ ¹ýÈ¥ÎÒ¼Èë½øÈ¥(ËûµÄû±£´æ) ¾ÍÈ«¶ÔÁË
ÑÔ¹éÕý´«
Q: "ΪʲôҪµ÷ÊÔ?"
A: µ±È»ÊÇÒòΪ³ÌÐò´íÀ². ÄãÒÔΪÎÒÓÐʲô±ðµÄ´ð°¸?
Q: "¿ÉÊÇÎÒ¾õµÃÎҵijÌÐòÓ¦¸Ãû´í°¡!"
A: ²»ÄܳöÀ´ÆÚÍûµÄ½á¹û µ±È»ÊÇ´íÎó·¢Éú. ÓÐÕâÖÖ˼ÏëµÄÈËÊǸù±¾²»¾ß±¸µ÷ÊÔ¹ÛÄî ¸üûÓе÷ÊÔÄÜÁ¦.
Q: Äǵ÷ÊÔÓÐʲôÓÃ?
A: ²»¹ÜÊÇÄãÅäÖõÄphp³ö´í »¹ÊÇÄãµÄ³ÌÐòд´í »¹ÊÇÄãдµÄÕýÈ·µÄ³ÌÐò¸ú±ðÈËÅäÖõÄphp(±ÈÈçÃâ·Ñ¿Õ¼ä)·¸³å, ѧ»áµ÷ÊÔ¶¼ÄÜÕÒ³öÔÒòÀ´
Q: Âß¼ÂÒÁËÄܵ÷ÊÔºÃô?
A: »òÐíÄãż¶û¸ÄÀ´¸ÄÈ¥¸ÄºÃÁË ÒÔΪÊǵ÷ÊÔºÃÁË ÆäʵÄÇÒѾ²»Êǵ¥´¿µÄµ÷ÊÔ, ¶øÊÇ·´¸´µÄÓóÌÐò´úÂë½øÐÐ˼¿¼, ²¢ÇÒ·´¸´µÄ¸Ä´úÂëÀ´"ʵ¼ù"ij¸öideaÊÇ·ñ¿ÉÐÐ.
¿ÉÒÔ˵ÊÇ"µ÷ÊÔÂß¼"¶ø·Ç"µ÷ÊÔ´úÂë":
Â߼û´úÂë»òÕßÂÒ´úÂë--µ÷ÊÔ/ÐÞ¸ÄÂß¼-->ÕýÈ·µÄÂß¼->ÌåÏÖÔÚ´úÂëÉÏ,³öÀ´ÕýÈ·µÄ´úÂë.
µ¥´¿µÄµ÷ÊÔ´úÂëÊÇ:
ÕýÈ·µÄÂß¼--±àÂë-->³ö´íµÄ´úÂë--µ÷ÊÔ-->ÕýÈ·µÄ´úÂë
ËùÒÔµ÷ÊÔ¿ÉÒÔ·ÖΪ:
1.µ÷ÊÔÂß¼, 2.µ÷ÊÔ´úÂë, 3.µ÷ÊÔ½çÃæ. 4. etc..
´íÎóµÄÂß¼ÊDz»¿ÉÄܳöÀ´ÕýÈ·µÄ³ÌÐò. д³ÌÐòÊ×ÏȵðÑÂß¼(Á÷³Ì)ŪÇå³þ, È»ºó²Å¿ªÊ¼±àÂë.
ºÏ²¢ÔÚÒ»Æð¾ÍÊÇ:
º¬ºýµÄÂß¼--µ÷ÊÔÂß¼-->ÕýÈ·µÄÂß¼--±àÂë-->³ö´íµÄ´úÂë--µ÷ÊÔ´úÂë-->ÕýÈ·µÄ´ú°¢Âí
ÆäÖе÷ÊÔÂß¼Äã¿ÉÒÔÀûÓÃ"Ð޸ĴúÂë"À´¸¨Öú ÃâµÃÄÔ×ÓÌ«ÀÛ, µ«ÊÇÄÔ×Ó±ØÐ붯, ²»Äܲ»Ë¼¿¼ÂÒ¸ÄÀ´¸ÄÈ¥, ¶øÇÒ²»Äܸú "µ÷ÊÔ´úÂë" »ìÔÚÒ»Æð.
¸ÄС´íÎó ³£³£»ìÔÚÒ»Æð ¾Í½â¾öÁË, µ«ÊÇ񻄿³É·Ö¿ªµÄϰ¹ß, ¶ÔÓÚ´ó´íÎó²ÅÄÜÒ»ÑùÇáËɽâ¾ö.
±ð»Å
ºÜ³õѧÕß Ò»Åöµ½´íÎó¾Í»ÅÁË, ÄÔ×ÓÀïÖ»ÖªµÀ"²»Ðа¡ ´íÁË ²ÒÁË ÕÒ¸öÈËÎÊÎÊ", ÒªÀä¾²ÏÂÀ´ ¸ù¾ÝËùѧµÄ֪ʶȥÑо¿, µ½µ×ʲôÊÇdebug, ÈçºÎdebug, ³ö´íÁ˵½µ×¸Ã¸Éʲô
»ù±¾µ÷ÊÔ:
1. ´ò¿ªµ÷ÊÔ¹¦ÄÜ: php.ini Àï ÉèÖÃerror_reporting = E_ALLÒÔ¼° display_errors = On ÖØÆô web·þÎñ(apache)
2. ˢдíÎóµÄÒ³Ãæ ²é¿´´íÎóÌáʾ ÐкŠÎļþÃû
3. ´ò¿ª¸ÃÎļþ ¶¨Î»µ½³ö´íÐÐ. ±ÈÈç´úÂë echo $abc[2];
4. Àí½â´íÎó:
a. ²é¿´ÊÖ²á Àí½â´íÎóº¬Òå ÒªÄÜÀí½âÊ×ÏÈÒªÀí½âÓïÑÔ ±ÈÈç×î¼òµ¥µÄ Undefined index 2 Òâ˼ÊÇÊý×é²»´æÔÚ¸Ãϱê Ò²¾Í˵Ã÷Äã·ÃÎÊÁËij¸öÊý×é²»´æÔÚµÄÔªËØ
b. Èç¹ûÒѾ֪µÀÈçºÎ¸Ä ¾ÍÖ±½ÓÐ
Ïà¹ØÎĵµ£º
phpÉú³ÉËæ»úµÄº¯ÊýÓÐrand()£¬mt_rand()¡£ÕâÁ©º¯Êý¶ÔÓ¦µÄÖÖ×Óº¯Êýsrand(),mt_srand()¡£
ÔÚphp 4.2.0֮ǰÔÚµ÷ÓÃËæ»úº¯Êý֮ǰµÃÏÈÉèÖÃÖÖ×Óº¯Êý£¬²»È»Éú³ÉµÄÊý¶¼ÊÇΨһµÄ¡£
È磺
4.2.0°æ±¾Ö®Ç°£º
<?
srand((double)microtime()*1000000); //²úÉúËæ»úÖÖ×Óseed
$randval = rand(0,100); //ÔÚ0ºÍ100Ö®¼äȡһ¸ ......
ÔÚPHPÀïµÃµ½Ç°ÌìºÍ×òÌìµÄÈͮ򵀫úÂëǰÌìÈ¥ÃæÊÔµÄʱºòÒ²ÊÇÕâÑù,²»¹ýÎÒµ±Ê±¼Ç²»ÆðÀ´ÁË.¾Í¼ÇµÃMYSQLÀïÃæµÄdate_sub(now(),'interval 1 day');date('Y/m/d h:i:s',mktime(date('h'), date('i'), date('s'), date('m') , date('d')+1, date('Y'))); -------------------------------------------------------------------------- ......
Ð¶ÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁ˰ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......
·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
select * from `user`.`user` limit 0, 50;
select coun ......
×î½üÔÚCSDN¸Õ¿ªÁËÕâ¸ö²©¿Í£¬Ã»Ê²Ã´Ê±¼ä°ÑÒÔǰдµÄÎÄÕ°á¹ýÀ´£¬Ö»ÄÜÓпÕÂýÂýÀ´ÁË¡£
--------------------------ÕâÆªÎÄÕ½öÏ׸øÄÇЩһֱÔÚPHPÂÒÂëÎÊÌâÉÏÀ§»óµÄÈË¡£
A.Ê×ÏÈ˵ÏÂHTMLÖÐÎÄÂÒÂëÎÊÌâµÄ½â¾ö·½·¨¡£
±ÈÈçÓиöindex.htmlµÄÒ³Ãæ£¨ÕâÀïÊÇÖ¸ÕæÕýµÄ¾²Ì¬Ò³Ã棬Ð޸ķþÎñÆ÷µÄ……α¾²Ì¬µÄÇë¿´·½°¸B£©
1. ......