PHPµÄ±àдSQLÓï¾äʱ¶ÔÐèҪתÒå×Ö·ûµÄ´¦Àí
1. ¶ÔÓÚPHP magic_quotes_gpc=onµÄÇé¿ö£¬ ÎÒÃÇ¿ÉÒÔ²»¶ÔÊäÈëºÍÊä³öÊý¾Ý¿âµÄ×Ö·û´®Êý¾Ý×÷
addslashes()ºÍstripslashes()µÄ²Ù×÷,Êý¾ÝÒ²»áÕý³£ÏÔʾ¡£ Èç¹û´ËʱÄã¶ÔÊäÈëµÄÊý¾Ý×÷ÁËaddslashes()´¦Àí£¬
ÄÇôÔÚÊä³öµÄʱºò¾Í±ØÐëʹÓÃstripslashes()È¥µô¶àÓàµÄ·´Ð±¸Ü¡£ 2. ¶ÔÓÚPHP magic_quotes_gpc=off µÄÇé¿ö ±ØÐëʹÓÃaddslashes()¶ÔÊäÈëÊý¾Ý½øÐд¦Àí£¬µ«²¢²»ÐèҪʹÓÃstripslashes()¸ñʽ»¯Êä³ö
ÒòΪaddslashes()²¢Î´½«·´Ð±¸ÜÒ»ÆðдÈëÊý¾Ý¿â£¬Ö»ÊǰïÖúmysqlÍê³ÉÁËsqlÓï¾äµÄÖ´ÐС£ ²Î¿¼×ÊÁÏ: <PHP magic_quotes_gpcµÄÏêϸʹÓ÷½·¨>
Ïà¹ØÎĵµ£º
Ëæ×ÅWeb2.0µÄÉýλ¥ÁªÍøµÄ·¢Õ¹ÓÀ´ÐÂÒ»ÂÖµÄÈȳ±£¬ÓÉÓÚ»¥ÁªÍø±¾ÉíµÄ¿ìËÙ·¢Õ¹¡¢²»¶Ï´´ÐµÄÌØµã£¬¾ö¶¨ÁËÖ»ÓÐÒÔ×î¿ì¿ª·¢ËٶȺÍ×îµÍ³É±¾£¬²ÅÄÜȡʤ£¬²ÅÄÜʼÖÕ±£³ÖÒ»¸öÍøÕ¾µÄÁìÏÈÐÔºÍÎüÒý¸ü¶àµÄÍøÃñ¡£
»¥ÁªÍøµÄÆóÒµÉú´æºÍ¾ºÕùµÄºËÐÄÔÚÓÚ¼¼Êõ£¬¼¼Êõ/Ñз¢È˲ÅÓÀÔ¶ÊÇÕâЩÆóÒµ²»¿É»òȱµÄ¹Ø¼üÈËÎֻÓÐÓµÓÐ×ÊÉ ......
ÒòΪÏîÄ¿ÐèÒª£¬ËùÒÔ×Ô¼ºÐ´ÁËÒ»¸öCRUDÀà
ËäÈ»»¹±È½Ï¼òµ¥£¬²»¹ý¸Ð¾õºÜʵÓá£
×¢£ºcls_databaseÊÇÒ»¸öÊý¾Ý¿â²Ù×÷Àà
¼û£ºhttp://code.google.com/p/cyy0523xc/source/browse/trunk/php/cls_crud.php
<?php
/**
* ×Ô¶¯»¯Êý¾Ý±í²Ù×÷Àà
* @author С²Ì <cyy0523xc@gmail.com>
* @version 1.0
*/
class cls_ ......
PHPÊÇÈõÀàÐÍÓïÑÔ¡£
»ù±¾Êý¾ÝÀàÐÍ£ºinteger¡¢string¡¢boolean¡¢float
¸´ºÏÊý¾ÝÀàÐÍ£ºarray¡¢object
»ù±¾Êý¾ÝÀàÐ;Ͳ»ËµÁË£¬ÏÂÃæ¿´Ò»¸öÊý×éÏà¹ØµÄһЩÀý×Ó¡£
$test1=array(1,2,3,4);//¶¨ÒåÁËÒ»¸ö°üº¬4¸öÊýµÄÊý×é
$test1=array("new1"=>1,"new2"=>2);//Á½¸ö±äÁ¿µÄÊý×é,array['new1']=1,array['new2']=2
¶ ......
PhpÁ¬½ÓmysqlµÄº¯ÊýÈçÏ£º
mysql_connect("Ö÷»úÃû","Óû§Ãû","ÃÜÂë");//´ò¿ªÒ»¸öÁ¬½Ó
mysql_select_db("´ò¿ªÊý¾Ý¿â",Á¬½Ó±êʶ·û);//´ò¿ªÒ»¸öÊý¾Ý¿â
$conn=@mysql_connect("localhost","root","") or die("Á´½Ó´íÎó");ÕâÀï@¿ÉÒÔÒþ²Ø´íÎóÌáʾ,or die¿ÉÒÔÔÚ´íÎóµÄʱºòÏÔʾ¡£
Ö´ÐÐsqlÓï¾äµÄº¯Êý:
mysql_query();
$sql= ......