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()¡£
Ïà¹ØÎĵµ£º
ʹÓùýSQL ServerµÄÈËÓ¦¸Ã¶¼Çå³þ£¬SQL Server³£ÓõÄÓÐÁ½ÖÖÈÏÖ¤·½Ê½£¬Ò»ÖÖÊDZ¾µØÏµÍ³ÕË»§ÈÏÖ¤£¨Windows Authentication £©£¬Ò»ÖÖÊÇʹÓÃÓû§ÃûºÍÃÜÂ루SQL Server Authentication £©£¬µÚ¶þÖÖÈÏÖ¤·½Ê½±ØÐëÆôÓÃSQL ServerµÄ»ìºÏģʽ¡£
¡¡¡¡1.Windows AuthenticationÁ¬½Ó²¿·Ö´úÂë¶Î£º
<?php
$serverName = "(local)";
$co ......
Àý£º
ÒªÇóÆ¥Åä±êÌâ
<div class="detail-hd">
<h3>
Îå»Ê¹Ú 2010´º×°ÐÂÆ·Ê±ÉÐTÐô ³¤Ðä Å®×°³¤¿îTÐô ÈÈÂôº«°æ³¤T ÌØ¼Û
</h3>
$reg="|<div class=\"detail-hd\">[\n\r\t]*<h3>[\n\r\t]*(.*)[\n\r\t]*</h3>|";
pre ......
MySQLÊý¾Ý¿â±àÂë¡¢htmlÒ³Ãæ±àÂë¡¢PHP»òhtmlÎļþ±¾Éí±àÂëҪȫ²¿Ò»Ö¡£
1¡¢MySQLÊý¾Ý¿â±àÂ룺½¨Á¢Êý¾Ý¿âʱָ¶¨±àÂ루Èçgbk_chinese_ci)£¬½¨Á¢Êý¾Ý±í¡¢½¨Á¢×ֶΡ¢²åÈëÊý¾Ýʱ²»ÒªÖ¸¶¨±àÂ룬»á×Ô¶¯¼Ì³ÐÊý¾Ý¿âµÄ±àÂë¡£
Êý¾Ý¿âÁ¬½Óʱ£¬Ò²ÓбàÂ룬¿ÉÒÔÔÚÁ¬½ÓÍêÊý¾Ý¿âºó£¬Ö´ÐÐ
mysql_query(‘SET NAMES gbk’);//½«gbk» ......
linuxÏÂapache+php°²×°³£¼ûÎÊÌâ
configure: error: Unable to find libgd.(a|so)
Èç¹ûʹÓõÄÊÇubuntu»òdebian¾ÍºÜ¼òµ¥ÁË£¬Ö±½Ósudo apt-get install apache2 libapache2-mod-php5 php5 php5-gd ¾Í»ù±¾Éϸ㶨£¬µ«ÊÇÓÃÔ´´úÂë°²×°»¹ÊǺÜÂé·³¡«
wget http://www.boutell.com/gd/http/gd-2.0.11.tar.gz
tar zxvf gd-2.0.11 ......
header
(PHP 3, PHP 4, PHP 5)
header -- ·¢ËÍÒ»¸öÔʼ HTTP ±êÍ·
˵Ã÷
void header ( string string [, bool replace [, int http_response_code]] )
header() º¯ÊýÓÃÀ´·¢ËÍÒ»¸öÔʼ HTTP ±êÍ·¡£ÓÐ¹Ø HTTP ±êÍ·µÄ¸ü¶àÄÚÈݼû HTTP/1.1 ¹æ·¶¡£
¿ÉÑ¡²ÎÊý replace Ö¸Ã÷ÊÇÌæ»»µôǰһÌõÀàËÆµÄ±êÍ·»¹ÊÇÔö¼ÓÒ»ÌõÏàͬÀàÐ͵ ......