PHPÖÐstripslashesºÍaddslashesµÄʹÓÃ
ÏòmysqlдÈëÊý¾Ýʱ£¬È磺mysql_query("update tableName set `title`='goaler's blog'");
¡¡¡¡Õâ¸öʱºò£¬PHP½«»á±¨´í£¬ASPÖд¦ÀíʱҲһÑù¡£
¡¡¡¡ÒòΪÊý¾Ý¿â¶Ôµ¥ÒýºÅ¹ýÃô¡£
¡¡¡¡ASPÖÐÐèÒª½øÐÐreplace("'","''",str)£»
¡¡¡¡¶øPHPÖÐÔò¿ÉÒÔÖ±½ÓʹÓÃaddslashes¡£
¡¡¡¡ASPÎÊÌâÕâÀïÔݲ»¿¼ÂÇ£¬±¾ÎÄҪ˵µÄÊÇPHPÏà¹ØµÄstripslashesºÍaddslashes¡£
¡¡¡¡PHP¿¼Âǵ½Æä°²È«ÐÔ£¬ÒýÈëÁËmagic_quotes_gpc = On/Off Õâ¸ö²ÎÊý£¬¿ÉÒÔÔÚ²»×öÈκδ¦ÀíµÄÇé¿öϾÍÖ±½Ó½«º¬Óе¥ÒýºÅµÄÊý¾Ý²åÈëÊý¾Ý¿âÖС£Èç¹ûmagic_quotes_gpc = Off£¬ÐèÒª¿¼Âǵ¥ÒýºÅµÄÎÊÌâÁË£¬²»ÄÜһζµØÐÅÈÎÆäÔËÐл·¾³¡£
¡¡¡¡µ±magic_quotes_gpc = Onʱ£¬Ê¹ÓÃaddslashes()´¦ÀíºóµÄÊý¾ÝÔÚÊý¾Ý¿âÖн«ÒÔ\'ÐÎʽ±£´æ£¬Èç¹û´Ëʱֱ½ÓÊä³öµÄ»°£¬¾Í»á·¢ÏÖ±È×Ô¼ºÔÏÈÊäÈëµÄÄÚÈݶàÁ˸ö£¨·´Ð±¸Ü£©\£¬Õâʱ¾ÍÐèÒªÓõ½stripslashes()ÁË£¬ËüÄܰÑaddslashes()´¦Àíʱ×Ô¶¯¼ÓÉÏÈ¥µÄ£¨·´Ð±¸Ü£©\È¥µô¡£Õâ¸úÇø±ðÓÚstr_replace("\", "",$str)²»Í¬¡£
¡¡¡¡µ±magic_quotes_gpc = Offʱ£¬Ê¹ÓÃaddslashes()´¦ÀíºóµÄÊý¾ÝÔÚÊý¾Ý¿âÖн«ÒÔ'ÐÎʽ±£´æ£¬²»´æÔÚÉÏÃæËµµÄÓÐ\µÄÎÊÌ⣬addslashes()Æðµ½²åÈëÊý¾Ý²»³ö´íµÄ×÷Óã¬Èç¹û´Ëʱֱ½ÓÊä³öµÄ»°£¬Êý¾ÝÕý³£¡£²»ÐèÒªÔÙÓÃstripslashes()¡£
¡¡¡¡addslashes()ºÍstripslashes()ÕýºÃÊÇÏà·´µÄ£¬addslashes()¼Ó¸ö£¨·´Ð±¸Ü£©\£¬stripslashes()È¥¸ö£¨·´Ð±¸Ü£©\¡£
¡¡¡¡µ±magic_quotes_gpc = Onʱ£¬ÏµÍ³»á×Ô¶¯´¦Àíµ¥ÒýºÅµÈÎÊÌ⣬Óò»ÓÃaddslashes()ºÍstripslashes()¶¼Ã»¹ØÏµ£¬µ«ÊÇÈç¹ûÌí¼ÓÊý¾ÝʱÓÃÁËaddslashes()£¬ÄÇôÏÔʾÊý¾Ýʱ±ØÐëÒªstripslashes()
¡¡¡¡µ±magic_quotes_gpc = Offʱ£¬ÏµÍ³²»»á´¦Àíµ¥ÒýºÅµÈÎÊÌ⣬ËùÒÔ²åÈëÊý¾Ýʱ±ØÐëҪʹÓÃaddslashes()£¬ÏÔʾÊý¾ÝʱÔò²»ÐèҪʹÓÃstripslashes()¡£
¡¡¡¡¼ÈÈ»ÓÐÁË·ÖÎö£¬×ö³ÌÐòʱҪÔõô°ìÄØ£¿¸ù¾ÝÒÔÉÏÁ½ÖÖÇé¿ö£¬¿ÉµÃ£º
¡¡¡¡²»¹Ümagic_quotes_gpcÊÇOn»¹ÊÇOff£¬ÔÛÌí¼ÓÊý¾Ýʱ¶¼ÓÃaddslashes()£¬µ±Onʱ£¬±ØÐëʹÓÃstripslashes()£¬OffʱÔò²»ÄÜÓÃstripslashes()¡£
¡¡¡¡ÈçºÎÅжÏOn»¹ÊÇOffÄØ£¿ÓÃget_magic_quotes_gpc()¡£
Ïà¹ØÎĵµ£º
apache°²×°£¬mysql°²×°£¬php5Ö±½Ó½âѹ£¬¾ù·ÅÔÚD:\wwwÏ¡£
Ŀ¼½á¹¹Îª£º
D:\www\apache2
D:\www\mysql
D:\www\php5
½«php5\php.ini-dist¸´ÖÆÎªphp.ini£¬°ÑÐèÒªÓõ½µÄ×é¼þ½«Ç°ÃæµÄ;È¥µô¡£
Èç
extension=php_mysql.dll
extension=php_gd2.dll
ÔÚapache2µÄconf/httpd.confÎļþÖмÓ
LoadFile D:/www/php5/php5ts.dll
......
MySQLÊý¾Ý¿â±àÂë¡¢htmlÒ³Ãæ±àÂë¡¢PHP»òhtmlÎļþ±¾Éí±àÂëҪȫ²¿Ò»Ö¡£
1¡¢MySQLÊý¾Ý¿â±àÂ룺½¨Á¢Êý¾Ý¿âʱָ¶¨±àÂ루Èçgbk_chinese_ci)£¬½¨Á¢Êý¾Ý±í¡¢½¨Á¢×ֶΡ¢²åÈëÊý¾Ýʱ²»ÒªÖ¸¶¨±àÂ룬»á×Ô¶¯¼Ì³ÐÊý¾Ý¿âµÄ±àÂë¡£
Êý¾Ý¿âÁ¬½Óʱ£¬Ò²ÓбàÂ룬¿ÉÒÔÔÚÁ¬½ÓÍêÊý¾Ý¿âºó£¬Ö´ÐÐ
mysql_query(‘SET NAMES gbk’);//½«gbk» ......
Linuxϰ²×°PHP5µÄÖ÷Òª²½Öè:
1.ÏÂÔØphp5£»µØÖ·£ºhttp://cn.php.net/downloads.php
2.½âѹÈí¼þ°üºó½øÈë¸ÃĿ¼
£¨×ªÕß×¢£º
¿ÉÄÜ»áÐèÒªÏȽâѹphp-5.*.tar.bz2 ,ÏÈÖ´ÐÐbzip2 -d php-5.*tar.bz2
£©
tar -xvf php-5.*.tar.gz
cd php-5.*
3.php°²×°mysqlµÄÄ£¿éµÄһЩ׼±¸¹¤×÷
ln -s /usr/local/mysql/lib/mysql /usr/l ......
Äêǰ°ïsw666Ç¨ÒÆÍøÕ¾µ½ÎÒÃÇ·þÎñÆ÷£¬½á¹û£¬Åú·¢ÖÐÐÄÁ½ÕÅͼƬ²»ÏÔʾ£¬ÉÌÆ·Ìí¼ÓµÄËõÂÔͼ²»ÏÔʾ£¬ÓÉÓÚµÚÒ»´Î´îPHP»·¾³£¬ËùÒÔÕÕ×ÅÍøÉϵĽ̳ÌÒ»²½²½¸ã£¬´îºÃºóÄÜ·ÃÎÊ£¬µ«¾ÍÊÇͼƬÓÐÎÊÌâ¡£ÔõôŪ¶¼¸ã²»¶¨
ǰ¼¸ÌìÖÜÉлԴó¸ç˵ÊÇgd¿âµÄÎÊÌ⣬ÎÒ¾ÍÅäÖÃÁËÏÂphp.iniÎļþ£¬¸Ä³ÉÖ§³ÖÁËgd¿â£¬ºóÃæÒª²é¿´ÊÇ·ñÓÐgd¿â£¬±àдphp.phpÎļþ
< ......