PHP+MySQLÂÒÂëµÄ½â¾ö
ÔÚDOSÖнøÐÐMySQLµÄ·ÃÎÊ¿ÉÄÜÂÒÂëµÄÇé¿öÓÐÈýÖÖ£¬
Ê×ÏÈ£¬Òª×öµÄÊǼì²éMySQLµÄÅäÖ㬰²×°µÄʱºòÑ¡Ôñutf-8µÄÓïÑÔ»·¾³»áʡȥºÜ¶àµÄÂé·³
1. ¼ì²éMySQLµÄ·þÎñ¶Ë¡¢¿Í»§¶ËµÄÓïÑÔÉèÖÃÊÇ·ñΪ“utf8”£¬²»ÊǵϰÊÖ¶¯½«my.int¸ü¸Ä¹ýÀ´£»
2. ÔÚPHP½øÐеÚÒ»´Îmysql_query֮ǰÉèÖÃʹÓÃÁ¬½ÓµÄ×Ö·û¼¯Îª"SET NAMES 'utf8'"£¬¼´mysql_query("SET NAMES 'utf8'");ºÜ¶àÈË×öµ½ÕâÀï¾Í¿ÉÒÔ¿´µ½ºº×ÖÁË£»
3. ÉèÖÃdatabaseµÄ×Ö·û¼¯——ÀýÈ磬CREATE DATABASE dmsdb DEFAULT CHARACTER SET utf8 COLLATE utf8_bin£¬ÕâÑùʹÓÃshow full column from tablename²éµ½µÄVARCHARµÄCOLLATE²ÅÊÇutf8_binÀàÐ͵ģ»
Æä´Î£¬Ó¦¸Ã·¢ÏÖÔٴβéѯµÄ½á¹û×Ö·û´®ÓÐÁ˱仯£¬ÕâʱÈç¹ûÓÐÐí¶àµÄÈÕÎÄ×Ö·û³öÏÖ£¬ÔÙ¿´PHP.iniµÄÉèÖãº
phpÖÐÒª¶Ôphp.iniÎļþÖÐline 637: extension=php_mbstring.dll ǰµÄ·ÖºÅ³ýµô£¬²¢ÇÒ±ØÐèÐÞ¸Ämb_stringµÄÏà¹Ø±àÂëÅäÖã¬Ð޸ĺóµÄÄÚÈÝΪ£º
line 1164: mbstring.language = utf-8
line 1169: mbstring.internal_encoding = utf-8
line 1172: mbstring.http_input = auto
line 1176: mbstring.http_output = utf-8
line 1183: mbstring.encoding_translation = On
line 1187: mbstring.detect_order = auto
line 1191: mbstring.substitute_character = utf-8;
line 1201: mbstring.func_overload = 1
£¨ËùÓÐÐкžù¶ÔÓ¦µÄÊÇphp5.1.6 °æ±¾µÄphp.ini-recommand£©
µ±´ËʱÉèÖÃÍê³ÉºóÎÒÔÚdosÀï½øÐвéѯ²Ù×÷»¹ÊÇ»á³öÏÖÂÒÂëµÄÐÎʽ£¬ÕâʱҪ¿¼ÂÇdosµÄÉèÖÃÎÊÌâÁË£¬
ÔÚShell>mysql --default-character-set=gbk -u root -p£¬Ó¦¸ÃÔÙ½øÐвéѯ¾Í»áÏÔʾ³öÍêÃÀµÄºº×ÖÁË£¡
Ïà¹ØÎĵµ£º
PHPÔ´´úÂë¼òµ¥·ÖÎö
1. Ŀ¼½á¹¹
1. build ºÍ±àÒëÓйصÄĿ¼¡£
2. ext À©Õ¹¿â´úÂ룬ÀýÈç Mysql¡¢zlib¡¢iconv µÈÎÒÃÇÊìϤµÄÀ©Õ¹¿â¡£
3. main Ö÷Ŀ¼¡£
4. sapi ºÍ¸÷ÖÖ·þÎñÆ÷µÄ½Ó¿Úµ÷Óã¬ÀýÈçapache¡¢IISµÈ£¬Ò²°üº¬Ò»°ãµÄfastcgi¡¢cgiµÈ¡£
5. wi ......
¼Ì³ÐÌØÐÔ¼ò»¯Á˶ÔÏó£¬ÀàµÄ´´½¨£¬Ôö¼ÓÁË´úÂëµÄÖØÓÃÐÔ¡£µ«ÊÇPHPÖ®Ö§³Öµ¥¼Ì³Ð¡£Èç¹ûÏëʵÏÖ¶à¼Ì³ÐµÄ»°¾ÍÒªÓõ½PHPµÄ½è¿Ú¡£PHP¿ÉÊÇʵÏÖ¶à¸ö½Ó¿Ú¡£
²»ÒªÓÃpublicÒÔÍâµÄ¹Ø¼ü×ÖÀ´ÐÞÊνӿÚÖеÄÀà³ÉÔ±¡£¶ÔÓÚ·½·¨£¬²»Ð´¹Ø¼ü×ÖÒ²¿ÉÒÔ¡£ÕâÊÇÒ»¸ö½è¿ÚÀà×ÔÉíµÄÌìÐÔ¾ö¶¨µÄ¡£ÄÇôÎÒÏëËûÊÇÎªÊ²Ã´ÄØ£¿
¶ÔÓÚ½Ó¿ÚÀ´Ëµ£¬Ëü²»ÄÜÓÃprotected,ºÍpr ......
±¾ÎÄÁгöÁËËùÓгõѧÕß×î³£¼ûµÄPHPÎÊÌâ
¡¾1¡¿Ò³ÃæÖ®¼äÎÞ·¨´«µÝ±äÁ¿ get,post,sessionÔÚ×îеÄphp°æ±¾ÖÐ×Ô¶¯È«¾Ö±äÁ¿Êǹرյģ¬ËùÒÔÒª´ÓÉÏÒ»Ò³ÃæÈ¡µÃÌá½»¹ýÀ´µÃ±äÁ¿ÒªÊ¹ÓÃ$_GET['foo'],$_POST['foo'],$_SESSION['foo']À´µÃµ½
µ±È»Ò²¿ÉÒÔÐÞ¸Ä×Ô¶¯È«¾Ö±äÁ¿Îª¿ª(php.ini¸ÄΪregister_globals = On)£»¿¼Âǵ½¼æÈÝÐÔ£¬»¹ÊÇÇ¿ÆÈ ......
˵¾äʵ»°,дÕâ¸öÕæ¹»ÎÞÁĵÄ.±¾À´¿´ÁËijλ´óϺµÄÀàËÆÎÄÕÂ,¸¹·ÌÁ˼¸¾äÒ²¾ÍËãÁË.µ«ÊÇ×òÌìÍíÉÏÓиö¿Í»§ÄÃ×ÅÕâÆªÎÄÕÂÎÊÎÒ: ÄãѾµÄ×Ô¼º×ö
Íâ°ü,ÄãË㼸¶ÎPHPer?Ëì¸Ð¾õÄÇÆªÎÄÕ¶ÔijЩ°ëͨ²»Í¨Ö®È˵ÄÎóµ¼Ö®Éî.ÎÞ·¨,Ö»ÓÐд´ËÎÄÕ±íÃ÷ÎÒ¶ÔPHPerµÄË®Æ½Çø·ÖµÄÁ¢³¡.
¹ØÓÚ¾ßÌåÊÕÈëˮƽ,×ܵÄÀ´ËµÒòΪÕ⼸ÄêPHPÅàѵ°àµÄ¼Ó¶à,´óÁ¿PHPÐÂÊÖ¿ ......