php»º´æÐĵÃ
SQL²éѯ»º´æ
Êʺ϶ÁÕß
±¾½Ì³ÌÊʺÏÓÚÄÇЩ¶Ô»º´æSQL²éѯÒÔ¼õÉÙÊý¾Ý¿âÁ¬½ÓÓëÖ´ÐеĸºÔØ¡¢Ìá¸ß½Å±¾ÐÔÄܸÐÐËȤµÄPHP³ÌÐòÔ±¡£
¸ÅÊö
Ðí¶àÕ¾µãʹÓÃÊý¾Ý¿â×÷ΪվµãÊý¾Ý´æ´¢µÄÈÝÆ÷¡£Êý¾Ý¿â°üº¬Á˲úÆ÷ÐÅÏ¢¡¢Ä¿Â¼½á¹¹¡¢ÎÄÕ»òÕßÁôÑÔ±¾£¬ÓÐЩÊý¾ÝºÜ¿ÉÄÜÊÇÍêÈ«¾²Ì¬µÄ£¬ÕâЩ½«»á´ÓÒ»¸ö»º´æϵͳÖеõ½µÄ¼«´óºÃ´¦¡£
ÕâÑùÒ»¸öϵͳͨ¹ý°ÑSQL²éѯµÄ½á¹û»º´æµ½ÏµÍ³µÄÒ»¸öÎļþÖд洢£¬´Ó¶ø×èÖ¹Á¬½ÓÊý¾Ý¿â£¬¹¹Ôì²éѯÓëÈ¡µÃ·µ»Ø½á¹û¶øÌá¸ßÁËÏìӦʱ¼ä¡£
ÓÐЩϵͳÊý¾Ý¿â²¢²»ÊÇ·ÅÔÚWEB·þÎñÆ÷Éϵģ¬ÕâÑùÐèÒªÒ»¸öÔ¶³ÌÁ¬½Ó(TCP»òÕßÆäËüÀàËƵÄ)£¬»òÕß´ÓÊý¾Ý¿âÖлñÈ¡´óÁ¿µÄÊý¾Ý£¬ÕâÑùÄãµÃÈÌÊܸü¶àʱ¼ä£¬Õâ¾ö¶¨ÓÚϵͳÏìӦʱ¼äÓë×ÊÔ´ÀûÓá£
Ç°Ìá
±¾½Ì³ÌʹÓÃMySQL×÷ΪÊý¾Ý¿â¡£ÄãÐèÒª°²×°MySQL(www.mysql.comÏÂÔØÊÇÓÐЧµÄ)ºÍ¼¤»îPHP MYSQLÀ©Õ¹(ĬÈÏÇé¿öÊǼ¤»îµÄ)¡£
ÓÉÓÚÒª²éѯÊý¾Ý¿â£¬ÄãÐèҪ֪ʶһЩSQL£¨½á¹¹»¯²éѯÓïÑÔ£©µÄ»ù±¾³£Ê¶¡£
»º´æSQL²éѯ½á¹û
ΪʲôҪ»º´æ²éѯ½á¹û£¿
»º´æ²éѯ½á¹ûÄܼ«´óµØ¸Ä½ø½Å±¾Ö´ÐÐʱ¼äºÍ×ÊÔ´ÐèÇó¡£
»º´æSQL²éѯ½á¹ûÒ²ÔÊÐíÄãͨ¹ýºóÆÚ´¦ÀíÊý¾Ý¡£Èç¹ûÄãÓÃÎļþ»º´æÈ¥´æ´¢È«²¿½Å±¾µÄÊä³ö½á¹û£¨HTMLÊä³ö£©£¬ÕâÑù¿ÉÄÜÊÇÐв»Í¨µÄ¡£
µ±ÄãÖ´ÐÐÒ»¸öSQL²éѯʱ£¬µãµäµÄ´¦Àí¹ý³ÌÊÇ£º
<!--[if !supportLists]-->l <!--[endif]-->Á¬½ÓÊý¾Ý¿â
<!--[if !supportLists]-->l <!--[endif]-->×¼±¸SQL²éѯ
<!--[if !supportLists]-->l <!--[endif]-->·¢ËͲéѯµ½Êý¾Ý¿â
<!--[if !supportLists]-->l <!--[endif]-->È¡µÃ·µ»Ø½á¹û
<!--[if !supportLists]-->l <!--[endif]-->¹Ø±ÕÊý¾Ý¿âÁ¬½Ó
ÒÔÉÏ·½·¨·Ç³£Õ¼ÓÃ×ÊÔ´²¢ÇÒÏà·´µÄÓ°ÏìÁ˽ű¾µÄÐÔÄÜ¡£Ö»ÄÜͨ¹ýÈ¡µÃµÄ´óÁ¿·µ»ØÊý¾ÝºÍÊý¾Ý¿â·þÎñÆ÷µÄλÖÃÕâ¶þ¸öÒªËØÀ´Ï໥е÷¡£¾¡¹Ü³ÖÐøÁ¬½Ó¿ÉÒԸĽøÁ¬½ÓÊý¾Ý¿âʱµÄ¸ºÔØ£¬µ«·Ç³£ºÄ·ÑÄÚ´æ×ÊÔ´£¬Èç¹û»ñÈ¡µÄÊÇ´óÁ¿µÄÊý¾Ý£¬ÄÇô´æ´¢µÄÈ«²¿Ê±¼ä»á·Ç³£¶ÌÔÝ¡£
´´½¨Ò»ÌõSQL²éѯ£º
SQL(½á¹¹»¯²éѯÓïÑÔ)²éѯ±»ÓÃ×÷²Ù×÷Êý¾Ý¿â¼°ËüÄÚÈݵĽӿڡ£SQL¿ÉÓÃÓÚ¶¨ÒåºÍ±à¼±íµÄ½á¹¹£¬²åÈëÊý¾Ýµ½±í£¬¸üлòɾ³ý±íÖеÄÐÅÏ¢¡£
SQLÊÇÓÃÓÚÓëÊý¾ÝͨѶµÄÓïÑÔ£¬ÔÚ´ó¶àÊýPHPÊý¾Ý¿âÀ©Õ¹(MySQL,ODBC,OracleµÈ)ͨ¹ý´«µÝ
Ïà¹ØÎĵµ£º
ÍøÉϹØÓÚÕâÀàµÄÌû×ÓÕæµÄºÜ¶à£¬µ«ÊÇÎÒÊÔÁ˺ܶ࣬ÀýÈç°Ñphp plus for eclipse ÏÂÔØÏÂÀ´£¬½âѹºó·Åµ½EclipseµÄpluginÀïÃ棬µ«ÊDz»ÖªµÀΪʲô£¬¶¼²»¹ÜÓá£
ÎÒ´ÓÍøÉÏÕÒµ½ÁËÒ»ÖֱȽϼòµ¥µÄ·½·¨£ºÄǾÍÊÇÓÉEclipse×Ô¼ºÀ´¸üÐÂ×Ô¼ºµÄ×é¼þ£¬ÕâÑùµÄ·½·¨Ê¡È¥Á˺ܶàµÄÅäÖ㬿ÉÒÔÖ±½ÓÄ ......
OpenX adserver version 2.8.1 and lower is vulnerable to remote code
execution. To be exploited, this vulnerability requires banner / file
upload permissions, such as granted to the 'advertiser' and
'administrator' roles.
This vulnerability is caused by the (insecure) file upload mechanism of
af ......
´ËƪÎÄÕÂ×¼±¸·Ö2¸ö²¿·ÖÀ´½²Êö£º
µÚÒ»²¿·ÖÖ÷ÒªÏêϸ½²ÊöÒ»ÏÂÔõô¹¹½¨Ò»¸öÍê³ÉµÄC++Ó¦ÓÃÀ©Õ¹Ä£¿é£»
µÚ¶þ²¿·ÖÖ÷Òª½²ÊöÔÚPHP¼°Zend¿ò¼ÜÏÂÔõôʹÓÃZend APIºÍC++ÓïÑÔÀ´ÊµÏÖ×Ô¼ºËùÒªµÄ¹¦ÄÜÒÔ¼°ÏîÄ¿µÄ¿ª·¢£»
´ËƪÎÄÕÂËùÔËÓõĻ·¾³ÔÚLinux
2.4.21-4.ELsmp(Red Ha ......
<?php
$link=mysql_connect("localhost","root","root");
$db=mysql_select_db("bustest",$link);
$sql1="select name from info group by name order by id asc";
print("<table border='1'>");
$res1=mysql_query($sql1);
while($row1=mysql_fetch_array($res1)){
$name=$row1["name"];
$sql2="select i ......
ÔÚÅäÖÃeventumµÄÓʼþ·þÎñµÄʱºò£¬Ê¼ÖÕ²»ÄÜ·¢Óʼþ¡£×¥°üºó·¢ÏÖ¸ù±¾¾ÍûÓÐÁ¬½Óµ½Óʼþ·þÎñÆ÷¡£ÔÙÒ»²é£¬ÔÀ´ÊÇ·þÎñÆ÷ôÓÐ
°²×°IMAP¡£ÏÂÃæÊÇ°²×°Ç°ÕÒµ½µÄ×ÊÁÏ~~~
¡¾×ªÔØ¡¿
°²×°sugarcrm£¬Èç¹ûÄã²»°²×°imap£¬ÄÇôÄã¾ÍÎÞ·¨Ê¹ÓõÄËûµÄÓʼþ¹¦ÄÜ£¬ËûµÄÓʼþ¹¦ÄÜÊÇͨ¹ýimapÈ¥¶ÁÔ¶³ÌµÄÓʼþ¡£
ΪÁËÕâ¸öÄ£¿é£¬ÎÒ¿ÉÊÇÑо¿ÁËÒ»¸öÏÂÎ磬 ......