·¢²¼ÐÂÈÕÖ¾

  • db2 ÃüÁîÐÐÖ´ÐÐsql½Å±¾

    2007-05-21 20:03:59

    1.

    db2 -td@ -f filename
    @ÊÇÓï¾ä½áÊø·û¡£

    2.

    db2 -tvf sample.sql

  • PHPѧϰ±Ê¼Ç£¨°Ë£©¡ª¡ªPHP/Êý¾Ý¿â³£¼ûÎÊÌâ

    2007-01-17 17:35:54

    1.ûÓÐÁ¬½Ó

     

    Èç¹ûÔÚPHP½Å±¾ÖÐÓÐÊý¾Ý¿âµ÷Óú¯Êý£¬µ«ÊDz»ÄÜ´ò¿ªÁ¬½Ó¡£ÓÐÁ½ÖÖ¿ÉÄܻᵼÖÂÕâÖÖÇé¿ö¡£

           µÚÒ»ÖÖ¿ÉÄÜÐÔÊǾ¯¸æûÓÐÁ¬½Ó£º

           Warning MySQL Connection Failed Can¡¯t connect to MySQL server on ¡®localhost¡¯(10061) in ¡­

           Õâ˵Ã÷ÎÊÌâ³ö×ÔMySQL·þÎñÆ÷±¾Éí£¬»òÕß³ö×ÔÁ¬½ÓmysqldµÄ·¾¶¡£ÔÚPHP×Ô¼ºµÄÌØÊⷽʽÖУ¬PHP¸æËßËüÖªµÀMYSQL£¬µ«ÊDz»ÄÜÁ¬ÉÏ¡£

           µÚ¶þÖÖ¿ÉÄÜÊÇÎÊÌâ³öÔÚPHPÕâ·½Ãæ¡£

           Fatal error Call to undefined function mysql_connect() in ¡­.

           ÕâÒâζ×ÅPHP¸ù±¾²»ÖªµÀMYSQL¡£

           ÔÚÕâÁ½ÖÖ´íÎóÖУ¬½â¾öÖÂÃü´íÎó£¨fatal error£©Òª¼òµ¥µÃ¶à¡£Èç¹ûÓöµ½µÄ䶨Ò庯ÊýÈ·¶¨ÊÇPHPº¯Êý¼¯Öеĺ¯Êý£¬¾Í¿ÉÒÔºÜÃ÷È·µØÈ·¶¨Ö»ÊÇÍüÁË°²×°¸ÃÄ£¿é¡£ÔÚUNIXÖУ¬ÐèÒªÓá°-with-mysql¡±Ñ¡ÏîÖØбàÒë¡£ÔÚWINDOWSÖУ¬ÐÞ¸Äphp.iniÎļþ¼´¿É¡£

           ¿´ÆðÀ´Î޹ؽôÒªµÄ¡°No Connection¡±´íÎóʵ¼ÊÉϽÏÄÑÕï¶Ï£¬ÒòΪÓм¸¸ö¿ÉÄܵÄÔ­Òò¡£Ö÷Òª·ÖΪÁ½Àࣺ

    l         MYSQLºǫ́³ÌÐòûÓÐÔËÐÐ

    l         MYSQLÌ×½Ó×Ö²»ÊÇPHPÑ°ÕÒµÄÄÚÈÝ

     

    ºÜÈÝÒ×¼ì²émysqldÊÇ·ñÔÚÔËÐУ¬ËùÒÔ¿ÉÒÔÊ×ÏȽøÐмì²é¡£Ö»ÒªÊ¹ÓÃÄܼì²é³öÊÇ·ñÔËÐеÄÈκη½·¨¼´¿É¡£

           ͨ³£ÔÚµÚÒ»´Î´ÓеķþÎñÆ÷ÉÏÆô¶¯MYSQLʱ³öÏÖÌ×½Ó×ÖÎÊÌâ¡£ËäÈ»·¢Éú¹ýÕâÑùµÄÎÊÌ⣬µ«ÊÇÔÚ³¤ÆÚÔËÐеÄÕ¾µãÉÏÕâÖÖÎÊÌâ²»ÊǾ­³£·¢Éú¡£

           ͨ³£ÄÜÔÚphp.iniÎļþÖÐÕÒµ½½â¾öÊý¾Ý¿âÁ¬½ÓÎÊÌâµÄ·½·¨¡£ÓÐÒ»²¿·ÖMYSQL±äÁ¿ÊDZØÐë×Ðϸ¼ì²éµÄ£¬ÕâЩ±äÁ¿ÊÇÔڽű¾ÖÐÖ¸¶¨Ö÷»úÃû¡¢¶Ë¿ÚºÍÌ×½Ó×ֵıäÁ¿¡£ÒªÈ·±£Ã»ÓÐÈÃPHPÔÚÁÙʱµÄ¶Ë¿Ú»ò´íÎóµÄĬÈÏÖ÷»úÉÏÑ°ÕÒMYSQL¡£ÔÚUNIXÉÏ£¬»¹¿ÉÒÔ¼ì²é/etc/servicesÎļþ£¬Ñ°ÕÒ²»Í¬µÄÌ×½Ó×ÖµØÖ·¡£Ò»°ãÇé¿öÏ£¬Ó¦¸ÃÈÃÕâЩ±äÁ¿Êǹ«¿ªµÄ£¬³ý·ÇÓÐÌØÊâµÄÔ­ÒòÒªÉèÖÃËüÃÇ¡£

     

    2.ȨÏÞÎÊÌâ

     

     

    ȨÏÞÎÊÌâÒýÆðµÄ´íÎóÌáʾÐÅÏ¢£º

     

    Warning MySQL Connection Failed Access denied for user:¡¯nohost@localshot¡¯(Using password YES) in ¡­

     

    ÓÉÓÚÕâЩ´íÎóÐÅÏ¢»áÒýÆð°²È«ÐÔÎÊÌ⣬×îºÃÔÚÕ¾µãÖÐʹÓþ²Ä¬Ä£Ê½£¬ÔÚº¯Êýmysql_connectºÍmysql_select_dbÇ°ÃæÌí¼Ó×Ö·û¡°@¡±¡£

           ÕâЩ´íÎóÖÖÀàºÜ¶à£¬µ«ÊÇÖ÷ÒªÓм¸ÖÖ£º

    l         ÊäÈë´íÎóµÄÓû§Ãû/ÃÜÂë

    l         ´íÎóµÄʹÓÃÒªÇóµÄÃÜÂë

    l         ÊÔͼʹÓò»´æÔÚµÄÃÜÂë

    l         ÊÔͼʹÓÃϵͳµÄÓû§Ãû/ÃÜÂë¶ø²»ÊÇMYSQLµÄÓû§Ãû/ÃÜÂë

    l         ʹÓÃȱÉÙÍê³ÉÈÎÎñËùÐèµÄȨÏÞµÄÊý¾Ý¿âÓû§Ãû

    l         ʹÓÃMYSQLÊý¾Ý¿â²»ÔÊÐíij¸öÌض¨Óû§µÇ¼µÄλÖûò¿Í»§¶ËµÇ¼

    l         ÓÉÓÚ²»ÕýÈ·µÄÎļþȨÏÞ£¨±ØÐëÊÇÍêÈ«¿ÉÖ´ÐÐĿ¼ÏµÄÍêÈ«¿ÉÖ´ÐÐÎļþ£©£¬PHP²»ÄÜ´ò¿ªÊý¾Ý¿âÃÜÂë°üº¬Îļþ

    l         Êý¾Ý¿âϵͳ¹ÊÒâ¸ü¸ÄȨÏÞ

     

    3.δתÒåµÄÒýºÅ

     

    ÒýºÅÄÜÒýÆðPHPºÍMYSQLÖ®¼äºÜСµ«ºÜ·³È˵ÄÎÊÌâ¡£ÎÊÌâµÄÖ¢½áÔÚÓÚPHPÔÚË«ÒýºÅÄÚÇóÖµ£¬ºÜ¿ÉÄܺöÂÔµ¥ÒýºÅ£¬¶øMYSQLÔÚµ¥ÒýºÅÄÚÇóÖµ£¬ºÜ¿ÉÄܺöÂÔË«ÒýºÅ¡£ÕâÑù±ØÐ뿼ÂÇÿ¸öÒýºÅµÄ×÷Óá£

           ÔÚ´ó¶àÊýPHP½Å±¾ÖУ¬µ¥ÒýºÅÄڵıäÁ¿²»Äܱ»À©Õ¹£¬¶øË«ÒýºÅ»òûÓÐÒýºÅµÄ±äÁ¿ÊDZ»À©Õ¹µÄ¡ª¡ªËùÒÔ²éѯ¿´ÉÏÈ¥ÓÐЩÆæ¹Ö¡£µ«ÊÇÈç¹û¿¼ÂÇһϣ¬»á·¢ÏÖÔÚÁ½ÖÖÓïÑÔÖÐÓï¾ä¶¼ÊÇÓÐЧµÄ¡£µ¥ÒýºÅ´æÔÚË«ÒýºÅÄÚ£¬ËùÒÔPHP°ÑËüÃǵ±×÷ÎÄ×Ö×Ö·û£»±äÁ¿Êµ¼ÊÉÏÔÚË«ÒýºÅÄÚ£¬ËùÒÔPHPÓñäÁ¿µÄÖµ´úÌæ±äÁ¿¡£¿ÉÒÔÓÃÒÔÏ·½Ê½¿¼ÂÇÕâÖÖ·Ö¹¤£ºÔÚÊý¾Ý¿â²éѯÖУ¬PHP¶ÔË«ÒýºÅÖ®¼äµÄÄÚÈݲÙ×÷£¨°Ñµ¥ÒýºÅµ±×÷ÎÄ×Ö£©£¬È»ºóMYSQL´¦ÀíÁôÔÚµ¥ÒýºÅÄÚµÄÄÚÈÝ¡£

           ÕâÖÖ·ç¸ñµÄÓï¾äÒ²Ïû³ýÁËÒýÆð³£¼ûµÄPHP´íÎóµÄË«ÒýºÅ¡£

           ¸ü´óµÄÎÊÌâÊÇÔÚÎı¾ÖÐʹÓõ¥ÒýºÅºÍË«ÒýºÅµÄ×Ö·û´®¡£ÔÚPHPºÍMYSQLÖÐƲºÃºÍµ¥ÒýºÅÊÇÒ»ÑùµÄ¡£ËùÒÔÈç¹ûÈκÎÐÕÊÏÓÐÒ»¸öƲºÅ£¬ÔòSQLÓï¾ä½«Öжϡ£

           ÔÚPHPÒ»²àµÄÏàÓ¦ÎÊÌâÊÇÓÐË«ÒýºÅµÄ×Ö·û´®¡£ÕâÖÖ¹¹½¨·½·¨ÎÞÒɲ»ÄÜʵÏÖÏ£ÍûµÄ¹¦ÄÜ£º

           Ôڷdz£³¤µÄÎı¾ÌõÄ¿ÖУ¬ÒýºÅÎÊÌ⽫µ¼Ö°Ѳ¿·Ö×Ö·û´®²åÈëµ½Êý¾Ý¿âÖУ¬»òÕßÍêȫʧ°Ü£¬»òÕß¿´ÆðÀ´ÏñÊDz»ÔÊÐí½Ï³¤µÄÌõÄ¿¶øÔÊÐí½Ï¶ÌµÄÌõÄ¿¡£

           ÏÖÔÚ½éÉÜ´¦ÀíÒýºÅÎÊÌâµÄÈýÖÖ·½·¨£º

    l         Ö±½ÓÔÚ´úÂëÄÚʹÓÃ×Ö·û´®µÄÇé¿öÏ£¬¿ÉÒÔÓ÷´Ð±¸ÜתÒå±ØÒªµÄÒýºÅ×Ö·û¡£

    $query=¡±INSERT INTO employee (ID, lastname, firstname) VALUES (¡®NULL¡¯,¡¯O\¡¯Donnell¡¯,¡¯Sean¡¯)¡±;

    l         ÔÚÓñäÁ¿±íʾ×Ö·û´®µÄÇé¿öÏ£¬¿ÉÒÔʹÓÃaddslashes()£¬×Ô¶¯Ìí¼ÓÈκαØÒªµÄ·´Ð±¸Ü¡£

    $string=addslashes(¡°He said, ¡® I¡¯m not angry,¡¯ but I knew he was.¡±)

    $statement=mysql_query(¡°INSERT INTO diary (ID,entry) VALUES(¡®NULL¡¯,¡¯$string¡¯)¡±);

     

    l         ¿ÉÒÔÓÃ-with-magic-quotesÑ¡ÏÁ¢PHP£¬ÊµÊ±ÔÚphp.iniÎļþÖÐÉèÖÃħÊõÒýºÅ¡£Ëü½«Ìí¼Ó·´Ð±¸Ü£¬¶ø²»ÐèҪÿ´ÎÖ¸¶¨addslashes()¡£Èç¹ûISP¿ØÖÆphp.iniÎļþ£¬ÄÇôӦ¸ÃÈÔÈ»Äܸü¸ÄÓû§×Ô¼ºµÄ.htaccessÎļþ£¬ÉèÖÃÕâЩ±äÁ¿¡£

     

    ÓÉÓÚһЩ˵²»ÇåµÄÐÄÀïÔ­Òò£¬Ðí¶àPHPÓû§·Ç³£²»Ô¸ÒâʹÓÃaddslashes()ºÍstripslashes()¡£µ±ÈËÃÇʵ¼ÊÉϲ»Ó¦¸ÃʹÓÃÒýºÅʱ£¬ËûÃÇ×ÜÊÇʹÓõ¥ÒýºÅ£¬Òò´Ë¾Í²»±ØתÒåË«ÒýºÅ¡£ÔÚÈκÎʱºòÕâÑùµÄÓ÷¨¶¼ÊDz»ºÃµÄ·ç¸ñ£¬ÓÈÆäÔÚʹÓÃÊý¾Ý¿âʱÌرðΣÏÕ¡£

    µ±ÏòÊý¾Ý¿âÖвåÈëֵʱÐèÒªÌí¼Ó·´Ð±¸Ü£»Ïà·´£¬µ±´ÓÊý¾Ý¿âÖеõ½×Ö·û´®Ê±ÐèҪȥ³ý·´Ð±¸Ü£¨³ý·ÇÆôÓÃÁËmagic-quotesÑ¡Ï¡£

    $query=¡±SELECT passphrase FROM userinfo WHERE username=¡¯$username¡¯¡±;

    $result=mysql_query($query);

    $query_row=msql_fetch_array($result);

    $passphrase=stripslashes($query_row[0]);

     

           Èç¹û²»ÄÜʵÏÖÕâÏîÈÎÎñ£¬ÄÇôÔÚÿ´Î°ÑÊý¾ÝÖØмÓÈëµ½MYSQLÖÐʱÌí¼ÓÔ½À´Ô½¶àµÄ·´Ð±¸Ü¡£ÔÚʹÓÃÖØÐÂÏÔʾ´ÓÊý¾Ý¿âÖÐÈ¡³öµÄÖµµÄ¿É±à¼­WEB±íµ¥Ê±£¬¾­³£»áÓöµ½ÕâÑùµÄÎÊÌâ¡£

     

    4.ÖжϵÄSQLÓï¾ä

           ³ýÁËÒýºÅÎÊÌâÒÔÍ⣬»¹Óм¸¸öÈÝÒ׸øÊý¾Ý¿â·¢ËÍ¡°»µ¡±²éѯµÄ·½·¨¡£²éѯ¿ÉÄÜÓï·¨²»¶Ô£¬»òÕßÓï·¨ÕýÈ·µ«ÊÇÒýÓÃµÄ±í²»´æÔÚ£¬»òÕß´æÔÚʲôÎÊÌâʹÊý¾Ý¿â²»ÄÜÕýÈ·µØ´¦Àí²éѯ¡£µäÐ͵ĴíÎóÐÅÏ¢ÈçÏ£º

    Warning Supplied argument is not a valid MYSQL result resource in ¡­

     

           µ«ÊÇÈç¹ûÊÇÕýÈ·µÄ²éѯÓï¾äµ«ÊÇÓÉÓÚ½á¹û¼¯ÖÐÇ¡ÇÉÖ»°üº¬0Ìõ¼Ç¼¡£ÓÉÓÚÔÚÆäËûÇé¿öÏ£¬ÕâÒâζ×Ų¶»ñµ½²éѯʧ°ÜµÄ´íÎó·ý»ñ³ÌÐò²»ÄÜ°ïÖú¼ì²âµ½0¼Ç¼µÄÇé¿ö¡£¶ÔÓÚʹÓÃMYSQLµÄ³ÌÐòÔ±¶øÑÔ£¬Ò»¸öÓÐÖúÓÚ½â¾öÕâ¸öÎÊÌâµÄº¯ÊýÊÇmysql_num_rows()£¬µ÷ÓÃËüµÃµ½²éѯ½á¹ûµÄID£¬·µ»ØÒ»¸öÕûÊý¡£

           Ò»¸öºÃµÄʾÀýÊÇ£º

           $result_id=mysql_query($query) or die(mysql_error());

     

    ÒòΪÈç¹û²éѯʧ°Ü£¬mysql_query()½«·µ»ØfalseÖµ£¬ËùÒÔÖ»ÔÚʧ°ÜʱִÐÐdie()²¿·Ö¡£Èç¹û¸³Öµ³É¹¦£¬ÔòorµÄµÍÔËËãÓÅÏÈ˳ÐòÈ·±£die()µ÷Óò»»áÔÚ¸³ÖµÓï¾äÖÐÆð×÷Óá£Ò»µ©²Ù×÷ʧ°Ü£¬Ö»Òª½Å±¾Ò»´òÓ¡³öMYSQLÉè¼ÆÕß±àÖƵÄÐÅÏ¢×î·á¸»µÄ´íÎóÏûÏ¢£¬¾ÍÍ˳ö½Å±¾¡£Èç¹ûÓû§Ê¹ÓõÄÊý¾Ý¿âȱÉÙPHPÖеĴíÎó±äÁ¿£¬¾ÍÐèÒªµ÷ÓÃdie($query)¡£Í¨³£Ò»¿´µ½ÕæÕý±»·¢Ë͵IJéѯÓï¾ä£¬´íÎó¾ÍºÜÃ÷ÏÔÁË¡£

           Èç¹ûûÓÐÔÚ²éѯµ÷ÓÃÖÐÉèÖüì²é´íÎóµÄ´úÂ룬ÔòÔÚºóÃæµÄÊý¾Ý¿â´úÂëÖÐÊÔͼʹÓòéѯ½á¹ûIDʱ½«µÃµ½µÚÒ»Ìõ»µÏûÏ¢¡£µäÐ͵ÄģʽÊÇ£º

           $my_result=$mysql($bad_query);

           //¡­other processing and display code

           $row=mysql_fetch_row($my_result);   //error shows up here

     

           MySQLÖеäÐ͵ĴíÎóÏûÏ¢ÊÇ¡°0 is not a mysql result identifier in [etc.]¡±¡£Õâ²»ÊÇÒòΪ¼ì²âµ½ÔÚʧÊýʱmysql_query()·µ»ØµÄ0Öµ£¬¶øÊÇÒòΪÓû§ÊÔͼʹÓøÃÖµ£¬¾ÍºÃÏñËüÊǽá¹û¼¯ÖеÄÒ»¸öÓÐЧ±êʶ·û¡£

           ËäÈ»Ôã¸âµÄ²éѯÊDzúÉú¡°0 is not a valid result identifier¡±ÏûÏ¢µÄ×î³£¼ûµÄÔ­Òò£¬µ«²»ÊÇΨһµÄÔ­Òò¡£Èç¹û´íÎóµÄƴд½á¹û±êʶ·û±äÁ¿µÄÃû³Æ£¨¸Ã±äÁ¿ÊÇδ±»É趨µÄ£©»òÕ߸ù±¾Ã»ÓÐÖ´ÐвéѯÓï¾ä£¬Ò²»áµÃµ½¸ÃÏûÏ¢¡£Èç¹ûÔçЩ·ý»ñ´íÎ󣬾͸üÈÝÒ×Çø·ÖÕâЩÎÊÌâ¡£

     

    4.1ƴд´íÎóµÄÃû³Æ

     

    ×î³£¼ûµÄƴд´íÎó°üÀ¨£º±í¡¢×ֶκÍÖµµÄÃû³Æƴд´íÎó¡£PHPºÍMYSQL¶¼ÊÇÇø·Ö´óСдµÄ¡£

     

    4.2¶ººÅÒýÆðµÄ´íÎó

     

    ÔÚSQLÓï¾äÄÚ¶ººÅÒª·ÅÔÚµ¥ÒýºÅÖ®Íâ¡£

     

     

    4.3δ±»ÒýºÅÒýÆðÀ´µÄ×Ö·û´®²ÎÊý

     

    ÐèÒªÔÚSQLÓï¾äÄÚ°ÑÓ¦¸Ã±»Êý¾Ý¿âµ±×÷×Ö·û´®Êý¾ÝÖµµÄÈκÎÖµÓõ¥ÒýºÅÒýÆðÀ´¡£

     

    4.4δ±»É趨µÄ±äÁ¿

    ÖжÏSQLÓï¾äµÄÒ»¸ö¸ü²îµÄ·½·¨ÊÇÔÚÓï¾äÖвåÈëδ±»É趨µÄ±äÁ¿¡£

           ÓÉÓÚÓпÉÄܳöÏÖÕâÖÖÎÊÌ⣬ËùÒÔ×îºÃ¹¹½¨²éѯÓï¾ä²¢Óõ¥¸öÓï¾ä°ÑËü¸³¸ø±äÁ¿¡£È»ºóÔÙÏÔʽµ÷ÓÃmysql_query()¡£Èç¹ûÕâÑù×÷£¬¾Í·Ç³£ÈÝÒ×Ìí¼Ó´òÓ¡»òµ÷ÊÔÓï¾ä£¬ÏÔʾ³öÕýÔÚ·¢Ë͵Äʵ¼ÊµÄ²éѯ¡£

     

     

    5.Êý¾ÝÌ«ÉÙ»òÌ«¶à

           Èç¹û²éѯº¯Êý³É¹¦·µ»Ø£¬µ«ÊÇûÓÐÏÔʾ³ö´ÓÊý¾Ý¿âµÃµ½µÄÊý¾Ý£¬»òÕßÏÔʾµÄ²»ÊÇÔ¤ÆڵĽá¹û¡£ÕâʱÔòÓ¦¸Ã»³ÒÉSQL±¾Éí¡£ÖØмì²éÂß¼­£¬ÓÈÆäÊÇWHERE×Ӿ䡣

           Èç¹û½Å±¾ÕýÔÚ±éÀúÊý¾Ý¿â¼Ç¼²¢ÏÔʾ³öÌ«¶àµÄ¼Ç¼£¬ÔòÎÊÌâ¾­³£ÊÇSQLÁª½áµÄÔ¼Êøֵ̫ÉÙ¡£ÓÐÕâÑùµÄÒ»ÌõÔ¼¶¨£¬ÔÚWHERE×Ó¾äÖеÄÔ¼ÊøµÄ¸öÊý²»Ó¦¸ÃµÍÓÚ±»Áª½áµÄ±íµÄÊýÄ¿¼õ1¡£

     

    6.Çå³þµÄ¼ì²é

           Èç¹ûÔÚµ÷ÊԺͲéѯÓйصĴíÎóÒÔ¼°²»ÕýÈ·µÄ½á¹û£¬±È½ÏǶÈëµÄPHP²éѯµÃµ½µÄ½á¹ûÓëÖ±½Ó¶ÔÊý¾Ý¿â½øÐеÄͬÑù²éѯµÃµ½µÄ½á¹û£¬¿ÉÒÔÓÐÖúÓÚµ÷ÊÔ³ÌÐò¡£Èç¹û°²×°µÄ³ÌÐòÔÊÐíÖ±½ÓÔËÐÐSQL½âÊÍÆ÷£¨ÀýÈ磬ÔÚÃüÁîÐÐÊäÈëmysql£©ÒÔ¼°³ÌÐòÖ®¼äµÄ½»²æ¸´ÖƺÍÕ³Ìù£¬ÄÇô¿ÉÒÔÊÔÊÔÒ»ÏÂÁ½¸ö²½Ö裺

    l         ÔÚPHP²åÈëµ÷ÊÔÓï¾ä£¬ÔÚÕæÕýÓÃÓÚÊý¾Ý¿â²éѯµ÷ÓÃÓï¾ä֮ǰÁ¢¼´´òÓ¡²éѯÓï¾ä±¾Éí£¨Èçprint($query);£©¡£

    l         °Ñ¸Ã²éѯÓï¾ä´Óä¯ÀÀÆ÷ÊäÈ루»òHTMLÔ´Îļþ£©ÖÐÖ±½ÓÕ³Ìùµ½SQL½âÊÍÆ÷ÖС£

     

    Èç¹û²éѯ¿´ÆðÀ´ºÜºÏÀí£¬µ«ÊÇÔÚSQL³ÌÐòºÍPHPÖж¼ÓÐÎÊÌ⣬ÄÇôÔÚSQLÖÐÒ»¶¨´æÔÚ±»´í¹ýµÄijЩÓï·¨´íÎó»òÃüÃû´íÎó£¬PHP´úÂëûÓÐ´í£¨³ý·Ç´úÂëÊ×Ïȹ¹½¨Á˸òéѯÓï¾ä£©¡£ÀàËƵģ¬µ±Êý¾ÝÌ«ÉÙ»òÊý¾ÝÌ«¶àʱ£¬Èç¹ûµÃµ½µÄ½á¹ûÔÚÁ½¸ö³ÌÐòÖж¼ÊÇÒ»ÑùµÄ£¬Ôò²éѯÓÐÎÊÌâ¡£ÁíÒ»·½Ã棬Èç¹ûÔÚSQL½âÊÍÆ÷Öнá¹ûÊÇÔ¤ÆÚµÄÄÇÑù£¬Ôò²éѯÓï¾äÊÇÕýÈ·µÄ£¬Ó¦¸Ã»³ÒÉ·¢Ë͸òéѯÓï¾äÒÔ¼°´¦Àí½á¹ûµÄPHP´úÂëÓÐÎÊÌâ¡£

           Ò»¸ö³£Óõĺü¼ÇÉÊǷdz£×ÐϸµØÑо¿ÈκδíÎóÏûÏ¢£¬×¢Òâ¡°link identifier¡±ºÍ¡°result identifier¡±¶ÌÓï¡£ÔÚMYSQLÖУ¬Ç°ÕßÒâζ¿´Êý¾Ý¿âÁ¬½ÓµÄ±êʶ·û£¬ºóÕßÒâζ×ÅÓÉij¸ö²éѯ·µ»ØµÄ¼Ç¼¼¯µÄ±êʶ·û¡£ºÜÈÝÒ×»ìÏýÕâÁ½¸ö±êʶ·û¡£

     

    7.С½á

     

    PHPÊý¾Ý¿âÖеÄbugͨ³£²»Ì«ÄÑÒ²²»Ì«Î¢Ãµ«½øÐÐÅжÏÈÔÈ»ÓÐÀ§ÄÑ¡£Ò»°ãÇé¿öÏ£¬Ô½ÔçÔڽű¾Öв鵽´íÎ󣬾ÍÔ½ÔçÄÜÕï¶Ï³öÎÊÌâµÄËùÔÚ¡£ÓÈÆäÊÇÔÚµ÷ÊÔ³ÌÐòʱ£¬ºÍÊý¾Ý¿âÓйصÄÿ¸öÓï¾äÓ¦¸ÃÓÐor die()×Ӿ䣬¸Ã×Ó¾ä°üº¬·á¸»µÄ´íÎóÏûÏ¢¡£

    µ½Ä¿Ç°ÎªÖ¹£¬ÒýÆðÊý¾Ý¿âÁ¬½ÓÎÊÌâµÄ×î³£¼ûµÄÔ­ÒòÊǸøÁ¬½Óº¯ÊýÌṩÁ˲»ÕýÈ·µÄ²ÎÊý£¨Ö÷»úÃû¡¢Óû§ÃûºÍÃÜÂ룩¡£ÒýÆð²éѯʧ°ÜµÄ×î³£¼ûµÄÔ­ÒòÊÇÒýºÅ´íÎó¡¢Î´±»É趨µÄ±äÁ¿ºÍƴд´íÎó¡£

           Èç¹û¿´ÆðÀ´Õý³£µÄÊý¾Ý¿â²éѯ×ÜÊÇʧ°Ü£¬Ôò´òÓ¡³ö·¢ËÍÊý¾Ý¿âµÄÿÌõ²éѯÓï¾ä£»Èç¹û¿ÉÄÜ£¬ÊÔ×ÅÖ±½Ó°Ñ²éѯÓÃÓÚÊý¾Ý¿â¡£Èç¹ûÎÊÌâ³ÖÐøµ½PHP½áÊøÑ­»·Ê±£¬ÔòÓ¦¸Ã°Ñ×¢ÒâÁ¦·ÅÔÚÊý¾Ý¿âÉè¼ÆÒÔ¼°SQL²éѯÓï¾äÉÏ£¬ÕÒ³öÎÊÌâËùÔÚ¡£

  • PHPѧϰ±Ê¼Ç£¨Æߣ©¡ª¡ªÌá¸ßÐÔÄÜ

    2007-01-16 15:56:17

    1.¼õÉÙÁ¬½Ó´ÎÊýºÍÖØÓÃÁ¬½Ó

     

    ½¨Á¢ÓëÊý¾Ý¿âµÄ³õʼÁ¬½Ó´ÓÀ´¶¼²»ÊǺÜÈÝÒ×µÄÊÂÇé¡£³ý·ÇPHP½Å±¾ÔÚÍê³ÉһЩÒìºõÑ°³£Ãܼ¯µÄ¼ÆËãÈÎÎñ£¬·ñÔòÕû¸öÊý¾Ý¿âµÄ½»»¥½«ÊÇ´úÂëÖÐ×îºÄ·Ñʱ¼äºÍ×ÊÔ´µÄ²¿·Ö¡£

           ÕâÀïÓÐÁ½¸öDZÔÚ¶ÔÁ¢µÄÄ¿±ê¡£Ò»·½Ã棬Äã»áÏ£ÍûÔÚ´úÂëÖÐΪ´ò¿ªÒ»¸öȫеÄÊý¾ÝÁ¬½ÓËù½øÐеݺ¹ó¡¢ºÄʱµÄµ÷ÓõĴÎÊý×îÉÙ¡£Õâ±íÃ÷ÔÚÒ³ÃæÖ´ÐÐÆÚ¼äÓ¦¸ÃÒ»Ö±´ò¿ªÁ¬½Ó£¬¶ø²»ÊǹرպóÔÙ´ò¿ª¡£ÁíÒ»·½Ã棬ÓÐʱÊý¾Ý¿â³ÌÐò¿ÉÒÔÖ§³ÖµÄͬʱÁ¬½ÓÊýÓкÜÑϸñµÄÏÞÖÆ£¬±íÃ÷Ó¦¸ÃÔÚ¿ÉÄܵÄÇé¿öϾ͹رÕÁ¬½Ó£¬Ê¹Ã¿¸ö½Å±¾Á¬½Ó×ŵÄʱ¼ä¸üÉÙ£¬ÒÔÔÊÐíͬʱִÐиü¶àµÄ½Å±¾¡£

     

    1.1ÿÌõÓï¾äÓÐÒ»¸öÁ¬½Ó

    ³£ÓõĹæÔòÊÇÖ»ÒªÔÚµ¥¸öÒ³ÃæµÄ½Å±¾µÄÖ´Ðйý³ÌÖÐÐèÒª£¬¾ÍÒ»Ö±´ò¿ªµ¥¸öÁ¬½Ó¡£

    1.2¶à¸ö½á¹û²»ÐèÒª¶à¸öÁ¬½Ó

           Ò»¸öЧÂʺܵ͵Ä×ö·¨ÊÇ£ºÊ¹ÓÃÐí¶àÊý¾Ý¿â³ÌÐòʱ£¬¶¼ÓпÉÄÜÒ»´Î±£Áô¶à¸ö²éѯµÃµ½µÄ½á¹û£¨¼´Ê¹Ö»´ò¿ªÁËÒ»¸öÁ¬½Ó£©¡£

     

    1.3ÓÀ¾ÃµÄÁ¬½Ó

    ×îºó£¬Èç¹ûÒѾ­È·¶¨´ò¿ªÐµÄÊý¾Ý¿âÁ¬½Ó»á½µµÍÐÔÄÜ£¬ÄÇôÎÒÃǾͻáÏ£Íû´ò¿ªÓÀ¾ÃµÄÁ¬½Ó¡£ºÍ³£¹æµÄÊý¾Ý¿âÁ¬½Ó²»Ò»Ñù£¬µ±Ò³ÃæÍ˳öʱ²»»á×Ô¶¯¶Ï¿ªÕâЩÁ¬½Ó£¨ÉõÖÁµ±µ÷ÓÃmysql_close()ʱҲÊÇÈç´Ë£©£¬¶øÊDZ£´æÔÚ»º³å³ØÖÐÒÔºóÔÙÓ᣽ű¾µÚÒ»´Î´ò¿ªÕâÑùµÄÁ¬½Óʱ£¬Æä×ÊÔ´µÄºÄ·Ñ·½Ê½ºÍ³£¹æÊý¾Ý¿âÁ¬½ÓÒ»Ñù¡£µ«ÊÇ£¬±»Ö´ÐеÄÏÂÒ»¸ö½Å±¾¸ù¾ÝÇëÇó¿ÉÄܵõ½ÍêÈ«ÏàͬµÄÁ¬½Ó£¬ÕâÑù¾ÍÊ¡È¥ÁËÖØдò¿ªÐÂÁ¬½ÓµÄʱ¼ä£¨Ö»ÓÐÔÚÐÂÇëÇóµÄ²ÎÊýÒ»Ñùʱ²Å»áÖØÓÃÇ°Ò»¸öÁ¬½Ó£©¡£

           ¶ÔÓÚMySQL£¬ÇëÇóÕâÑùµÄÓÀ¾ÃÁ¬½ÓµÄPHPº¯ÊýÊÇmysql_pconnect()£¬Ê¹ÓÃËüµÄ·½Ê½ºÍmysql_connect()Ò»Ñù¡£

           ÓÀ¾ÃÊý¾Ý¿âÁ¬½ÓÖ»ÓÃÓÚPHPµÄÄ£¿é°²×°ÐÎʽ¡£Èç¹ûCGI°æ±¾µÄPHPÖÐÇëÇóÓÀ¾ÃÁ¬½Ó£¬ÔòÖ»Äܵõ½³£¹æµÄÁ¬½Ó¡£

           ³ýÁËЧÂÊÄÜÌá¸ßÒÔÍ⣬ÓÀ¾ÃÊý¾Ý¿âÁ¬½Ó²»Ìṩ³¬³ö³£¹æÊý¾Ý¿âÁ¬½ÓÒÔÍâµÄÈκι¦ÄÜ¡£ÌرðÊÇ£¬²»Ó¦¸ÃÆÚÍûÓÀ¾ÃÊý¾Ý¿âÁ¬½Ó¶Ô´ÓÒÔÇ°Ò³ÃæÖ´ÐгÌÐòµÃµ½µÄ²éѯ»ò±äÁ¿ÓÐÈκΡ°¼ÇÒ䡱¡£

     

    2.ʹÓÃÊý¾Ý¿âÌṩµÄ¹¦ÄÜ

    ³£ÓõĹæÔòÊÇ£¬³ý·ÇÔ¸ÒâÔÚ×Ô¼ºµÄ³ÌÐòÖл¨·Ñ´óÁ¿µÄ¾«Á¦ÓÅ»¯´úÂ룬·ñÔò×îºÃʹÓÃÊý¾Ý¿âÌṩµÄ¹¦ÄÜ£¬¶ø²»ÒªÊ¹ÓÃ×Ô¼ºµÄ½â¾ö·½°¸ÊµÏÖͬÑùµÄÈÎÎñ¡£

    2.1ºÜ¿ÉÄܱÈ×Ô¼ºµÄ·½°¸¿ì

    Èç¹û¿ÉÄܵĻ°£¬ÈκζÔÊý¾Ý¿âÄÚÈݵÄËÑË÷»òÅÅÐò×îºÃÔÚÊý¾Ý¿âÄÚÍê³É£¬¶ø²»ÊÇÓÃ×Ô¼º±àдµÄ´úÂëÍê³É¡£

     

     

    2.2ÓÃÀýÑ­»·È´Ã»ÓÐÏÞÖÆËü

    ÕýÈ·µÄ×ö·¨ÊÇÓá°WHERE¡±×Ó¾äÏÞÖƲéѯ¡£WHERE×Ó¾äÈ·±£Ê×ÏÈֵѡ³öÓû§¹ØÐĵļǼ¡£ÕâÑù²»½ö¼õÉÙͨ¹ýSQLÁ¬½Ó´«µÝµÄÊý¾Ý£¬¶øÇÒÔÚÊý¾Ý¿âÒ»¶ËÕÒµ½¼Ç¼µÄÕýȷλÖõĴúÂëÒ²±ÈPHP´úÂë¿ìµÃ¶à¡£

           µ±±àд´úÂë¶Ô´ÓÊý¾Ý¿âÖзµ»ØµÄÊý¾Ý½øÐÐÅÅÐò¡¢¼ÆËã¡¢Çóƽ¾ùÖµ»òÕ߶Խá¹û½øÐм¯ºÏ²Ù×÷ʱ£¬Ó¦¸ÃÓ¦ÓÃÍêÈ«Ò»ÑùµÄ²ÎÊý¡£Ò»°ãÇé¿öÏ£¬SQLÖеÄORDER BYÓï¾äÔÊÐí¸ù¾ÝÔÚ²éѯ½á¹ûÖÐÓÐÈκÎÓÅÏÈ´ÎÐòµÄ×Ö¶ÎÁÐ±í£¬¶Ô¼ìË÷³öµÄ¼Ç¼ԤÏÈÅÅÐò£¬ÕâÑùµÄÅÅÐòºÜ¿ÉÄܱÈ×Ô¼º±àдµÄ´úÂë»òPHPÊý×éÅÅÐòº¯Êý¸üÓÐЧ¡£ÀàËƵģ¬²»ÒªÔÚÊý¾Ý¿â¼Ç¼Öоݻ·½øÐмÆÊý¡¢ÇóºÍºÍÇóƽ¾ùÖµ²Ù×÷£¬¶øÒªµ÷²éÒ»ÏÂ×Ô¼ºÊ¹ÓõÄÊý¾Ý¿âÖеÄSQLÓï·¨ÊÇ·ñÖ§³ÖGROUP BY½á¹¹ºÍÄÚ²¿²éѯº¯Êý£¬Èçcount()¡¢sum()ºÍaverage()¡£

     

    2.3´´½¨ÈÕÆÚºÍʱ¼ä×Ö¶Î

     

    ¶ÔÓÚ´ó¶àÊýÊý¾Ý¿âϵͳ£¬²»ÐèҪͨ¹ýÇúÕ۵İ취°ÑÒ»¸ö×Ö¶ÎÉèÖóɵ±Ç°µÄÈÕÆÚ»òʱ¼ä¡£Ðí¶àÊý¾Ý¿âÓеõ½µ±Ç°ÈÕÆڵĺ¯Êý£¬¿ÉÒÔÖ±½ÓǶÔÚ²éѯÓï¾äÖС£

           ¶øÇÒ£¬¼´Ê¹ÐèÒª´æ´¢µÄʱ¼ä²»ÊÇÖ´Ðвéѯµ±Ç°µÄʱ¼ä£¬Ò²ÈÔÈ»ÓбÈÔڽű¾Öй¹½¨¿É¶ÁµÄÈÕÆÚ×Ö·û´®ÒªºÃµÄÆäËû·½·¨¡£³ýÁË·µ»Øµ±Ç°ÈÕÆڵĺ¯ÊýÒÔÍ⣬Ðí¶àSQL°æ±¾ÌṩִÐÐÈÕÆÚËãÊõ²Ù×÷µÄº¯Êý¡ª¡ª´Óijһ¸öÈÕÆÚ/ʱ¼ä/¿ªÊ¼£¬È»ºó¼ÓÉÏ»ò¼õÈ¥¼¸Äê¡¢¼¸¸öÔ»ò¼¸¸öСʱ¡£ÔÚMYSQLÖУ¬ÕâЩº¯ÊýÓУº

    l         date_add(date,date-interval)

    l         date_sub(date,date-interval)

    ÕâÀdate-intervalÊÇ°üÀ¨¼¸¸öʱ¼äµ¥Î»ºÍµ¥Î»ÀàÐ͵Ä×Ö·û´®¡£ÏÂÃæµÄMYSQL²éѯÓï¾ä°ÑËùÓеļǼÉèÖóɴÓÏÖÔÚ¿ªÊ¼µÄÒ»¸öÐÇÆÚºó£º

    $query=¡±update mytable set mydate=date_add(now(),¡¯7 days¡¯)¡±;

     

    2.4Ñ°ÕÒ×îºó²åÈëµÄ¼Ç¼

     

    һЩÊý¾Ý¿âϵͳÌṩµÄÁíÒ»¸ö¾ªÈ˵ÄÓÐÓù¦ÄÜÊÇÑ°ÕÒ²åÈëµÄ×îºóÒ»Ìõ¼Ç¼µÄID¡£

           ÔÚÐèÒª²åÈë×îºóÒ»Ìõ¼Ç¼µÄÇé¿öÏ£¬×îºÃµÄ·½°¸ÊÇʹÊý¾Ý¿â×Ô¼ºÒÔ¼ìË÷µÄ·½Ê½¸ú×Ù×îºó²åÈëµÄID£¬²¢ÔÚÿ¸öÁ¬½Ó»ù´¡ÉϽøÐиú×Ù£¬ÕâÑù²»±Øµ£ÐÄͬ²½µÄÎÊÌâ¡£¶ÔÓÚMYSQLÓû§£¬PHPÌṩµÄº¯Êýmysql_insert_id()£¬¸Ãº¯Êý°ÑÁ¬½ÓIDµ±×÷²ÎÊý£¬·µ»Ø×îºó²åÈëµÄ¼Ç¼×Ô¶¯Ôö³¤µÄID¡£

           ¶ÔÓÚÐí¶àPHP/MYSQLº¯Êý£¬mysql_insert_id()µÄÁ¬½Ó²ÎÊýÊÇ¿ÉÑ¡µÄ£¬Ä¬ÈÏÊÇ×î½ü´ò¿ªµÄÁ¬½Ó¡£

           ÔÚһЩÆäËûµÄÊý¾Ý¿âϵͳÖУ¬×î½üÔö³¤µÄID¿ÉÒÔÊÇÄܱ»Ç¶ÔÚÏÂÒ»¸ö²éѯÖеġ°ÌØÊ⡱±äÁ¿¡£ÀýÈ磬ÔÚMicrosoft SQL ServerÉÏ£¬±äÁ¿ÊÇ¡¯%%identity¡¯£¬Ëü¿ÉÒÔ±»Ç¶ÔÚ²éѯÖУ¬¼ìË÷×îºó²åÈëµÄID£¬ÈçÏÂËùʾ£º

           $query=¡±select @@identity¡±;

     

    3.С½á

     

           Êý¾Ý¿â±àÂëµÄ»ù±¾Ô­ÔòºÜ¼òµ¥¡£´ò¿ªºÍÊý¾Ý¿âµÄÁ¬½ÓÒªºÄ·ÑºÜ¶àʱ¼äºÍ×ÊÔ´£¬ËùÒÔ²»Òª²»±ØÒªµÄ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó¡£Òª¼Çס£¬Í¨µÀÊǺÜÕ­µÄ£¬Ó¦¸ÃÓÃÀ´´«ÊäÿҳÐèÒªµÄ×îÉÙÊý¾Ý¡£ÐèҪѧϰʹÓÃÊý¾Ý¿âÌṩµÄËùÓй¦ÄÜ¡£SQL·Ç³£Éó¤ÅÅÐò¡¢¹ýÂË¡¢Ô¼Êø¡¢¼ÆÊýºÍ·Ö×顪¡ªÊ¹ÓÃPHPʵÏÖÕâЩ¹¦ÄÜËÙ¶ÈÒªÂý¡£

  • PHP²»ÄÜÔÚurlÖд«µÝ±äÁ¿

    2007-01-04 08:52:35

    È«¾Ö±äÁ¿Ã»Óпª
    PHPÈ«¾Ö±äÁ¿×Ô¶¯ÊǹرյÄ

    ¿ÉÒÔʹÓã¬$_GET $_POST
    POST·½·¨´«¹ýÀ´µÄ¾ÍÊÇÔÚ $_POST Êý×éÖÐ.
    GET ·½·¨´«¹ýÀ´µÄ¾ÍÊÇÔÚ $_GET  Êý×éÖÐ.
    COOKIE ¾ÍÔÚ $_COOKIE,
    SESSION ¾ÍÔÚ $_SESSION
  • PHPѧϰ±Ê¼Ç£¨Áù£©¡ª¡ª×ÔÌá½»

    2006-12-31 10:08:29

    ×ÔÌá½»ÊÇÖ¸ÔÚµ¥¸ö½Å±¾ÖаÑÒ»¸ö»ò¶à¸ö±íµ¥ÒÔ¼°±íµ¥´¦Àí³ÌÐò×éºÏÔÚÒ»Æð£¬Ê¹ÓÃHTMLµÄFORM±ê×¼Ò»´Î»ò¶à´Î°ÑÊý¾ÝÌá½»¸ø¸Ã½Å±¾¡£¿ÉÒÔÓÃ×î¼òµ¥µÄ·½·¨ÊµÏÖ×ÔÌá½»£ºÔÚFORM±ê¼ÇÖаÑ×Ô¼ºÖ¸¶¨ÎªACTIONÄ¿±ê£¬Èç

        <FORM METHOD=¡±POST¡± ACTION=¡±myself.php¡±>

     

    »òÕßʹÓÃPHPÄÚÖõĶÀÌØÌØÐÔ£º

    <FORM METHOD=¡±POST¡± ACTION=¡±<?php print(¡°$PHP_SELF¡±);  ?>¡±>

     

    Ìáʾ£ºËäÈ»¿ÉÒÔÑ¡ÔñֻʹÓÃÎļþµÄ·¾¶Ãû£¬µ«ÊÇÔÚUNIXÖÐÄÚÖõıäÁ¿$PHP_SELF¸üºÃ¡£Èç¹ûÖØÐÂÃüÃû»òÕßÒƶ¯Îļþ£¨²»±Ø˵£¬ÒªÒƵ½ÄÜʹÓÃPHPµÄĿ¼ÖУ©£¬ÄÇôÄܼÌÐøÕýÈ·µØ´¦ÀíÎļþ¡£ÁíÒ»·½Ã棬ҲÓйØÓÚÕâ¸öÔ¤¶¨ÒåµÄ±äÁ¿ÓÐÎÊÌâµÄ±¨¸æ¡£

           ×ÔÌá½»µÄ×î´óÓŵãÊÇ£¬¿ÉÒÔÔÚHTML±íµ¥Öн¨Á¢¸ü±ê×¼µÄÂß¼­¡£ÀýÈ磬ÒÀÀµÓÚÐγÉÇëÇóµÄµØµãÏÔʾÉÔ΢²»Í¬µÄ±íµ¥¡£»òÕßÓÐʱÓöµ½ÕâÑùµÄÇé¿ö£¬HTML±íµ¥Ö»ÄÜÓÐÒ»¸öACTIONÊôÐÔÄ¿±ê¡ª¡ªÒâζ×Åÿ¸ö±íµ¥Ö»ÄÜ°ÑÊý¾Ý·¢Ë͸øÒ»¸ö±íµ¥´¦Àí³ÌÐò¡£¶øʹÓÃPHP£¬¿ÉÒÔ¸ù¾Ý·ÃÎÊÕß×Ô¼ºÉèÖõÄÊ×Ñ¡ÏîÓвî±ðµÄ´¦Àí±íµ¥¡£

           ×ÔÌá½»ÓÐʱÐèÒª¿¼ÂǸüÇ¿´óµÄ¹¦ÄܺÍÁé»îÐÔ£¬Òò´ËÊÂÇé¾Í±äµÃÓе㸴ÔÓÁË£¬Òò´ËÐèÒªÌáµ½¼¸¸ö¼¼ÇÉ£º

           ×îÓÐÓõļ¼ÇÉÊÇÒþ²ØµÄ½×¶Î±äÁ¿¡£ÕâÑùÄܸú×Ù³ö±íµ¥°ÑÖµÌá½»¸ø×Ô¼º¶àÉٴΣ¬´Ó¶øµÃ³öÒѾ­µ½Á˶à½×¶Î½ø³ÌµÄÄĸö½×¶Î¡£³ÌÐòÔ±ÐèҪʹÓÃÕâÑùµÄ±äÁ¿£¨Ëü¿ÉÒÔ±»ÃüÃûΪÈκÎÄÚÈÝ£¬Ê¹ÓÃ×Ö·û´®ÀàÐͱÈÕûÊýÀàÐͺã©Ö¸Ê¾³öÊÇ·ñÓ¦¸Ãµ÷ÓÃ±íµ¥ºÍ/»ò½Å±¾µÄ±íµ¥´¦Àí³ÌÐò²¿·Ö¡£

           ×ÔÌá½»±íµ¥µÄÁíÒ»¸öÎÊÌâÊǵ¼º½¡£ÔÚ´«Í³µÄHTML±íµ¥ÖУ¬µ¼º½ÊÇÑϸñµ¥ÏòµÄ£º´Ó±íµ¥µ½´¦Àí³ÌÐò£¬ÔÙµ½Éè¼ÆÕ߹涨µÄÈκ½É豸£¨Èç¹ûÓУ©¡£µ«ÊÇ×ÔÌá½»µÄ±íµ¥²»ÐèÒª×ñÊØÕâ¸ö¹æÔò¡£ÔÚÿ¸öµ¥¶ÀµÄʵÀýÖУ¬ÐèҪȷ¶¨£º

    l         Óû§ÊÇ·ñ¿ÉÒÔ¶à´ÎÖØÐÂÌύȫ²¿»ò²¿·Ö±íµ¥

    l         ÊÇ·ñÓÉÓû§¾ö¶¨ºÎʱÒƶ¯±íµ¥£¬»¹ÊÇ±íµ¥×Ô¶¯Ê¹Óû§Òƶ¯

    l         ÒÔÒþ²Ø·½Ê½»¹ÊÇÒÔÏÔʾ·½Ê½°Ñ±äÁ¿´«µÝ¸øÏÂÒ»Ò³

    l         ÊÇ·ñ¿ØÖÆÓû§ÏÂÒ»²½×ªµ½ÄÇÀï»ò¸øÓû§¶àÖÖÑ¡Ôñ

    ÕâЩÎÊÌâµÄ´ð°¸½«È·¶¨ÊÇ·ñÐèÒª¿ØÖÆ¡¢ÐèÒªÁíÒ»¸ö±íµ¥¡¢ÐèÒª¼òµ¥µÄÁ´½Ó»¹ÊǶà¸öÁ´½Ó¡£

     

    Ìáʾ£ºÎÞÂÛ¾ö¶¨ÈçºÎ½øÐе¼º½£¬¶¼Òª¼Çס£¬ÒªÌṩ´óÁ¿Îı¾£¬Çå³ýµØ½âÊÍÔÚÿһ²½½«Òª·¢ÉúʲôÊÂÇé¡£ÒòΪPHP¶Ô±íµ¥¸ø³öÁËÈç´ËµÄÁé»îÐÔ£¬Òò´ËÐÂÓû§µÄĬÈÏÆÚÍûÖµ¿ÉÄÜ»á´íÎ󣬽áÊøʱ²»È·¶¨ÊÇ·ñÄܽáÊø±íµ¥µÄÈÎÎñ¡£

  • PHPѧϰ±Ê¼Ç£¨Î壩¡ª¡ªÖÆ×÷±íµ¥µÄPHPÌØÊâÒªµã

    2006-12-30 09:17:44

    l         ¶ÔÓÚÿ¸öÊý¾ÝÏîÔªËØ£¨INPUT¡¢SELECT¡¢TEXTAREAµÈµÈ£©Ò»¶¨ÒªÊ¹ÓÃNAME¡£ÕâЩNAMEÊôÐÔ½«ÊÇPHP±äÁ¿µÄÃû³Æ¡£Èç¹ûËù¼û¼´ËùµÃʽµÄ±à¼­Æ÷²»ÔÊÐíÕâÑù×ö£¬ÔòÐèÒª¼Çס£¬ÒªÊÖ¹¤Ìí¼ÓÕâЩNAMEÊôÐÔ¡£

    l         ±íµ¥µÄNAME²»ÐèÒªºÍÏàÓ¦µÄÊý¾Ý¿â×Ö¶ÎÃû³ÆÒ»Ñù£¬µ«ÊÇÆðÒ»ÑùµÄÃû³ÆÊÇÒ»¸öºÃ°ì·¨¡£

    l         Óû§¿ÉÒÔ£¨³£³£ÊÇÓ¦¸Ã£©Ö¸¶¨VALUE£¬¶ø²»ÊÇÈÃPHPʹÓÃĬÈÏÖµ¡£Èç¹û¿ÉÄܵĻ°£¬°Ñÿ¸öÎı¾ÖµÌæ»»³ÉÒ»¸öÊý×ÖÖµ£¬ÕâÊÇÒòΪÊý¾Ý¿âÆ¥Åä×Ö·û´®±ÈÆ¥ÅäÕûÊýÂýµÃ¶à¡£

    l         Òª¼Çס£¬Ê¹ÓÃHIDDENÊý¾ÝÏîÔªËØ¿ÉÒÔÔÚ±íµ¥£¨»òÒ³£©Ö®¼ä´«µÝÒþ²Ø±äÁ¿¡£

    l         Òª¼Çס£¬¿ÉÒÔ´«µÝÒ»¸öÊý×éÖеĶà¸ö±äÁ¿£¬µ«ÊÇÐèҪ֪ͨÓû§ÕâÊÇ¿ÉÄÜ·¢ÉúµÄÊÂÇé¡£

  • Client does not support authentication protocol

    2006-12-29 08:53:01

    phpÁ¬mysqlʱ±¨´í£º

    Client does not support authentication protocol

    ½â¾ö·½·¨£º

    MYSQL °ïÖú£º
    A.2.3 Client does not support authentication protocol
    MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients. If you upgrade the server to 4.1, attempts to connect to it with an older client may fail with the following message:

    shell> mysql
    Client does not support authentication protocol requested
    by server; consider upgrading MySQL client

    To solve this problem, you should use one of the following approaches:

    Upgrade all client programs to use a 4.1.1 or newer client library.
    When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
    Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
    mysql> SET PASSWORD FOR
        -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

    Alternatively, use UPDATE and FLUSH PRIVILEGES:
    mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
        -> WHERE Host = 'some_host' AND User = 'some_user';
    mysql> FLUSH PRIVILEGES;

    Substitute the password you want to use for ``newpwd'' in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.
    Tell the server to use the older password hashing algorithm:
    Start mysqld with the --old-passwords option.
    Assign an old-format password to each account that has had its password updated to the longer 4.1 format. You can identify these accounts with the following query:
    mysql> SELECT Host, User, Password FROM mysql.user
        -> WHERE LENGTH(Password) > 16;

    For each account record displayed by the query, use the Host and User values and assign a password using the OLD_PASSWORD() function and either SET PASSWORD or UPDATE, as described earlier.
    For additional background on password hashing and authentication, see section 5.5.9 Password Hashing in MySQL 4.1.


    Àý×Ó£º
    SET PASSWORD FOR Óû§Ãû@localhost = OLD_PASSWORD('ÃÜÂë');

  • PHPѧϰ±Ê¼Ç£¨ËÄ£©¡ª¡ª»ù±¾µÄPHP´íÎó

    2006-12-28 09:08:03

    1.ºÍ°²×°ÓйصÄÎÊÌâ

     

     

    l         ÏÖÏó£ºÎļþÄÚÈÝÏÔʾÔÚä¯ÀÀÆ÷´°¿ÚÉÏ

    ûÓ줻îPHPÒýÇ档ȷ±£×Ô¼ºÈ·ÊµÊÇͨ¹ýµ÷ÓÃhttpd¶ø²»ÊÇͨ¹ýÎļþϵͳ·ÃÎÊÕ¾µã¡£

     

    l         ÏÖÏó£ºHTTP²»ÏÔʾÎı¾»òä¯ÀÀÆ÷Ìáʾ±£´æÎļþ»ò·ÃÎÊÍⲿÎļþ¿â

    ûÓÐÕýÈ·µØµ÷ÓÃPHPÒýÇæ¡£Ò»¸ö×î³£¼ûµÄÔ­ÒòÊÇûÓÐÖ¸¶¨Ï£ÍûPHPʶ±ðµÄËùÓÐÎļþÀ©Õ¹Ãû£¬ÖÁÉÙûÓÐÖ¸¶¨Õâ¸öĿ¼ÏµÄÀ©Õ¹Ãû¡£µÚ¶þ¸ö×î³£¼ûµÄÔ­ÒòÊÇphp.iniÎļþλÓÚ´íÎóµÄĿ¼»òÕß´íÎóµÄÅäÖÃÖ¸Áî¡£

    Èç¹ûÔÚWEBä¯ÀÀÆ÷Öп´µ½PHP´úÂë²¢ÇÒ°²×°¿É¿¿£¬ÔòÎÊÌâ¿ÉÄܳöÔÚȱÉÙ±ê¼ÇÉÏ¡£

     

    l         ÏÖÏó£ºÃ»ÓÐÕÒµ½·þÎñÆ÷»òÖ÷»ú/Ò³ÃæÎÞ·¨ÏÔʾ

    ûÓÐÕÒµ½·þÎñÆ÷£¬¿ÉÄÜÊÇDNS»òWEB·þÎñÆ÷ÅäÖÃÎÊÌâ¡£

    Èç¹ûÄÜͨ¹ýIPµØÖ··ÃÎÊÕ¾µã£¬¶øͨ¹ýÓòÃû²»ÄÜ£¬ÔòÎÊÌâºÜ¿ÉÄܺÍDNSÓйء£Ò²ÐíDNS±ðÃû»¹Ã»Óд«±éinternet¡£¼´Ê¹ÔÚÕ¾µã½¨Á¢Ò»¶Îʱ¼äÒÔºó£¬Õâ¸öÎÊÌâҲż¶û»á·¢Éú£¬»òÕßÊÇÒòΪDNS·þÎñÆ÷³öÁËÎÊÌâ¶øÓÖûÓÐÓÐЧµÄ¸¨ÖúDNSµÄ·þÎñÆ÷£¬»òÕßÊÇÒòΪ±¾µØinternetÌõ¼þµÄÎÊÌâ¡£

    Èç¹û²»ÄÜͨ¹ýIPµØÖ··ÃÎÊÕ¾µã£¬ºÜ¿ÉÄÜÊÇûÓгɹ¦µØ°ÑIPµØÖ·°ó¶¨µ½ÍøÂç½Ó¿Ú£¬»òÕßûÓгɹ¦µØÅäÖÃhttpd´¦Àíij¸öÓòµÄÇëÇó¡£

     

    2.ÏÔʾÎÊÌâ

     

    ÎÊÌâÊÇPHP±¾ÉíûÓб¨¸æ³ö´í£¬µ«ÊÇÓû§¿´µ½µÄ½á¹û²»ÊÇÔ¤ÆÚµÄÄÚÈÝ¡£

     

    l         ÏÖÏó£ºÍêȫΪ¿ÕµÄÒ³Ãæ

    ¿Õҳͨ³£ÊÇHTMLÎÊÌ⣬¶ø²»ÊÇPHP±¾ÉíµÄÎÊÌ⣨³ý·ÇÔÚʹÓÃPHPÉú³ÉHTMLµÄ·¶Î§ÄÚ£©Èç¹û²»Ê¹ÓÃPHPµÄ×î´ó·ç¸ñ£¨»»¾ä»°Ëµ£¬Èç¹û½Å±¾µÄÈκβ¿·ÖûÓÐÊ×ÏȾ­¹ýÔ¤´¦Àí¾ÍÊʺϿÉÏÔʾµÄ£©£¬¼¸ºõ¿ÉÒԿ϶¨ÎÊÌâ³ö×ÔHTMLÄÚ¡£ËùÒÔÓ¦¸ÃÊ×ÏÈÊÔÊÔͨ³£µ÷ÊÔHTMLµÄ·½·¨¡£

    ×¢Ò⣺һ°ãÇé¿öÏ£¬µ±ÃæÁÙÁîÈËÃÔ»óµÄä¯ÀÀÆ÷Êä³öÎÊÌâʱ£¬Ò»¸ö×îºÃµÄµ÷ÊÔ¹¤¾ßʱ²é¿´ä¯ÀÀÆ÷ÊÔͼÏÔʾµÄHTMLÔ´´úÂë¡£ËùÓеÄä¯ÀÀÆ÷¶¼ÓÐһЩ²é¿´Ô´ÎļþµÄÃüÁî¡£ÀýÈ磬ÔÚInternet ExplorerÖУ¬¸ÃÃüÁîʱ¡°²é¿´¡±²Ëµ¥Ïµġ°Ô´Îļþ¡±¡£

    ÈôʹÓô¿Îı¾±à¼­Æ÷±àдÎļþ£¬¾Í¿ìËٵؼì²éÒ»±é£¬È·±£Ã»ÓжªÊ§ÖÁ¹ØÖØÒªµÄÄÚÈÝ£¬½áÊø±ê¼Ç</TABLE>»ò</FORM>¡£Èç¹ûÖΰ²Ä³¸öʱÆÚʹÓÃËù¼û¼´ËùµÃʽµÄ±à¼­Æ÷£¬ÔòÎÊÌâºÜ¿ÉÄÜʱ¶àдÁËijÖÖÔªËØ¡£

    ͨ¹ý´Ó¿Í»§¶Ë£¨ÓÈÆäʱÈç¹ûʹÓÃ×î´óPHP·ç¸ñ£©»ò´Ó²»Í¬µÄä¯ÀÀÆ÷²é¿´HTMLÔ´Îļþ£¬ÒԵõ½ÓÐÆô·¢ÐÔµÄÐÅÏ¢¡£

    Èç¹ûûÓз¢ÏÖHTMLÓÐÈκδíÎó£¨ÓÈÆäʱÈç¹ûʹÓÃPHPµÄ×î´ó·ç¸ñ£©£¬ÔòʱPHPÄ£¿é¸ù±¾Ã»Æð×÷Óá£Í¨¹ýä¯ÀÀͬһĿ¼ÖеIJ»Í¬Ò³Ã棬²âÊÔÒÔÇ°ºËʵ¹ýµÄÄÚÈÝÊÇ·ñÕýÈ·µØ±»PHP´¦Àí¡£

     

    l         ÏÖÏ󣺲»ÍêÕû»ò²»ÊÇÔ¤ÆÚµÄÒ³Ãæ

    ÕâЩÎÊÌâͨ³£³ö×Խű¾µÄHTML²¿·Ö£¬Ó¦¸Ã°´ÒÔǰ˵Ã÷µÄ·½Ê½½øÐе÷ÊÔ¡£

     

    l         ÏÖÏó£ºPHP´úÂëÏÔʾÔÚWEBä¯ÀÀÆ÷ÖÐ

    ºÜ¿ÉÄÜÔÚij¸öµØ·½ºöÂÔÁËPHPÆðʼ±ê¼Ç£¨¼ÙÉèÒѾ­³É¹¦µØÔËÐÐÁËPHP£¬Ê¹ÓÃÁË°²×°Ê±ÉèÖõÄÕýÈ·±ê¼Ç¡££©

     

    3.ÔØÈëÒ³Ãæʧ°Ü

     

    µ±PHP²»ÄÜÕÒµ½ÒªÇóÔØÈëµÄÎļþʱ£¬»á³öÏÖÁ½ÖÖ´íÎó¡£

     

    l         ÏÖÏ󣺲»ÄÜÕÒµ½Îļþ

    Èç¹ûä¯ÀÀÆ÷²»ÄÜÕÒµ½ÒѾ­´´½¨µÄPHPÒ³£¬²¢ÇÒ×î½üÒѾ­°²×°ÁËPHP£¬ÏÈ¿´¿´±¾ÕµĵÚÒ»½Ú¡£Èç¹ûÔÚÔØÈëÆäËûPHPÎļþ¶øûÓÐÎÊÌâʱ¿´µ½ÕâÌõÏûÏ¢£¬ÔòºÜ¿ÉÄÜÖ»ÊÇÆ´´íÁËÎļþÃû»ò·¾¶¡£

     

    l         ÏÖÏ󣺴ò¿ª±»°üº¬µÄÎļþʧ°Ü

    ÔÚPHPµÄWindows NT/IIS  °æ±¾ÖУ¬ÓÐʱÄÜ¿´µ½ÕâÑùµÄÏûÏ¢£º

    Warning Failed opening ¡®C:\InetPub\wwwroot\asdf.php¡¯ for inclusion (include_path=¡¯¡¯) in [no active file ] on line 0

     

    ÕâÊÇ¡°ÕÒ²»µ½Îļþ¡±µÄNT°æ±¾¡ª¡ª¼´£¬PHP²»ÄÜÔØÈëÎļþµÄµÚÒ»ÐУ¬ÕâÊÇÒòΪûÓпÉÓõÄÎļþ¡£Ã»ÓпÉÓõÄÎļþÊÇÒòΪûÕÒµ½ÓиÃÃû³ÆµÄÎļþ¡£

    ÔÚNTÏÂÈç¹ûÊÔͼÔØÈëûÓÐÏàӦȨÏÞµÄÎļþ£¬Ò²¿ÉÄÜ¿´µ½ÕâÌõÏûÏ¢¡£

     

    4.½âÎö´íÎó

    ×î³£¼ûµÄ´íÎóÖÖÀàÓÐÊäÈë´í»òPHP´úÂëµÄÓï·¨´í£¬Õâ»áʹPHP½âÎöÒýÇæ·Ö²»Çå¡£

     

    l         ÏÖÏ󣺽âÎö´íÎóÏûÏ¢

    ËäÈ»ÒýÆð½âÎöÎÊÌâµÄÔ­ÒòÓкܶ࣬µ«ÊÇ´íÎóÏÖÏ󼸺õÒ»Ñù£º½âÎö´íÁË¿ÉÄÜÓÐÎÊÌâµÄ´úÂëÐеÄÐкš£

     

    l         ½âÎö´íÎóµÄÒ»°ãÔ­Òò£ºÈ±ÉÙ·ÖºÅ

    Èç¹ûÿ¸öPHPÖ¸ÁîûÓÐÔÚºÏÊʵĵط½Ó÷ֺŽáÊø£¬½«»áµ¼Ö½âÎö´íÎó¡£

           ×¢Ò⣺ÕæÕýÒýÆð´íÎóµÄµØ·½¿ÉÄܾÍÔÚPHPÌá³öµÄÒ»ÐУ¬»òÕßÔÚÕâÒ»ÐÐÇ°Ã棬µ«ÊÇ´ÓÀ´²»»áÔÚÕâÐкóÃæµÄ´úÂëÖС£

     

    l         ½âÎö´íÎóµÄÒ»°ãÔ­Òò£ºÃ»ÓÐ$ºÅ

    ÁíÒ»¸ö·Ç³£³£¼ûµÄÎÊÌâÊÇȱÉÙ±êʶ±äÁ¿ÃûµÄ$ºÅ¡£Èç¹ûÔÚ³õʼµÄ±äÁ¿¸³ÖµÖÐȱÉÙ$ºÅ£¬Ôò»áµÃµ½½âÎö´íÎó¡£µ«ÊÇ£¬²»ÊÇÕâÑù£¬¶øÊÇÔÚÊä³ö±äÁ¿Ê±È±ÉÙ$ºÅ£¬ÔòPHP²»»áÖ»ÊdzöÓнâÎö´íÎó¡£

     

    l         ½âÎö´íÎóµÄÒ»°ãÔ­Òò£ºÄ£Ê½ÎÊÌâ

    ÁíһϵÁÐÎÊÌâÆðÒòÓÚ´íÎóµØ±ä»»PHPģʽ¡£

    Èç¹ûûÓÐÕýÈ·µØ½áÊøPHP´úÂë¿é£¬Ôò½«µ¼Ö½âÎö´íÎó¡£

           ÕâÖÖģʽÎÊÌâÔڽ϶̵ÄPHP´úÂë¿éÖкܳ£¼û¡£Ïà·´£¬Èç¹ûûÓÐÕýÈ·µØ¿ªÊ¼PHP´úÂë¿é£¬ÔòʣϵĴúÂë¿éÖ»²»¹ý»áÏÔʾ³ÉHTML¡£

           ÉÔ΢¸ü¸´ÔÓµÄÎÊÌâÊÇʹÓá°×îС¡±PHP·ç¸ñÔì³ÉµÄ£¬ÕâÖÖ·ç¸ñ±ØÐëƵ·±µØתÈë»òת³öHTMLģʽ¡£

           ÁíÒ»¸öºÜ³£¼ûµÄʵÀýÊǰѽ϶̵ĴúÂë¿éºÍתÈëת³öHTMLµÄ´úÂë¿é×éºÏÆðÀ´¡£

           ÕâЩÀý×Ó˵Ã÷£¬Óû§ºÜÈÝÒ×ÔÚÓкܶàС¶øÖØÒªµÄ·ûºÅµÄÒ³ÃæÉÏÍü¼ÇÒ»¸öÔªËØ¡£Ê¹ÓúõÄÎı¾±à¼­Æ÷£¬»òÕßÊ×ÏÈÍê³ÉºÍ²âÊÔHTML£¬È»ºóÔÙÌí¼ÓPHP£¬ÕâÑùÄܼõÉÙÕâÀà´íÎó¡£

     

    l         ½âÎö´íÎóµÄÒ»°ãÔ­Òò£º±»×ªÒåµÄÒýºÅ

    ÁíÒ»ÖÖ½âÎö´íÎóÊÇ¡°×î´ó¡±PHPģʽµÄÌØÐÔ£º±»×ªÒåµÄÒýºÅ¡£

           ÐèҪתÒåµÄÒýºÅÇ°Ãæ±»´íÎóµÄʹÓÃб¸Ë¶ø²»ÊÇ·´Ð±¸Ë£¬»òÕßÊÇÍü¼ÇÁË·´Ð±¸Ë¡£

     

    l         ½âÎö´íÎóµÄÒ»°ãÔ­Òò£ºÆäËû½âÎö´íÎóµÄÔ­Òò

    ÈκÎʹPHPÓï¾ä±äÐεĴíÎ󶼻áÁî½âÎöÒýÇæÃԻ󣬰üÀ¨Ã»ÓнáÊøµÄÔ²À¨ºÅ¡¢Ã»ÓнáÊøµÄ¼âÀ¨ºÅ¡¢Ã»ÓнáÊøµÄ×Ö·û´®¡¢Ã»ÓвÎÊýµÄÔËËã·û¡¢Ã»ÓÐÔ²À¨ºÅµÄ¿ØÖƽṹ²âÊÔ£¬µÈµÈ¡£ÓÐʱ½âÎö´íÎóÏûÏ¢°üÀ¨µÄÓï¾ä»áÖ¸Ã÷ÕýÔÚÑ°ÕÒʲôµ«ÊÇûÓÐÕÒµ½£¬ÕâÊÇÓÐÓõÄÏßË÷¡£Èç¹û½âÎö´íÎóÏûÏ¢Ö¸³öµÄ´úÂëÐÐÊÇÎļþµÄ×îºóÒ»ÐУ¬Ôòͨ³£Òâζ×ÅʹÓÃÁËijÖÖÆðʼ·ûºÅ£¨ÒýºÅ¡¢Ô²À¨ºÅ¡¢´óÀ¨ºÅ£©£¬µ«ÊÇȱÉÙ½áÊø·ûºÅ£¬PHP¾ÍÒ»Ö±ÕÒµ½Ä©Î²¡£

     

    5.ÎļþȨÏÞ

    ´ó¶àÊý²Ù×÷ϵͳÓÐһЩÎļþºÍĿ¼ȨÏÞµÄģʽ£¬Ö¸¶¨ÄÄЩÓû§¶ÔÄÄЩÎļþÓÐÄÄÖÖ·ÃÎÊ·½Ê½¡£WEB·þÎñÆ÷×÷ΪÕâÖÖϵͳϵÄij¸öϵͳÔËÐУ¬ËùÒÔÒ»¶¨Òª²é¿´ËùÉæ¼°µÄÈκÎÎļþµÄȨÏÞ£¬°üÀ¨HTMLºÍPHPÔ´Îļþ¡£

     

    l         ÏÖÏó£ºHTTP error 403

    µ±ä¯ÀÀÆ÷Ò³ÃæÏÔʾ³öÏÖ403´íÎóʱ£¬Òâζ×ÅÎļþȨÏÞ²»ÕýÈ·¡£Ò»Ð©ä¯ÀÀÆ÷²»»áÌáµ½´íÎó´úÂ룬µ«ÊÇ»áÖ¸³öûÓÐȨÏÞ·ÃÎÊÖ¸¶¨µÄWEBÒ³¡£

           ×î³£¼ûµÄÔ­ÒòÊÇûÓаѸÃĿ¼ÉèÖóÉÍêÈ«¿ÉÖ´ÐУ¨UNIX£©»òÆô¶¯½Å±¾Ö´ÐУ¨Windows£©¡£PHP½Å±¾¿ÉÓÃÔÚ²»Í¬ÓÚ¿ª·¢Õß×Ô¼ºµÄIDµÄÓû§IDÏÂÔËÐС£ÔÚUNIXÏ£¬PHPͨ³£¼Ì³Ð¡°nobody¡±UID£¬Ëü£¨ºÜ¿ÉÄÜ£©·Ç³£ÊÜÏÞÓÚHTTP·þÎñ¡£ÔÚWINDOWSÏ£¬Ã¿¸öHTTPÇëÇó°´ÄäÃûÓû§µÇ¼¡£

     

    l         ȱÉÙ°üº¬Îļþ

    ³ýÁËÔØÈ붥¼¶µÄÔ´ÎļþÒÔÍ⣬PHP»¹ÐèÒªÄÜÔØÈëͨ¹ýinclude()»òrequire()ÔØÈëµÄÈκÎÎļþ¡£

     

    l         ÏÖÏó£ºÓйذüº¬ÎļþµÄ¾¯¸æ

    ÎÊÌâÊÇ£¬Ôڽű¾µÄij¸öµØ·½ÒªÇó°üº¬Ò»¸öÎļþ£¬¶øPHPÕÒ²»µ½¸ÃÎļþ¡£¼ì²é·¾¶ÊÇ·ñÕýÈ·¡£»¹¿ÉÄÜÊÇÓÉÓÚÇø·Ö´óСд»òÆäËûÊäÈëµÄÎÊÌâ¡£

    Èç¹û½Å±¾½Å±¾ÊÔͼ°üº¬ÔÚÁíÒ»¸öĿ¼ÖеÄÎļþ£¬¶øPHPÓû§Ã»ÓÐÓµÓжԸÃĿ¼µÄÏàӦȨÏÞ£¬ÕâÑùÒ²»áµÃµ½ÕâÌõÏûÏ¢¡£Í¨³£±ØÐë°ÑĿ¼ָ¶¨ÎªÄܱ»WEB·þÎñÆ÷Óû§£¨ÔÚUNIXϳ£³£ÊÇ¡°nobody¡±£©¿É¶ÁºÍ¿ÉÖ´ÐУ¬»òÕßͨ³£ÉèÖóÉÍêÈ«¿É¶Á/¿ÉÖ´ÐУ¨ÈçÔÚUNIXÏÂÊÇ755£©¡£µ±È»Îļþ±ØÐëÍêÈ«¿É¶Á£¨Í¨³£ÊÇ744£©¡£

     

    6.δ±»É趨µÄ±äÁ¿

    Íü¼Ç¸ø±äÁ¿¸³Öµ²»»áÖ±½Óµ¼Ö´íÎ󡪡ª»òÕßÊä³ö½á¹û²»ÕýÈ·£¬»òÕßÓÉÓÚ±äÁ¿Ã»ÓиÃÓеÄÖµ£¬ºóÃæµÄÓï¾ä»á±¨´í£¨Èç¹û¸üÔ¸ÒâÏÔʾ¾¯¸æÏûÏ¢£¬¿ÉÒÔÓÃerror_reporting(15)°Ñ´íÎ󱨸漶±ðÉèÖóÉ15£¬»òÕßÓÃerror_reporting(E_ALL)£©¡£

     

    l         ÏÖÏ󣺱äÁ¿Ã»ÓгöÏÖÔÚ´òÓ¡×Ö·û´®ÖÐ

    ÎÊÌâÊÇ£º±äÁ¿´ÓÀ´Ã»Óб»¸³¹ýÖµ¡£

     

    l         ÏÖÏó£ºÊý×Ö±äÁ¿³öºõÒâÁÏΪ0

    ËäÈ»ÔÚÕâÖÖ´íÎóÏÖÏóÖпÉÄÜÊÇÊýѧÉϵĴíÎó»òÕßÇú½âÁ˽á¹û£¬µ«ÊǸü¿ÉÄÜÊÇʵ¼ÊÉÏ»¹Ã»Óб»¸³ÖµµÄ±äÁ¿±»ÈÏΪ¸³¹ýÖµ¡£

     

    l         δ±»É趨µÄ±äÁ¿ÓкÎ×÷ÓÃ

    Ò»°ãÇé¿öÏ£¬ÔÚÊý×ÖÉÏÏÂÎÄÖУ¬Î´±»É趨µÄ±äÁ¿±»½âÊͳÉ0£¬ÔÚ×Ö·û´®ÉÏÏÂÎÄÖб»½âÊͳɡ°¡±£¬ÔÚbooleanÉÏÏÂÎÄÖб»½âÊͳÉFALSE£¬ÔÚÊý×éÉÏÏÂÎÄÖб»½âÊͳɿÕÊý×é¡£

     

    l         ´óСдÎÊÌâ

    ÔÚPHPÖеıäÁ¿ÊÇÇø·Ö´óСдµÄ¡£

     

    l         ·¶Î§ÎÊÌâ

    ֻҪûÓÐÉæ¼°º¯Êý¶¨Ò壬PHP±äÁ¿µÄ·¶Î§¾ÍºÜ¼òµ¥£º¸øÒ»¸ö±äÁ¿¸³Öµ£¬ËüµÄÖµ¾Í´Ó¸Ãµã¿ªÊ¼Ôڽű¾µÄÖ´Ðйý³ÌÖпÉÓã¨Ò»Ö±µ½±äÁ¿±»ÖØи³ÖµÎªÖ¹£©¡£µ«ÊÇ£¬ÔÚº¯ÊýÌåÄÚÄܱ»Ê¹ÓõÄΨһ±äÁ¿ÊÇÐβÎÒÔ¼°±»ÉùÃ÷δȫ¾Ö±äÁ¿µÄ±äÁ¿¡ª¡ªÈç¹ûº¯ÊýÌåÄÚÓб»±»É趨µÄ±äÁ¿£¬ÕâºÜ¿ÉÄÜÊdzÌÐòÔ±ÍüÁË×öʲô¡£

     

    Ìáʾ£ºÔÚ´íÎ󱨸æµÄĬÈÏÉèÖÃÏ£¬PHP²»»á¶ÔʹÓÃδ±»É趨µÄ±äÁ¿·¢³ö¾¯¸æ£¬µ«ÊÇ¿ÉÒÔ¸ü¸ÄÕâÖÖÉèÖã¬ÁÙʱ½øÐÐÕâÖָĶ¯³£³£ÊÇÕÒµ½Î´±»É趨µÄ±äÁ¿ÎÊÌâµÄ×î¿ì·½·¨¡£Ö»ÒªÔڽű¾Ç°Ãæ·ÅÖÃÈçÏÂÒ»ÐдúÂ룺

    error_reporting(15);

    PHP½«»áÔÚ³öÏÖδ±»É趨µÄ±äÁ¿Ê±¶¼·¢³ö¾¯¸æ£¬µ÷ÊÔ½áÊøºó¿ÉÒÔɾ³ý¸ÃÓï¾ä£¬»òÕßÃ÷È·µÄ·µ»ØĬÈÏÖµ£º

    error-reporting(7);

    ÁíÒ»ÖÖÑ¡ÔñÊÇ£¬Èç¹û×ÜÊÇÏ£Íû±»¾¯¸æ£¬¾ÍÒªÔÚphp.iniÎļþÖаÑĬÈϵĴíÎ󱨸漶±ð¸ü¸Ä³É15¡£

     

    7.º¯ÊýÎÊÌâ

     

    µ÷Óú¯Êý³öÏÖµÄÐí¶àÎÊÌⶼµÃµ½¡°fatal errors¡±£¨ÖÂÃü´íÎ󣩣¬Òâζ×ÅPHP·ÅÆú´¦Àí½Å±¾ÆäÓಿ·Ö¡£

     

    l         ÏÖÏ󣺵÷ÓÃ䶨ÒåµÄº¯Êýmy_function()

    ¿ÉÄÜÊÇÒòΪƴ´íÁ˺¯ÊýµÄÃû³Æ£¬»òÕßÊÇÒòΪÓû§ÒÅ©Á˺¯Êý¶¨Òå¡£Èç¹ûʹÓÃinclude/require°üº¬Îļþ£¬ÔØÈëÓû§¶¨ÒåµÄº¯Êý£¬È·±£ÔØÈëÁËÕýÈ·µÄÎļþ¡£

    Èç¹ûÎÊÌâÉæ¼°Ï൱רҵµÄÄÚÖú¯Êý£¬¿ÉÄÜÊÇÔÚ°²×°PHPʱûÓÐÆôÓÃÏà¹ØµÄº¯Êý¿â¡£

     

    l         ÏÖÏ󣺵÷ÓÃ䶨ÒåµÄº¯Êý

    ÔÚÕâÖÖÇé¿öÏ£¬PHPÊÔͼµ÷ÓÃÉõÖÁ²»Ö¸µ¼º¯ÊýÃûµÄº¯Êý¡£Õâ×ÜÊÇÒòΪÓÐ$my_function()ÐÎʽµÄ´úÂ룬º¯ÊýÃû±¾ÉíÊÇÒ»¸ö±äÁ¿¡£³ý·ÇÓÐÒâʹÓÃPHPµÄ±äÁ¿£­º¯Êý£­ÃûÌØÐÔ£¬·ñÔòºÜ¿ÉÄÜżȻµØÔÚmy_function()µ÷ÓÃǰдÁË$ºÅ¡£ÒòΪ$my_funcitonÊÇδ±»É趨µÄ±äÁ¿£¬ËùÒÔPHP°ÑËü½âÊͳɿÕ×Ö·û´®¡ª¡ªËü²»ÊǶ¨Òå¹ýµÄº¯ÊýµÄÃû³Æ¡ª¡ªÕâ¾Í¸ø³öÁ˲»ÌṩÐÅÏ¢µÄ´íÎóÐÅÏ¢¡£

     

    l         ÏÖÏ󣺲»ÄÜÖØÐÂÉùÃ÷my_function()

    ÔÚ´úÂëµÄij¸öλÖÃÖظ´¶¨ÒåÁËmy_funciton()£¬PHP²»Ö§³ÖË«Öض¨Ò壬ȷ±£²»ÒªÊ¹ÓÃinclude¶à´ÎÔØÈëÓк¯Êý¶¨ÒåµÄͬһÎļþ¡£

     

     

    l         ÏÖÏ󣺴íÎóµÄ²ÎÊýÊýÄ¿

    ÔÚ´íÎóÏûÏ¢ÖÐÖ¸³öµÄº¯Êý±»µ÷ÓÃʱ£¬¸ø³öµÄ²ÎÊýÉÙÓÚ»ò¶àÓÚÓ¦¸Ã±»´¦À

  • GETÓëPOST·½·¨

    2006-12-26 09:37:10

    1.GET·½·¨

    GET·½·¨°Ñ²ÎÊý×÷Ϊͳһ×ÊԴָʾÆ÷£¨Uniform Resource Indicator£¬»òÕßÈËÃǸüÏ°¹ßÓÃͳһ×ÊÔ´¶¨Î»Æ÷£¬Uniform Resource Locator£¬»òURL£©²éѯ×Ö·û´®µÄÒ»²¿·Ö£¬´ÓÒ»¸öÒ³Ãæ´«µÝµ½ÁíÒ»¸öÒ³Ãæ¡£µ±ÓÃÓÚ±íµ¥´¦Àíʱ£¬GETÓÃÎʺÅ×÷Ϊ·Ö¸ô·û°Ñ±äÁ¿ÃûºÍÖµ¸½¼Ó¸øÔÚACTIONÊôÐÔÖÐÖ¸¶¨µÄURL£¬²¢°ÑËùÓÐÄÚÈÝÌá½»¸ø´¦Àí´úÀí¡£

    ±íµ¥´¦ÀíÖеÄGET·½·¨ÓÐÒ»¸öPOST·½·¨²»¾ß±¸µÄºÜ´óµÄÓŵ㣺Ëü´´½¨ÁËÒ»¸öÕæÕýеġ¢ÍêÈ«²»Í¬µÄURL²éѯ×Ö·û´®¡£ÕâÑù£¬Óû§ÏÖÔÚ¿ÉÒÔ°ÑÕâÒ»Ò³¼Ç×÷ÊéÇ©¡£´ÓʹÓÃPOST·½·¨µÄ±íµ¥µÃµ½µÄ½á¹ûÊDz»Äܱ»¼Ç×÷ÊéÇ©µÄ¡£

    GET·½·¨µÄȱµã£º

    l         GET·½·¨²»ÊʺÏÓÃÓڵǽ£¬ÒòΪÔÚ°ÑÓû§ÃûºÍÃÜÂë×÷Ϊ·ÃÎʹýµÄÒ³ÃæDZÔڵش洢ÔÚ¿Í»§ä¯ÀÀÆ÷ÄÚ´æÖÐʱ£¬ÔÚÆÁÄ»ÉÏÊÇÍêÈ«¿É¼ûµÄ¡£

    l         ÿ¸öGETÌá½»±»¼Ç¼ÔÚWEB·þÎñÆ÷ÈÕÖ¾ÖУ¬Êý¾Ý¼¯Ò²±»°üÀ¨ÔÚÄÚ¡£

    l         ÒòΪGET¸ø·þÎñÆ÷»·¾³±äÁ¿·ÖÅäÊý¾Ý£¬ËùÒÔURLµÄ³¤¶ÈÊܵ½ÏÞÖÆ¡£

     

    ¾¡¹ÜGET·½·¨ÈÔÈ»ÊÇ±íµ¥´¦ÀíµÄĬÈÏÑ¡Ïµ«ÊÇ£¬±ÊÕß¼«Á¦ÍƼöÖ»°ÑËüÓÃÓÚûÓг¤ÆÚ¸±×÷Óõĵط½¡£°ÑÁ½¸öÓŵãºÍÁ½¸öȱµã·ÅÔÚÒ»Æð¿¼ÂÇ£¬Ê¹ÓÃGET´¦Àí±íµ¥µÄ×îºÏÊʵÄÓÃ;ÊÇËÑË÷¿ò¡£³ý·ÇÆȲ»µÃÒѵÄÔ­ÒòʹÓÃGETÓÃÓÚ·ÇËÑË÷ÐÔÖÊµÄ±íµ¥´¦Àí³ÌÐò£¬·ñÔòʹÓÃPOST¡£

     

    ʹÓÃGET¸üºÃµÄ·½·¨£º

    ÔÚµ¼º½À¸µÄ³¬Á´½ÓÖУ¬Ìí¼Ó´úÂ룺

    <a href=¡±fleece.php?Name=alpaca¡±><b>alpaca</b></a>

     

    ×¢Ò⣬µ±±»µ¥»÷ʱ£¬µ¼º½À¸ÉϵÄÁ´½Ó±»ä¯ÀÀÆ÷´¦Àí£¬¾ÍºÃÏñÊÇÌá½»ÁËGETÒ»Ñù¡£

     

    2.POST·½·¨

    POSTÊǵ±½ñ¸üºÃµÄ±íµ¥´¦Àí·½·¨£¬ÓÈÆäÊʺÏÐèÒªµÃµ½³¤Æڵĸ±×÷ÓÃЧ¹ûµÄÇé¿ö£¬Èç¸øÊý¾Ý¿âÌí¼ÓÐÅÏ¢¡£µ±±íµ¥Êý¾Ý±»Ë͵½´¦Àí³ÌÐòʱ±»°üÀ¨ÔÚ±íµ¥ÌåÄÚ¡£Ìá½»µÄÊý¾Ý²»Í¬Ê±£¬ÔÚURLÖп´²»³öʲô±ä»¯¡£

     

    POST·½·¨ÓÐÒÔÏÂÕâЩÓŵ㣺

    l         Ëü±ÈGET¸ü°²È«£¬ÒòΪÔÚURL²éѯ×Ö·û´®¡¢·þÎñÆ÷ÈÕÖ¾ÖУ¬»òÕߣ¨Èç¹û²ÉÓÃÁËÔ¤·À´ëÊ©£©ÔÚÆÁÄ»ÉÏ´ÓÀ´¿´²»µ½Óû§ÊäÈëµÄÐÅÏ¢¡£

    l         ¶ÔÄܱ»´«µÝµÄÊý¾ÝµÄÊýÁ¿ÏÞÖÆ·Å¿íÁË£¨¶þǧ×Ö½Ú£¬¶ø²»ÊÇÁ½°Ù¶à¸ö×Ö·û£©¡£

    µ«ÊÇPOSTÒ²ÓÐһЩȱµã£º

    l         ½á¹û²»Äܱ»¼Ç×÷ÊéÇ©

    l         ¸Ã·½·¨ºÍijЩ·À»ðǽÉèÖò»¼æÈÝ£¬ÎªÁË°²È«£¬·À»ðǽҪȥµô±íµ¥Êý¾Ý

     

     

    Ö÷ÒªÓÐÈýÖÖ·½·¨ÓÃÓÚ´«µÝÐÅÏ¢£ºGET¡¢POST¡¢»òcookie¡£Ö÷ҪʹÓÃGET¹¹½¨¸´ÔÓµÄURL×Ö·û´®£¬ÓÃÓÚ¶¯Ì¬Õ¾µãµÄÄ£°å£¬²»±»ÍƼöÓÃÓÚ±íµ¥¡£POSTÊDZ»ÍƼöÓÃÓÚ±íµ¥µÄ·½·¨¡£

     

  • PHPѧϰ±Ê¼Ç£¨Èý£©¡ª¡ª³£Óú¯Êý

    2006-12-25 09:13:44

    1.PHPµÄ³£Óú¯ÊýÀàÐÍÓÐ

     

    l         ±äÁ¿ÀàÐͺ¯Êý

    l         ×Ö·û´®²Ù×÷º¯Êý

    l         Êý×é²Ù×÷º¯Êý

    l         ÊýѧÔËË㺯Êý

    l         ÈÕÆÚ¡¢Ê±¼äº¯Êý

    l         Îļþ¼ÓÔغ¯Êý

    l         Ŀ¼²Ù×÷º¯Êý

    l         Îļþ²Ù×÷º¯Êý

     

     

    2.ÀàÐÍת»»º¯Êý

     

    ÀàÐÍÇ¿ÖÆת»»º¯ÊýÓÃÓÚ½«Ò»ÖÖÊý¾ÝÀàÐÍת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ¡£

     

    l         double doubleval(mixed var)

    mixed var´ú±í¼òµ¥Êý¾ÝÀàÐÍ£¬°üÀ¨Êý×éºÍ¶ÔÏ󡣸ú¯Êý»á½«±äÁ¿Ç¿ÖÆת»»Îª¸¡µãÐÍ¡£

     

    l         int intval(mixed var,int [base])

    ¸Ãº¯Êý½«±äÁ¿Ç¿ÖÆת»»ÎªÕûÐÍ£¬int [base]ÊÇ¿ÉÑ¡²ÎÊý£¬±íʾÒÔºÎÖÖ½øλÖÆת»»ÎªÕûÊý¡£

     

    l         string strval(mixed var)

    ¸Ãº¯Êý½«±äÁ¿Ç¿ÖÆת»»Îª×Ö·û´®¡£

     

    ͨÓõÄÉ趨ÀàÐ͵ĺ¯ÊýÈçÏ£º

    l         int settype(mixed var,string type)

    µÚ2¸ö²ÎÊý¡°string type¡±Ö»ÄÜÊÇÒÔÏÂÖµÖ®Ò»£º¡°integer¡±¡¢¡°double¡±¡¢¡°string¡±¡¢¡°array¡±¡¢¡°object¡±¡£

    ¸Ãº¯Êý½«±äÁ¿varÇ¿ÖÆת»»Îªstring type ²ÎÊýÖÐËùÖ¸¶¨µÄÀàÐÍ£¬Èç¹û·µ»Ø³É¹¦£¬·µ»ØTure£¬·ñÔò·µ»ØFalse¡£

     

    3.ÅжÏÈ¡µÃÊý¾ÝÀàÐ͵ĺ¯Êý

     

     

    ÀàÐÍÅжϺ¯Êý

    l         is_int(mixed var)¡¢is_integer(mixed var)¡¢is_long(mixed var)

    l         is_double(mixed var)¡¢is_float(mixed var)¡¢is_real(mixed var)

    l         is_string(mixed var)

    l         is object(mixed var)

    ͬһÐÐÖÐÁгöµÄº¯ÊýµÄ¹¦Äܶ¼ÊÇÏàͬµÄ£¬ÕâЩº¯Êý·µ»ØÖµ¶¼ÊDz¼¶ûÐÍ£¬¼´Èç¹û²ÎÊýÀàÐÍÓ뺯ÊýÃûÀàÐÍÒ»Ö£¬Ôò·µ»ØTrue£¬·ñÔò·µ»ØFalse¡£

     

    ´ËÍ⣬»¹ÓÐÒ»¸öͨÓõÄÈ¡µÃ±äÁ¿ÀàÐ͵ĺ¯Êý£º

    l         string gettype(mixed var)

    ¸Ãº¯ÊýµÃµ½±äÁ¿varµÄÀàÐÍ£¬²¢·µ»ØÒ»¸ö×Ö·û´®£¬×Ö·û´®ÓÐÈçÏÂÈ¡Öµ£º¡°integer¡±¡¢¡°double¡±¡¢¡°string¡±¡¢¡°array¡±¡¢¡°object¡±¡¢¡°unknown type¡±£¬×îºóÒ»¸öÖµ±íʾÎÞ·¨Ê¶±ðµÄÀàÐÍ£¬±ÈÈç¿ÕÖµµÈ¡£

     

    4.ÆäËû±äÁ¿ÀàÐͲÙ×÷º¯Êý

    PHPÖл¹ÓÐÆäËûһЩÓÃÓÚ±äÁ¿ÀàÐͲÙ×÷µÄº¯Êý£¬ÀýÈ磺

    l         int empty(mixed var)

    Èç¹û±äÁ¿varÊÇÒ»¸ö·Ç0·Ç¿ÕµÄÖµ£¬º¯Êý·µ»ØFalse,·ñÔòº¯Êý·µ»ØTrue¡£

     

    l         int isset(mixed var)

    Èç¹û±äÁ¿varÒѾ­±»³õʼ»¯£¬isset()º¯Êý·µ»ØTrue£¬·ñÔò·µ»ØFalse¡£

     

    l         int unset(mixed var)

    È¡Ïû±äÁ¿µÄ³õʼ»¯£¬ÒÔºóÔÙÓõ½±äÁ¿varʱ£¬½«ÊÇÒ»¸öûÓгõʼ»¯µÄ±äÁ¿¡£

     

     

    5.¼òµ¥×Ö·û´®º¯Êý

     

    l         int strlen(string str)

    ´Ëº¯Êý·µ»Ø×Ö·û´®µÄ³¤¶È¡£

     

    l         string strtolower(string str)

    ´Ëº¯Êý¿ÉÒÔ½«strÖеÄ×Öĸȫ²¿»»³ÉСд×Öĸ

     

    l         string strtoupper(string str)

    ´Ëº¯Êý¿ÉÒÔ½«strÖеÄ×Öĸȫ²¿»»³É´óд×Öĸ¡£

     

    l         string chop(string str)

    ´Ëº¯Êý¿ÉÒÔ½«strβ²¿µÄ¿Õ¸ñÈ«²¿È¥µô

     

    l         string ltrim(string str)

    ´Ëº¯Êý¿ÉÒÔ½«strÍ·²¿µÄ¿Õ¸ñÈ«²¿È¥µô

     

    l         string trim(string str)

    ´Ëº¯Êý¿ÉÒÔ½«strÁ½Í·µÄ¿Õ¸ñÈ«²¿È¥µô

     

    l         string strrev(string str)

    ´Ëº¯ÊýµÄ×÷ÓÃÊǽ«²ÎÊýstrµ¹×ªÊä³ö¡£

     

    6.×Ö·û´®Êä³öº¯Êý

     

    l         echo string str1,string [strn]¡­

    echo ʵ¼ÊÉÏÊÇÒ»¸öÓï¾ä£¬µ±ºóÃæÖ»ÓÐÒ»¸ö²ÎÊýʱ²ÅÄܼÓÉÏÀ¨ºÅ¡£

     

    l         print(string str)

    ´Ëº¯Êý½«²»´ø¸ñʽÊä³öÒ»¸ö×Ö·û´®¡£

     

    l         int printf(string format,mixed [args]¡­)

    ´Ëº¯ÊýÏòHTMLÎĵµÖÐÊä³öÒ»¸ö¸ñʽ»¯×Ö·û´®¡£

     

    l         string sprintf(string format,mixed [args]¡­)

    ´Ëº¯ÊýÏòÒ»¸ö×Ö·û´®Êä³öÒ»¸ö¸ñʽ»¯×Ö·û´®¡£

     

    ÆäÖУ¬printf()º¯ÊýºÍsprintf()º¯ÊýµÚ1¸ö²ÎÊý¾ÍÊÇÒ»¸ö±íʾ¸ñʽµÄ×Ö·û´®£¬´Ë×Ö·û´®¹æ¶¨ÁËÊä³öµÄ¸ñʽ£¬ÓÉÆÕͨ×Ö·ûºÍ¸ñʽת»»·û×é³É¡£ÆäÖеÄÆÕͨ×Ö·û½«Ö±½ÓÊä³ö£¬¸ñʽת»»·ûÔòÓɺóÃæµÄ²ÎÊýÌæ´úÊä³ö¡£

           ¸ñʽת»»·ûÒÔ¡°£¥¡±¿ªÍ·£¬ÒÀ´Î°üÀ¨ÒÔϼ¸¸ö²¿·Ö¡£

           Ìî³äÃèÊö·û£¨¿ÉÑ¡£©£ºÖ¸Ã÷ÓÃʲô×Ö·ûÌî³ä×Ö·û´®µÄÊ£Óà¿Õ¼ä£¬¿ÉÒÔÊÇ¿Õ¸ñ£¨Ä¬ÈÏÖµ£©»òÕß0£¬Èç¹ûҪʹÓóýÕâ¶þÕßÖ®ÍâµÄÌî³ä·û£¬ÔòÒªÔÚËùÓÃ×Ö·ûÇ°Ãæ¼ÓÉÏÒ»¸öµ¥ÒýºÅ¡°¡¯¡±¡£

           ¶ÔÆëÃèÊö·û£¨¿ÉÑ¡£©£ºÖ¸Ã÷×Ö·û´®µÄ¶ÔÆ뷽ʽ£¬Ä¬ÈÏÇé¿öÏÂÊÇÓÒ¶ÔÆ룬Èç¹ûʹÓá°-¡±£¬Ôò±íʾ×ó¶ÔÆë¡£

           ¿í¶ÈÃèÊö·û£¨¿ÉÑ¡£©£ºÖ¸Ã÷´Ë¸ñʽת»»·ûÕ¼ÓõÄ×Ö·û¿í¶È¡£

           ¾«¶ÈÃèÊö·û£¨¿ÉÑ¡£©£ºÖ¸Ã÷¸¡µãÊýСÊýλÊý£¬´ËÏîÖ»¶Ô¸¡µãÊýÓÐЧ¡£

           ÀàÐÍÃèÊö·û£¨±ØÐ裩£ºÖ¸Ã÷²ÎÊýÀàÐÍ£¬¿ÉÓõÄÀàÐÍÈçϱíËùʾ£º

     

    ÀàÐÍÃèÊö·û

    ·ûºÅ

    ˵Ã÷

    £¥

    ±íʾ²»ÐèÒª²ÎÊý

    b

    ²ÎÊý±»×ª»»Îª¶þ½øÖÆÕûÐÍ

    c

    ²ÎÊý±»×ª»»ÎªÕûÐÍ£¬ÇÒÒÔASCIIÂë×Ö·ûÏÔʾ

    d

    ²ÎÊý±»×ª»»ÎªÊ®½øÖÆÕûÐÍ

    f

    ²ÎÊý±»×ª»»Îª¸¡µãÐÍ

    o

    ²ÎÊý±»×ª»»Îª°Ë½øÖÆÕûÐÍ

    s

    ²ÎÊý±»×ª»»Îª×Ö·ûÐÍ

    x

    ²ÎÊý±»×ª»»ÎªÊ®Áù½øÖÆÕûÐÍ£¬a-fÓÃСд×Öĸ±íʾ

    X

    ²ÎÊý±»×ª»»ÎªÊ®Áù½øÖÆÕûÐÍ£¬a-fÓôóд×Öĸ±íʾ

     

     

    ³ýÁËÉÏÊö¼¸¸ö×Ö·û´®Êä³öº¯ÊýÍ⣬PHPÖл¹ÌṩÁËÒ»¸öÇå¿ÕÊä³ö»º³åÇøµÄº¯Êý£º

    Void flush(void)¡£

     

     

    7.×Ö·û´®µÄ·Ö¸îÓëÁ¬½Óº¯Êý

    l         array explode(string separator, string str)

    ´Ëº¯ÊýÒÔ×Ö·û´®strÖеÄ×Ö´®separatro×÷Ϊ·Ö¸ô·û½«×Ö·û´®·Ö¸î¿ªÀ´£¬·Ö¸îºóµÄÒ»¸ö»ò¶à¸ö×Ó´®ÒÔÊý×éµÄÐÎʽ·µ»Ø¡£

    l         string implode(string glue,array pieces)

    ´Ëº¯ÊýµÄ×÷ÓÃÓëexplode()º¯ÊýµÄ¹¦ÄÜÕýºÃÏà·´£¬Æä×÷ÓÃÊǽ«Êý×épiecesÖеÄÔªËØÓÃ×Ö·û´®glueÁ¬½ÓÆðÀ´ÐγÉÒ»¸öÍêÕûµÄ×Ö·û´®¡£

    l         string strtok(string str, string token)

    ´Ëº¯ÊýµÄ×÷ÓÃÊǽ«×Ö·û´®strÔÚtokenËùÖ»ÊǵÄ×Ö·û´¦¡°¶Ï¿ª¡±£¬²¢·µ»Ø¶Ï¿ª´¦Ö®Ç°µÄ×Ö·û´®¡£´Ëº¯Êý½áºÏÑ­»·Óï¾ä¿ÉÒÔ´ïµ½Ó뺯Êýexplode()ͬÑùµÄ¹¦ÄÜ¡£

           µÚÒ»´Îµ÷ÓÃstrtok()º¯ÊýʱҪ´«ÈëÁ½¸ö²ÎÊý£¬ÒÔºóÈç¹û·Ö½ç·ûtoken²»±ä¸üµÄ»°£¬Ö»Ðè´«ÈëÒ»¸ö²ÎÊý¾Í¿ÉÒÔÁË£¬strtok()º¯Êý»á×Ô¶¯ËÑË÷µ½×Ö·û´®Ä©Î²¡£Èç¹ûÒªÖØÐÂÖ¸¶¨·Ö¸î·û£¬Ö»ÐèÔٴδ«ÈëÁ½¸ö²ÎÊý¼´¿É¡£

     

    8.×Ö·û´®²éÕÒºÍÌæ»»º¯Êý

    l         string stristr(string str1,string str2)

    l         string strstr(string str1,string str2)

    ÕâÁ½¸öº¯ÊýµÄ×÷ÓÃÊÇÔÚ×Ö·û´®str1ÖвéÕÒ×Ö·û´®str2µÚ1´Î³öÏֵĵط½£¬Èç¹ûÕÒµ½£¬½«·µ»Østr1ÖдÓstr2¿ªÊ¼Ê£Óಿ·Ö¡£×Ö·û´®str2Ò²¿ÉÒÔÊÇÒ»¸öÕûÊý£¬º¯Êý»áÏȽ«´ËÕûÊýת»»ÎªASCIIÂ룬Ȼºó½øÐвéÕÒ¡£Æ䲻ͬµãÔÚÓÚstristr()º¯Êý²»Çø·Ö´óСд£¬¶østrstr()º¯ÊýÇø·Ö´óСд¡£strchr()º¯ÊýÓëstrstrº¯ÊýµÄ¹¦ÄÜÍêÈ«Ïàͬ¡£

    l         string strrchr(string str1,string str2)

    ´Ëº¯ÊýµÄ×÷ÓÃÊÇÔÚ×Ö·û´®str1ÖвéÕÒ×îºóÒÀ´Î³öÏÖ×Ö·û´®str2µÄÊ××Ö·ûµÄµØ·½£¬²¢·µ»ØÊ××Ö·û¼°Ê£Óà×Ö·û´®£¬Í¬Ñùstr2 ²é¿´(917) ÆÀÂÛ(0) ÊÕ²Ø ·ÖÏí ¹ÜÀí

  • MYSQLÊý¾Ý¿âµÄ»ù±¾²Ù×÷

    2006-12-21 08:54:52

    l         ´´½¨Êý¾Ý¿â

     

    Mysql>create database temp;

     

    ×¢Ò⣺ÔÚ¡°mysql>¡±Ìáʾ·ûÏÂÓï¾ä½áÊøÒªÓá°£»¡±»òÕß¡°\g¡±¡£

     

    l         ɾ³ýÊý¾Ý¿â

    Mysql>drop database temp;

     

    l         Ñ¡ÔñÊý¾Ý¿â

    Mysql>use temp;

     

    l         ´´½¨Êý¾Ý±í

    Create [temporary] table [if not exits] tablename [(createdefine,¡­)] [tableoptions] [selectstatemente]

    ÀýÈ磺

    Mysql>use temp;

     

    Musql>create table studentinfo

           ->(

           ->name char(10),

           ->id int(6)

           ->);

     

    ×¢Ò⣺ÔÚ´´½¨Êý¾Ý±í֮ǰҪÓÃuseÓï¾äÑ¡ÔñÊý¾Ý¿â£¬·ñÔò»á³ö´í¡£

     

    l         ɾ³ýÊý¾Ý±í

    Mysql>drop table studentinfo;

     

    l         ¸ü¸ÄÊý¾Ý±í

    ¸ÃÓï¾ä¿ÉÒÔÐÞ¸ÄÒ»¸öÏÖÓбíµÄ½á¹¹¡£

     

    alter [ignor] table tablename alterspec [, alterspec¡­]

     

    l         ÓÅ»¯Êý¾Ý±í

    ÔÚÊý¾Ý±í·´¸´Ð޸ĺ󣬿ÉÒÔÓÃoptimize tableÓï¾äÀ´½øÐÐÓÅ»¯ºÍËéƬÕûÀí¹¤×÷¡£

    Mysql>optimize table info;

     

    l         Ìí¼Ó¼Ç¼

     

    insert [low_priority|delayed] [ignore] [into] tablename [(col_name,¡­)] values (expression,¡­),(¡­.),¡­

     

    »òÕß

    insert [low_priority|delayed] [ignore] [into] tablename [(col_name,¡­)] select¡­

     

    »òÕß

    insert [low_priority|delayed] [ignore] [into] tablename set col_name=expression, col_name=expression,¡­

     

    ÀýÈ磺

    Mysql>insert into info(name, id) values(¡®aaa¡¯,001,);

     

    l         ɾ³ý¼Ç¼

     

    delete [low_priority] from tablename [where where_define] [limit rows]

    ¸ÃÓï¾ä½«´Ótablename Êý¾Ý±íÖÐɾ³ýÂú×ãwhereÓï¾äÌõ¼þµÄ¼Ç¼£¬²¢·µ»Øɾ³ý¼Ç¼µÄ¸öÊý¡£Èç¹ûûÓÐwhere×Ӿ䣬¸Ã±íÖÐËùÓеļǼ¶¼½«±»É¾³ý¡£

     

    Mysql>delete from info;

     

     

    l         ²éѯÓï¾ä

     

    selectÓï¾äµÄÓï·¨£º

    select [straight_join] [sql_small_result] [sql_big_result] [high_priority] [distinct | distinctrow | all] select_expression¡­ [into {outfile | dumpfile} ¡®file_name¡¯ export_options] [from table_ref] [where where_define] [group by col_name] [having where_define] [order by {unsigned_integer | col_name |formula} [asc | desc],¡­] [limit [offset,] row] [procedure procedure_name]

     

  • PHPѧϰ±Ê¼Ç£¨¶þ£©¡ª¡ªº¯ÊýºÍ¶ÔÏó

    2006-12-19 09:57:36

     

    1.º¯ÊýµÄ¶¨Òå

    º¯Êý¶¨ÒåµÄÓï·¨ÐÎʽΪ£º

     

    function º¯ÊýÃû()

    {

     

        º¯ÊýÌå

     

    }

     

    PHPÖжÔÓû§×Ô¶¨Ò庯ÊýµÄº¯ÊýÃûÓÐÈçÏÂÒªÇó£º

    l         ²»ÄÜÓëPHPµÄÄÚ²¿º¯ÊýͬÃû

    l         ²»ÄÜÓëPHP¹Ø¼ü×ÖͬÃû

    l         ²»ÄÜÒÔÊý×Ö¿ªÍ·

    l         ²»ÄÜ°üº¬µãºÅ¡°.¡±¡£

     

    ÔÚPHPÖв»ÔÊÐíÒ»´Î·µ»Ø¶à¸öÖµ£¬µ«ÎÒÃÇ¿ÉÒÔÀûÓ÷µ»ØÒ»¸öÊý×éµÄ·½·¨´ïµ½Í¬Ê±·µ»Ø¶à¸öÖµµÄÄ¿µÄ¡£

     

    2.º¯ÊýµÄµ÷ÓÃ

    ʵ¼Ê²ÎÊýÁбíÒªÓëÐÎʽ²ÎÊýÁбíÏà¶ÔÓ¦£¨ÓÐĬÈϲÎÊýʱʵ¼Ê²ÎÊý»¹ÒªÓëĬÈϲÎÊý¶ÔÓ¦£©¡£Èç¹ûʵ¼Ê²ÎÊý±ÈÐÎʽ²ÎÊý¶à£¬¶àÓàµÄ²ÎÊý»á±»×Ô¶¯ÉáÆú£»Èç¹ûʵ¼Ê²ÎÊý±ÈÐÎʽ²ÎÊýÉÙ£¬Êµ¼Ê²ÎÊý»á±»Ò»Ò»ÌîÈëÐÎʽ²ÎÊýÖУ¬²»×㲿·ÖÒÔ¿Õ²ÎÊý´úÌæ¡£

     

    3.º¯ÊýµÄ²ÎÊý´«µÝ

    ¢ÙÖµ´«µÝ

    Ëùνֵ´«µÝ£¬¾ÍÊǽ«Êµ¼Ê²ÎÊýµÄÖµ¿½±´µ½ÐÎʽ²ÎÊýÖУ¬È»ºóÓÉÐÎʽ²ÎÊý²ÎÓ뺯ÊýÄÚ²¿µÄ¼ÆË㣬º¯Êýµ÷ÓýáÊøºó£¬Êµ¼Ê²ÎÊýµÄÖµ²»»á·¢Éú¸Ä±ä¡£

    ¢ÚÒýÓô«µÝ

    Èç¹ûҪʵÏÖÐÎʽ²ÎÊý¸Ä±äʱʵ¼Ê²ÎÊýÒ²·¢ÉúÏàÓ¦¸Ä±ä£¬¾ÍҪʹÓÃÒýÓô«µÝµÄ·½Ê½ÁË¡£ÊµÏÖ²ÎÊýµÄÒýÓô«µÝÓÐÁ½ÖÖ·½·¨£º

    l         ÔÚº¯Êý¶¨ÒåµÄʱºò£¬ÔÚÐÎʽ²ÎÊýÇ°Ãæ¼ÓÉÏ¡°&¡±·ûºÅ£¬ÀýÈ磺

    function fun(&$Var1){¡­}

                  ÒÔºóÔÚµ÷Óú¯Êýfun()ʱ¾Í»áĬÈϲÉÓÃÒýÓô«µÝÁË¡£

    l         º¯Êýµ÷ÓõÄʱºò£¬ÔÚʵ¼Ê²ÎÊýÇ°Ãæ¼ÓÉÏ¡°&¡±·ûºÅ£¬ÀýÈ磺

    function fun($Var1){¡­}

    fun(&$Var2);

    Èç¹ûÐÎʽ²ÎÊý$Var1µÄÖµÔÚº¯ÊýÖз¢Éú¸Ä±ä£¬Êµ¼Ê²ÎÊý$Var2µÄÖµÒ²»á·¢ÉúÏàÓ¦µÄ¸Ä±ä¡£

     

    ¢ÛĬÈϲÎÊý

           PHP»¹Ö§³ÖÓëC++ÖÐÀàËƵÄĬÈϲÎÊý£¬¼´ÔÚº¯Êý¶¨Òåʱ¿ÉÒÔΪһ¸ö»ò¶à¸ö²ÎÊýÖ¸¶¨Ä¬ÈÏÖµ¡£

     

    4.¿É±äº¯Êý

    ÔÚPHPµÄij¸ö´úÂë¶ÎÖУ¬Èç¹ûijһ±äÁ¿µÄÖµÓëÒ»¸öº¯ÊýͬÃûʱ£¬ÔòÔڸôúÂë¶ÎÖпÉÒÔʹÓøñäÁ¿´úÌ溯ÊýÃûÀ´µ÷Óú¯Êý£¬µ÷Ó÷½·¨ÎªÔÚ±äÁ¿Ãûºó¼ÓÉÏÀ¨ºÅ¼°º¯Êý²ÎÊý¡°(¡­)¡±¡£

    ÀýÈ磺

    function fun(){¡­}

    $Var=¡±fun¡±;

    $Var();

     

           ¿É±äº¯ÊýÓëÆÕͨº¯Êýµ÷ÓÃʱ×î´óµÄÇø±ð¾ÍÔÚÓڿɱ亯ÊýÇ°ÃæµÄ¡°$¡±·ûºÅ£¬Óд˷ûºÅ£¬ÏµÍ³¾Í»áÈÏΪÊǿɱ亯Êý¡£

           ×¢Ò⣺Èç¹ûд³É$Var=¡±fun()¡±£¬Ôò¡°$Var¡±Ö»ÊÇÒ»¸öÆÕͨ×Ö·û´®¶øÒÑ£¬ÔÙµ÷ÓÃÓï¾ä¡°$Var;¡±²»»áʵÏÖfun()º¯ÊýµÄ¹¦ÄÜ¡£

     

     

    5.Èý¸öÓë²»¶¨²ÎÊýÏà¹ØµÄº¯Êý£º

    Õâ3¸öº¯Êý¶¼Ö»ÄÜÔÚº¯ÊýÖе÷Óã¬ÔÚº¯ÊýÖ®ÍâʹÓûá²úÉú³ö´íÐÅÏ¢¡£

    ¢Ùint func_num_args(void)

    Õâ¸öº¯ÊýµÄ×÷ÓÃÊÇ·µ»Ø´«Èë²ÎÊýµÄ¸öÊý¡£

     

    ¢Úint func_get_arg(int arg_num)

    Õâ¸öº¯Êý½«·µ»ØµÚarg_num¸ö²ÎÊýÖµ£¬´«ÈëµÄ²ÎÊýϱê´Ó0¿ªÊ¼£¬Èç¹ûÔ½½ç£¬ÏµÍ³»á±¨´í£¬²¢·µ»ØFalse¡£

     

    ¢Ûint func_get_args(void)

    Õâ¸öº¯ÊýµÄ×÷ÓÃÊÇ·µ»ØÒ»¸ö°üº¬µ±Ç°º¯ÊýËùÓвÎÊýµÄÊý×é¡£

     

    6.PHPÖÐÀàµÄ¶¨Òå

    ÀàÖгÉÔ±±äÁ¿µÄ¶¨Òå·½·¨Îª£º¡°var ±äÁ¿Ãû£»¡±£¬³ÉÔ±º¯ÊýÓëÒ»°ãº¯ÊýµÄ¶¨Òå·½·¨Ïàͬ¡£

    ÀàÒ»µ©¶¨ÒåÖ®ºó£¬ÏµÍ³»á×Ô¶¯ÎªÆäÖ¸¶¨Ò»¸ö$this±äÁ¿£¬´ú±íÀà×ÔÉí¡£

    ×¢Ò⣺Èç¹û³ÉÔ±º¯ÊýÖÐҪʹÓÃÀàÖеijÉÔ±±äÀ´ÄǸö»òÆäËû³ÉÔ±º¯Êý£¬²»ÄÜÖ±½ÓÒýÓã¬ÒªÓá°$this->±äÁ¿Ãû¡±»ò¡°$this->º¯ÊýÃû¡±¡£

    ÿ¸öÀàÒ»°ã»¹ÓÐÒ»¸ö¹¹Ô캯Êý£¬ÓÃÓÚÀàµÄ³õʼ»¯¡£

     

    7.ÀàµÄ·â×°ÐÔ

    ÀàÖеÄÊôÐÔ²»ÄÜÓÉÀàµÄʵÀý»¯¶ÔÏóÖ±½Ó·ÃÎÊ£¬Ö»ÄÜͨ¹ý³ÉÔ±º¯ÊýÀ´·ÃÎÊ¡£

     

    8.ÀàÖеĹ¹Ô캯Êý

    ¹¹Ô캯ÊýÊÇÀàÖÐÒ»¸öÌØÊâµÄº¯Êý£¬Õâ¸öº¯ÊýµÄº¯ÊýÃûÓëÀàÃûÏàͬ£¬¶øÇÒÔÚ¶ÔÏóÉú³Éʱ»á×Ô¶¯µ÷Óá£

    ¹¹Ô캯Êý¿ÉÒÔ½ÓÊÕ²ÎÊý£¬ÕâÑù¿ÉÒÔÔÚ¶ÔÏóʵÀý»¯Ê±Ö¸¶¨³õʼ»¯µÄÖµ¡£

     

    9.ÀàµÄ¼Ì³ÐÐÔ

    Ò»¸öÀàÔڼ̳ÐÆäËûÀàʱ£¬¿ÉÒԼ̳ÐÆäÖÐËùÓеÄÊôÐԺͷ½·¨£¬ÕâÖּ̳ÐÆäËûÀàµÄÀà¾ÍÊÇÅÉÉúÀ࣬±»¼Ì³ÐµÄÀà½Ð¸¸Àà¡£PHPÖм̳ÐÀàҪʹÓÃextends¹Ø¼ü×Ö£¬Ê¹Ó÷½·¨Îª£º

           Class ¸¸ÀàÃû extends ×ÓÀàÃû

           ×¢Ò⣺PHPÖв»Ö§³Ö¶àÖؼ̳С£

           ÅÉÉúÀàͨ³£Ò²ÐèÒªÓÐ×Ô¼ºµÄ¹¹Ô캯Êý£¬ÒòΪ¸¸ÀàÖеĹ¹Ô캯ÊýÔÚÅÉÉúÀàÖÐÖ»ÊÇÒ»¸öÆÕͨº¯Êý£¬µ±ÅÉÉúÀà¶ÔÏóÉú³Éʱ²¢²»»á×Ô¶¯Ö´ÐС£

     

    10.PHPÖÐÀàµÄ¶à̬ÐÔ

    µ±ÅÉÉúÀàÖÐij¸öº¯ÊýµÄº¯ÊýÃûÓëÆ丸ÀàÖÐij¸öº¯ÊýµÄº¯ÊýÃûÖظ´Ê±£¬ÏµÍ³ÔÚÅÉÉúÀà¶ÔÏóÖлá×Ô¶¯Ñ¡ÓÃÅÉÉúÀàÖеĺ¯Êý£¬Õâ¾ÍʱÀàµÄ¶à̬¡£

           Ö®Àà¼Ì³Ð¸¸Ààʱ£¬ÔÚÖ®ÀàÖÐÖØжԸ¸ÀຯÊý¼ÓÒÔ¶¨Ò壬¶ø²»¸Ä±äº¯ÊýÃû£¬¾ÍʵÏÖÁËÀàµÄ¶à̬¡£

  • PHPѧϰ±Ê¼Ç£¨Ò»£©¡ª¡ª»ù±¾Óï·¨

    2006-12-15 08:55:12

    1.PHPÖеÄÎļþ°üº¬

           PHPÖеÄÎļþ°üº¬ÓÐÁ½ÖÖ·½·¨£ºÊ¹ÓÃinclude()º¯ÊýºÍʹÓÃrequire()º¯Êý¡£º¯ÊýÀïÃæÊÇËùÒª°üº¬½øÀ´µÄÎļþµÄÃû³Æ¡£

           Include()º¯Êý¿ÉÒÔ·ÅÔÚ³ÌÐòµÄÈκεط½£¬PHP±àÒëÆ÷ÔÚ¶Áµ½include()º¯Êýʱ£¬²Å½«Ö¸¶¨Îļþ°üº¬½øÀ´¡£¶ørequire()º¯Êý±ØÐëÒª·ÅÔÚPHP³ÌÐòµÄ×îÇ°Ã棬PHP³ÌÐòÔÚÖ´ÐÐʱ£¬ÏȶÁÈërequire()º¯ÊýËù°üº¬µÄÎļþ£¬Ê¹Ëü³ÉΪPHPÍøÒ³µÄÒ»²¿·Ö¡£³£Óõĺ¯ÊýÒ»°ã¶¼ÊÇÓÃrequireµÄ·½·¨°üº¬½øÀ´µÄ¡£

     

    2.PHPÖÐÔ¤¶¨ÒåµÄ³£Á¿

    ³£Á¿Ãû³Æ

    ³£Á¿º¬Òå

    __FILE__

    µ±Ç°PHP³ÌÐòÎļþÃû¡£ÔÚinclude()»òrequire()º¯ÊýÖÐʹÓÃÕâ¸ö³£Á¿Äܵõ½¸Ãº¯Êý°üº¬µÄÎļþÃû

    __LINE__

    µ±Ç°Ö´ÐÐÓï¾äÔÚPHP³ÌÐòÎļþÖеÄÐÐÊý¡£ÔÚinclude()»òrequire()º¯ÊýÖÐÕâ¸ö³£Á¿½«±íʾ±»ÒýÓÃÎļþµÄÐÐÊý

    PHP_VERSION

    µ±Ç°PHP³ÌÐòµÄ°æ±¾ºÅ

    PHP_OS

    µ±Ç°ËùÓòÙ×÷ϵͳÀà±ð

    True

    Âß¼­Õæ

    False

    Âß¼­¼Ù

    E_ERROR

    Ö¸Ã÷×î½üÒ»´Î²úÉúµÄ²»¿É»Ö¸´µÄ´íÎó

    E_WARING

    Ö¸³öÓдíÎ󣬵«³ÌÐò¿ÉÒÔ¼ÌÐø½øÐÐÏÂÈ¥£¬¸Ã´íÎó¿É±»½Å±¾²¶»ñ

    E_PARSE

    Óï·¨´íÎ󣬷ÖÎöÆ÷½«Í£Ö¹·ÖÎö

    E_NOTICE

    ²úÉúÒì³££¬µ«²»Ò»¶¨ÊÇ´íÎ󣬳ÌÐò¿ÉÒÔ¼ÌÐøÖ´ÐÐ

     

    ˵Ã÷£º__FILE__ºÍ__LINE__Öеġ°__¡±ÊÇË«Ï»®Ïߣ¬²»Êǵ¥Ï»®Ïß¡£ÒÔ¡°E_¡±¿ªÍ·µÄ³£Á¿Ò»°ãÓëerror_reporting()º¯ÊýÁªÓã¬ÒÔ²úÉúÏà¹ØµÄµ÷ÊÔ³ö´íÐÅÏ¢¡£

     

    3.PHPµÄ×Ô¶¨Òå³£Á¿

    ³ýÔ¤¶¨Òå³£Á¿Í⣬PHPÒ²Ö§³ÖÓÃdefine()º¯Êý×Ô¶¨Òå³£Á¿£¬ÀýÈ磺

    <?php

        Define(STR,¡±A constant string¡±);

        Echo STR;

     

    ?>

    ×¢Ò⣺³£Á¿Ò»µ©¶¨Ò壬ÔÚ³ÌÐòÖоͲ»ÔÊÐíÔÙ¸ü¸ÄËüµÄÖµ¡£

     

     

    4.PHPÖеıäÁ¿ÀàÐÍ

     

    l         integer:ÕûÐÍ

    l         floating point number (double):¸¡µãÐÍ£¨»òË«¾«¶ÈÐÍ£©¡£

    l         boolean:²¼¶ûÐÍ£¨PHP4£©

    l         string:×Ö·û´®

    l         array:Êý×é

    l         object:¶ÔÏó

     

    PHPÖеıäÁ¿ÊôÓÚËÉÉ¢Êý¾ÝÀàÐÍ£¬²»±ØÓɱà³ÌÕß×Ô¼º¶¨Ò壬¶øÊÇÔÚʹÓÃʱÓÉPHP±àÒëÆ÷¶¯Ì¬½øÐÐÀàÐÍÖ¸¶¨»òת»»£¬±äÁ¿ÃûÒªÒÔ¡°$¡±·ûºÅ¿ªÍ·£¬ÇÒÇø·Ö´óСд¡£±äÁ¿Èç¹ûδ¸³Öµ¶øÖ±½ÓʹÓ㬱äÁ¿Öµ½«±»ÊÓΪ¿Õ¡£

     

    5.·¾¶ÊéдµÄ×¢Òâ

           ÔÚ×Ö·û´®Öбíʾ·¾¶Ê±¾¡Á¿Óá°\\¡±£¬²»ÒªÓá°\¡±£¬ÒÔÃâ±àÒëϵͳ²úÉúÎó½â¡£

     

    6.Á½ÖÖ×Ö·û´®·Ö½ç·û

     

    µ¥ÒýºÅÖеÄ×Ö·û´®²»ÄÜ×Ô¶¯×ª»»ÆäÖеıäÁ¿¡£Ê¹ÓÃË«ÒýºÅÀ¨ÆðÀ´µÄ×Ö·û´®ÄÜ×Ô¶¯×ª»»ÆäÖаüº¬µÄ±äÁ¿¡£

     

    7.PHPµÄÊý×é

           PHPͬʱ֧³ÖÒÔÊý×ÖΪϱêµÄÊý×飨scalar array,Ë÷ÒýÊý×飩ºÍÒÔ×Ö·û´®ÎªÏ±êµÄÊý×飨associative array,¹ØÁªÊý×飩£¬Õâ¶þÕßûÓÐÈκÎÇø±ð¡£

    ÔÚPHPÖпÉÒÔʹÓÃlist()º¯Êý»òÕßarray()º¯ÊýÀ´´´½¨Êý×飬Ҳ¿ÉÒÔÖ±½Ó½øÐи³Öµ¡£

     

    8.PHPµÄ±äÁ¿ÀàÐÍת»»

    ±äÁ¿µÄ×Ô¶¯×ª»»Ö÷ÒªÒÀÀµÓÚ²Ù×÷·û£¬ÈçÓá°.=¡±½«»áת»»Îª×Ö·û£¬Óá°+=¡±½«»áת»»ÎªÊý×Ö¡£ÔÚËÄÔòÔËËãÖУ¬×Ö·û´®»á×Ô¶¯×ª»»ÎªÊý×Ö¡£Èç¹û×Ö·û´®Öк¬ÓС°.¡±¡¢¡°e¡±»òÕß¡°E¡±£¬½«±»×ª»»Îª¸¡µãÐÍÊý¾Ý£¬·ñÔò½«°´ÕûÐÍÀ´´¦Àí£¬×Ö·û´®Öв»·ûºÏÊý×Ö¹æÔòµÄ²¿·Ö½«±»ÉáÈ¥¡£Èç¹û×Ö·û´®ÒÔÆÕͨ×Ö·û¿ªÍ·£¬ÔÚת»»ÎªÊý×Öʱ½«±»ÊÓΪ0¡£´ËÍ⣬×Ö·û´®µÄ×ÔÔö¡¢×Ô¼õÔËËãÊÇÔÚ×Ö·û´®ÖÐ×îºóÒ»¸ö×Ö·ûµÄASCIIÂë»ù´¡ÉϽøÐеġ£

     

     

     

     

    <?php

     

     

        $Var1=3;    //$Var1 ÊÇÕûÊý3

        $Var.1=¡±10a¡±;    //$Var1 ÏÖÔÚÊÇ×Ö·û´®¡±310a¡±

        $Var2=¡±1¡±;    //$Var2ÊÇ×Ö·û´®¡±1¡±

        $Var2++;    //$Var2±äΪ×Ö·û´®¡±2¡±!!

        $Var2+=1;    //$Var2±äΪÕûÊý3

        $Var2+=1.1;    //$Var2±äΪ¸¡µãÐÍ4.1

        $Var2=¡±a¡±;    //$Var2ÊÇ×Ö·û´®¡±a¡±

        $Var2++;    //$Var2±äΪ×Ö·û´®¡±b¡±!!

        $Var2=¡±ab¡±;    //$Var2ÊÇ×Ö·û´®¡±ab¡±

        $Var2++;    //$Var2±äΪ×Ö·û´®¡±ac¡±!!

        $Var3=1;    //$Var3ΪÕûÊý1

        $Var3+=¡±10a¡±;    //$Var3±äΪÕûÊý11£¡£¡

        $Var4=1;    //$Var4ΪÕûÊý

        $Var4+=¡±a10¡±;    //$Var4»¹ÊÇÕûÊý1!!

        $Var4+=¡±-10a¡±;    //$Var4±äΪÕûÊý-9£¡£¡

     

    ?>

     

    9.PHP±äÁ¿µÄ×÷ÓÃÓò

    PHPÖеıäÁ¿ÊÇÓÐ×÷Ó÷¶Î§µÄ£¬Ò»°ãÇé¿öÏ£¬±äÁ¿µÄ×÷ÓÃÓòÊÇ°üÀ¨±äÁ¿µÄPHP³ÌÐò¿é£¬Ò²¾ÍÊÇ¡°<?php¡±¡¢¡°?>¡±Ö®¼äµÄ´úÂë¶Î»òÕß¡°{¡±¡¢¡°}¡±Ö®¼äµÄ´úÂë¶Î¡£Èç¹ûÆäÖл¹ÓÐÓÃinclude()»òrequire()º¯Êý°üº¬µÄÎļþ£¬±äÁ¿µÄ×÷ÓÃÓòÒ²ÄÜÀ©Õ¹µ½ÕâЩÎļþÖС£

           Èç¹ûÒªÔÚº¯ÊýÖÐÒýÓÃÖ÷³ÌÐòÖеıäÁ¿µÄÖµ£¬¿ÉÒÔʹÓÃPHP¶¨ÒåµÄ$GLOBALSÊý×飬$GLOBALSÊý×éÊÇÒ»¸öÒÔ±äÁ¿ÃûΪϱêµÄÊý×顣ȫ¾ÖÊý×éÔÚʹÓÃʱ²»ÄÜд³É¡°$GLOBALS[¡°$int1¡±]¡±£¬ÒªÈ¥µô±äÁ¿Ç°ÃæµÄÃÀÔª·û¡£

           »¹ÓÐÒ»ÖÖʵÏÖ¿çÓòµ÷Óù¦Äܵķ½·¨¾ÍÊÇʹÓÃÈ«¾Ö±äÁ¿£¬È«¾Ö±äÁ¿¶ÔÕû¸ö³ÌÐò¶¼ÊǿɼûµÄ£¬²»½öÔÚº¯ÊýÖпÉÒÔ·ÃÎÊÖ÷³ÌÐòÖеÄÈ«¾Ö±äÁ¿£¬ÔÚÖ÷³ÌÐòÖÐÒ²¿ÉÒÔ·ÃÎʺ¯ÊýÖеÄÈ«¾Ö±äÁ¿¡£È«¾Ö±äÁ¿¶¨Òå·½·¨ÎªÔÚ±äÁ¿ÃûÇ°¹ÚÒÔ¡°global¡±¹Ø¼ü×Ö¡£

           È«¾Ö±äÁ¿µÄ¶¨Òå²»ÄÜÓ븳ֵдÔÚÒ»Æ𣬼´¡°global $int2=2;¡±½«ÎÞ·¨Í¨¹ýÓï·¨¼ì²é¡£

     

    10.¾²Ì¬±äÁ¿

           ¾²Ì¬±äÁ¿Ö»ÄÜÓÃÓÚº¯Êý·¶Î§ÄÚ£¬ÓëÆÕͨ¾Ö²¿±äÁ¿²»Í¬Ö®´¦ÔÚÓÚ£ºµ±¸Ãº¯ÊýÔËÐнáÊøʱ£¬¾²Ì¬±äÁ¿²»»á¶ªÊ§×Ô¼ºµÄÖµ¡£¾²Ì¬±äÁ¿µÄ¶¨Òå·½·¨ÎªÔÚ±äÁ¿Ç°¹ÚÒÔ¡°static¡±¹Ø¼ü×Ö¡£

           ¾²Ì¬±äÁ¿ËäÈ»ÔÚº¯Êý½áÊøʱֵ²»¶ªÊ§£¬µ«Æä×÷ÓÃÓòÖ»ÔÚ±¾º¯ÊýÖУ¬ÔÚº¯ÊýÖ®ÍâÈÔÈ»ÊÇÎÞЧµÄ¡£

     

    11.¶¯Ì¬±äÁ¿

    PHPÖеĶ¯Ì¬±äÁ¿ÔÊÐíÒ»¸ö±äÁ¿µÄÖµ×÷ΪÁíÒ»¸ö±äÁ¿µÄ±äÁ¿Ãû£¬Ç°ÌáÌõ¼þÊÇÕâ¸öÖµÒª·ûºÏ±äÁ¿ÃüÃû¹æÔò¡£

           ÔÚÊý×éÖÐʹÓö¯Ì¬±äÁ¿Ê±Òª½â¾öÒ»¸öáªÒåÎÊÌ⣺±ÈÈç$$Var[1]¾¿¾¹ÊÇÒÔ±äÁ¿$Var[1]µÄÖµ×÷Ϊ±äÁ¿Ãû£¬»¹ÊÇÒÔ$$Var×÷Ϊ±äÁ¿£¬ÔÙÒýÓÃËüµÄµÚÒ»¸öÔªËØ£¿´ËʱÐèÒªÓÃ{}Ïû³ýáªÒ壬ÉÏÊöÁ½ÖÖÇé¿öÓ¦·Ö±ð±íʾΪ${$Var[1]}ºÍ${$Var}[1]¡£

     

    12.ÒýÓñäÁ¿

           PHPÖ§³ÖÒýÓñäÁ¿¡£¶ÔÒ»¸ö±äÁ¿½øÐÐÒýÓòúÉúбäÁ¿ºó£¬Ð±äÁ¿¿ÉÒÔ¿´×÷Ô­±äÁ¿µÄÒ»¸ö±ðÃû£¬¸Ä±äÆäÖÐÈκÎÒ»¸öµÄÖµ£¬Á½¸öÖµ¶¼»áÒ»Æð¸Ä±ä¡£Ê¹ÓÃÒýÓñäÁ¿µÄ·½·¨ÊǸ³ÖµÊ±ÔÚÓұ߱äÁ¿Ç°¼Ó¡°&¡±¡£

     

    13.PHPÖеÄÔ¤¶¨Òå±äÁ¿

     

    ±äÁ¿Ãû³Æ

    º¬Òå

    argv

    ´«µÝ¸ø½Å±¾µÄ²ÎÊýÊý×飬ÓëCÓïÑÔmain()º¯ÊýÖеÄargv²ÎÊýÒ»Ñù£¬ÔÚͨ¹ýGET·½·¨·¢ËÍÇëÇóʱ£¬´Ë²ÎÊý°üº¬Á˲éѯ×Ö·û´®¡£

    argc

    ´«µÝ½Å±¾µÄ²ÎÊý´óС

    PHP_SELF

    µ±Ç°ÔËÐнű¾µÄÎļþÃû£¬ÒÔÃüÁîÐз½Ê½Æô¶¯PHPʱûÓд˱äÁ¿

    HTTP_COOKIE_VARS

    ÓÉHTTP Cookies´«¸øµ±Ç°½Å±¾µÄÒ»¸ö¹ØÁªÊý×é

    HTTP_GET_VARS

    ʹÓÃHTTP GET ·½·¨Ê±£¬´«¸øµ±Ç°½Å±¾µÄÒ»¸ö¹ØÁªÊý×é

    HTTP_POST_VARS

    ʹÓÃHTTP POST ·½·¨Ê±£¬´«¸øµ±Ç°½Å±¾µÄÒ»¸ö¹ØÁªÊý×é

     

    ×¢Ò⣺ҪʹÓúó3¸ö±äÁ¿ÏÈÒª½«php.ini ÎļþÖеġ°track_vars¡±ÖÃΪOn¡£

     

    14.Íⲿ±äÁ¿

    PHPÖÐÍⲿ±äÁ¿µÄÀ´Ô´¿ÉÄÜÓÐ3ÖÖ;¾¶£º

    <P class=MsoNormal style="MARGIN: 0cm