php °²È«
ÈçºÎ²»Ê¹ÓÃprepared statment£¬¶øÊÇÓùýÂ˵ķ½·¨±ÜÃâSQL×¢ÈëÄØ£¿
Ò»°ãÀ´Ëµmysql×Ô´øµÄ¹ýÂ˺¯ÊýÊDZȽϿɿ¿µÄ¡£mysql_real_escape_string()
µ«ÊÇÕâ¸öº¯ÊýÔÚijЩ×Ö·û¼¯ÖÐÓÐÎÊÌ⣬±ÈÈçGBK¡£Èç¹ûÄãÓÃUTF8ÄÇû¹ØÏµ¡£
ÔÚPHPÀïÉèÖÃÊý¾Ý¿âµÄ×Ö·û¼¯²»Ó¦¸ÃÓãºmysql_query("SET NAMES UTF8");
¶øÓ¦¸ÃÓãºmysql_set_charset()
ÕâÑùmysql_real_escape_string()ÔÚ´¦ÀíGBK±àÂëµÄʱºò¾Í²»»á³öÎÊÌâÁË¡£
mysql_real_escape_string() not safe when SET NAMES is used
use mysql_set_charset() instead.
Note: This is the preferred way to change the charset. Using mysql_query() to execute SET NAMES .. is not recommended.
SET NAMES is usually used to switch the encoding from what is default to what the application needs. This is done in a way that mysql_real_escape_string doesn’t know about this. This means if you switch to some multi byte encoding that allows backslash as 2nd 3rd 4th… byte you run into trouble, because mysql_real_escape_string doesn’t escape correctly. UTF-8 is safe…
Safe way to change encoding is mysql_set_charset, but that is only available in new PHP versions
Ïà¹ØÎĵµ£º
ÀÏÁÎÔø¾ÔÚPHPERÔÓÖ¾ÉÏ·¢±í¹ýһƪÎÄÕ½Ð×öÓÃVIM×öPHP¿ª·¢»·¾³,ÔÚÀïÃæÏêϸ½éÉÜÁËÓÃVIM×öphp¿ª·¢ÐèÒª×öµÄ×¼±¸,ÕâÆªÎÄÕ¾ͽáºÏһЩ×ÊÁϺÍÎÒ×Ô¼ºµÄһЩ¾ÑéÀ´½éÉÜÏÂÓÃVIM×öC/C++¿ª·¢ÐèÒª×öµÄÊÂÇé,Ïà¶ÔÀ´ËµÒª±È×öphp¿ª·¢·½±ãЩ¡£
ǰÌáÌõ¼þÊǵ±È»ÊÇÄãÒѾÏÂÔØÁËVIM,Èç¹ûûÓеϰÇëÏȵ½¹Ù·½ÍøÕ¾ÏÂÔØ×îа汾,µØÖ·ÊÇ£ºhttp:/ ......
ºÜ¾Ã¶¼Ã»ÓÐдһÏÂѧϰÈÕÖ¾ÁË,¶¼²»ÖªµÀ×î½üÔÚæʲô,ͻȻ¾õµÃ×Ô¼ºÓ¦¸ÃдµãʲôÉÏÈ¥.
Êý¾Ý¿âµÄÔ×Ó²Ù×÷ÊÇÁ½Èý¸öÔÂǰѧµÄ¶«Î÷ÁË,½ñÌìͻȻÓÖÓõ½ÁË,Òò´Ë½ñÌì±ØÐëµÃ½«Æä¼Ç¼ÏÂÀ´,·ñÔòÏ´ÎÓÖÒªÖØÐÂËÑË÷ÁË.
Ô×Ó²Ù×÷³£Óõķ½·¨¾ÍÊÇͨ¹ýÊý¾Ý»Ø¹öÀ´ÊµÏÖ,Óà PHP À´ÊµÏÖÊý¾Ý¿â»Ø¹ö ......
php°²×°³ÌÐòÔÀí£º
ÆäʵPHP³ÌÐòµÄ°²×°ÔÀíÎ޷ǾÍÊǽ«Êý¾Ý¿â½á¹¹ºÍÄÚÈݵ¼Èëµ½ÏàÓ¦µÄÊý¾Ý¿âÖУ¬´ÓÕâ¸ö¹ý³ÌÖÐÖØÐÂÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄ²ÎÊýºÍÎļþ£¬ÎªÁ˱£Ö¤²»±»±ðÈ˶ñÒâʹÓð²×°Îļþ£¬µ±°²×°Íê³ÉºóÐèÒªÐ޸ݲװÎļþ¡£
²½Ö裺
¼ì²éĿ¼»òÎļþµÄȨÏÞ
Ð޸ĻòÌî¼ÓÅäÖÃÎļþ
¼ì²éÅäÖÃÎļþÕýÈ·ÐÔ
µ¼ÈëÊý¾Ý¿â
Ëø¶¨»òÉ ......
PHPÊÇÒ»ÃÅ¿ª·¢Ëٶȿ죬ÔËÐÐËÙ¶È¿ìµÄÓïÑÔ£¬µ«ÊÇËüÒ²ÓÐÖÂÃüȱµã£¬ÎÞ¶àỊ̈߳¨ËäÈ»ApacheµÄ·þÎñÆ÷ÔÚÁíÒ»Ö̶ֳÈÉÏÃÖ²¹ÁËÕâÖÖȱÏÝ£¬µ«ÊÇÔÚ±àдһЩÐèÒª¸ß²¢·¢²¢ÇÒ¿¼ÂÇЧÂʵijÌÐòÏ£¬Ëü»¹ÊÇÃ÷ÏÔ²»×㣩¡£
µ«ÊÇPHP¿ÉÒÔ´ó´óËõ¶Ì¿ª·¢ÖÜÆÚ£¬Ó뿪·¢³É±¾£¨±ÈÈçPHP¶ÔÓÚ³ÌÐòÒªÇóµÄÃż÷ºÜµÍ£©¡£
×ÜÌåÀ´Ëµ£¬PHPºÜÊʺϿª·¢ÍøÕ¾À´Ó㬶øÔÚ¿ª·¢ ......