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à ......
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÎÒÔÚʹÓÃphpÒ»¶Î´úÂëÖÐ,Ô´´úÂëÊÇ
<input type="file" name="file_source" id="file_source" class="edt" value="<?=$file_source?>">
ÊÇÒ»¸öÉÏ´«Î ......