phpÈçºÎ²ÎÊý»¯sqlÓï¾ä
ÔÚjavaºÍ.net¶¼ÓÐÕâÖÖ»úÖÆ
phpÊÇ·ñÒ²ÓУ¬ÎÒÔÚÍøÉÏËÑÁËÒ»ÏÂ
$db = new mysqli("localhost", "user", "pass", "database");
$stmt = $mysqli -> prepare("SELECT priv from testUsers WHERE username=? AND password=?");
$stmt -> bind_param("ss", $user, $pass);
$stmt -> execute();
µ«ÊÇÔÚideÀïÕÒ²»µ½¶ÔÓ¦µÄ·½·¨£¬¶øÇÒÕâÀà×ÊÁÏÉÙÖ®ÓÖÉÙ
ÊDz»ÊÇphp5аæÖÐÒѾ×Ô¶¯ÄÚÖÃÕâÖÖ¹¦ÄÜ£¬¶ø²»ÐèÒªÊÖ¶¯Ìí¼Ó£¿
²ÎÊý»¯£¿Ã»¸ãÃ÷°×Â¥Ö÷Òâ˼£¡
Â¥Ö÷˵ ÏñJAVA ÄÇÑù£¿£¿£¿£¿£¿£¿
ÀàËÆjava preparedStatement »ò.net µÄ SqlParameter
¹À¼ÆÂ¥Ö÷ÊÇÏëÒª SQLparam
¸úJAVAÓ¦¸Ã»¹ÊÇÓÐÇø±ðµÄ°É£¬JAVAÄÇÊÇÔ¤¶¨Òå±àÒë¡£¶øPHPºÃÏñÖ»ÊǼòµ¥µÄÕýÔòÆ¥ÅäÌæ»»¡£²¢²»ÄÜ´ïµ½Ô¤¶¨Òå±àÒëµÄЧ¹û°É£¿
Ã²ËÆÃ»¼û¹ý£¬²»ÖªµÀÓÐûÓÐphpÓÐÕâÑùµÄ·½·¨¡£
Óеϰ£¬ÎÒҲѧϰһÏÂ~
¸÷λƽʱÊÇÔõô´¦Àí·À×¢ÈëµÄ
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
<?php
/*
¹¦ÄÜ£ºPHPα¾²Ì¬»¯Ò³ÃæµÄʵÏÖ
¾ßÌåÓ÷¨:
ÀýÈçÁ´½ÓΪ:test.php/year/2006/action/_add.html
mod_rewrite();
$yearn= $_GET["year"];//½á¹ûΪ'2006'
......
¿ª·¢PHPÓÃÓÃʲôÈí¼þ£¿
¶à½éÉܼ¸ÖÖ¡£
ÎÒ¶¼²»ÏþµÃ¡£¹þ¹þ¡£ºÃ¾ÍûÓÐÉÏcsdn£¬¿´¼ûÄã·¢ÁËÌù¡£×î½üÔõôÑù£¿£¿£¿
Îı¾±à¼Æ÷¶¼¿ÉÒÔµÄ
±±¾©Î弫ÐÇÐÅϢϵͳ¼¼ÊõÓÐÏÞ¹«Ë¾ÏÖÕÐÆ¸5ÃûPHP³ÌÐòÔ±¡£
ְλҪÇó£º ......