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
Ïà¹ØÎĵµ£º
#apt-get install apache2
//°²×°apahce2
#apt-get install php5
//°²×°php5
#apt-get install mysql-server
//°²×°mysql·þÎñ¶Ë
#apt-get install mysql-myclient
//°²×°mysqlµÄ¿Í»§¶Ë
#apt-get install php-mysql
//°²×°php-mysqlµÄÁ¬½á
apache+php+mysql »·¾³ÒѾ´î½¨ºÃÁË
½«ÒÔϵķþÎñÖØÆôÒ»ÏÂ
#/et ......
·Ã¿Í¼ÆÊýÆ÷µÄÁ÷³ÌÈçÏÂ
µÚһλÓû§ä¯ÀÀijҳ¡£
·þÎñÆ÷³ÌÐò´ÓÊý¾Ý¿â»òÎļþÖжÁÈ¡¸ÃÒ³±»ä¯ÀÀ´ÎÊý¡£
½«´ÎÊý¼ÓÒ»´¢´æ£¬²¢½«ËüËͻصÚһλÓû§¡£
µÚ¶þλÓû§ä¯ÀÀijҳ¡£
·þÎñÆ÷³ÌÐò´ÓÊý¾Ý¿â»òÎļþÖжÁÈ¡¸ÃÒ³±»ä¯ÀÀ´ÎÊý¡£
½«´ÎÊýÔÙ¼ÓÒ»´¢´æ£¬²¢½«ËüËͻصڶþλÓû§¡£
<?php
$filename="./visit";
$handle=fop ......
php°²×°³ÌÐòÔÀí£º
ÆäʵPHP³ÌÐòµÄ°²×°ÔÀíÎ޷ǾÍÊǽ«Êý¾Ý¿â½á¹¹ºÍÄÚÈݵ¼Èëµ½ÏàÓ¦µÄÊý¾Ý¿âÖУ¬´ÓÕâ¸ö¹ý³ÌÖÐÖØÐÂÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄ²ÎÊýºÍÎļþ£¬ÎªÁ˱£Ö¤²»±»±ðÈ˶ñÒâʹÓð²×°Îļþ£¬µ±°²×°Íê³ÉºóÐèÒªÐ޸ݲװÎļþ¡£
²½Ö裺
¼ì²éĿ¼»òÎļþµÄȨÏÞ
Ð޸ĻòÌî¼ÓÅäÖÃÎļþ
¼ì²éÅäÖÃÎļþÕýÈ·ÐÔ
µ¼ÈëÊý¾Ý¿â
Ëø¶¨»òÉ ......
²Î¿¼×ÊÁÏ£º
1.
2. http://www.phpeclipse.com/wiki/Howto/XDebugAndPHPEclipse
1.ÏÂÔØXDebug http://xdebug.org/download.php
Ñ¡ÔñÓÚPHP°æ±¾Ïà¶ÔÓ¦µÄµÄ 5.2 VC6 (32 bit) ÏÂÔØ£¬¸ÄÃû³Éphp_xdebug.dllºó¸´ÖƵ½E:/APMServ5.2.6/PHP/ext/ÖÐ
2£® ÔÚphp.iniÖÐÌí¼ÓÒÔÏÂÄÚÈÝ£¬²¢½«zendµÄÆäËûÓ¦Óùصô£¨×¢Ê͵ôÆäËûzend_extens ......
phpÎļþ
<?php
mysql_connect("localhost","","");
mysql_query("set names 'gb2312'");
mysql_select_db("shop");
$sqlstr="select * from goods";
require 'smarty/libs/Smarty.class.php';
$smarty = new Smarty;//ÉèÖø÷¸öĿ¼µÄ·¾¶£¬ÕâÀïÊǰ²×°µÄÖØµã
$smarty->template_dir ="smarty/templates/templa ......