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ÓÐÕâÑùµÄ·½·¨¡£
Óеϰ£¬ÎÒҲѧϰһÏÂ~
¸÷λƽʱÊÇÔõô´¦Àí·À×¢ÈëµÄ
Ïà¹ØÎÊ´ð£º
ʹÓÃPHPµÄexecº¯Êýµ÷ÓÃlinuxµÄshellÃüÁÈçdateÈ¥ÐÞ¸Äʱ¼ä»òshutdownȥʵÏֹػú/ÖØÆô£¬µ«ÊÇ·µ»ØÖµ¶¼ÊÇʧ°ÜµÄ¡£¾¹ý¶à´ÎÊÔÑ飬È϶¨ÊÇûÓÐȨÏÞµÄÎÊÌâ¡£
ËùÒÔ£¬Ð¡µÜÔÚ´ËÇë½Ì¸÷룬ÈçºÎ²ÅÄÜÉèÖÃȨÏÞ£¬µ÷ÓÃlinux shellà ......
½«Ò»¸ö±í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¿ª·¢¸ß¼¶¹¤³Ìʦ
ÕÐÆ¸ÈËÊý 1
¹¤×÷µØµã ÉϺ£
нˮ´ýÓö ÃæÒé
µç×ÓÓÊÏä zik@yynet.cn
¹«Ë¾ÍøÖ· http://www.yynet.cn
¹«Ë¾½éÉÜ Ò½ÔªÍø-רעҽ»¼»¥¶¯£¬¼ÜÆðÒ½»¼ ......
PHPÖÐtitleÈçºÎ¶¯Ì¬ÏÔʾµ±Ç°ÎÄÕµıêÌâ?
ÔÚtitleÖÐÿƪÎÄÕ¶¼ÊÇÏÔʾͬÑùµÄÄÚÈÝ.ÏëÈÃËû¶¯Ì¬ÏÔʾ.²»ÖªµÀÒªÈçºÎд²ÅÄܶ¯Ì¬ÏÔʾµ±Ç°ÎÄÕµıêÌâÄØ?
лл
PHPÖÐtitle£¿Ã»Ã÷°×£¬ÊDz»ÊÇHTMLµÄtitle°¡
Èç¹ûÊǵϰ£¬Äã¿ÉÒÔ ......