在测试过程中,经常需要自己本地构造注入点来进行SQL测试,这边分享一下,不同环境下构造SQL注入的代码。
PHP+MYSQL版
<?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); }
在测试过程中,经常需要自己本地构造注入点来进行SQL测试,这边分享一下,不同环境下构造SQL注入的代码。
PHP+MYSQL版
<?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); }
mysql_select_db(“test”, $con);
$id = $_REQUEST[ ‘id’ ];
$query = "SELECT * FROM admin WHERE username = $id ";
r e s u l t < / s p a n > < s p a n c l a s s = " p u n " > = < / s p a n > < s p a n c l a s s = " p l n " > m y s q l q u e r y < / s p a n > < s p a n c l a s s = " p u n " > ( < / s p a n > < s p a n c l a s s = " p l n " > result </span><span class="pun">=</span><span class="pln"> mysql_query</span><span class="pun">(</span><span class="pln"> result</span><spanclass="pun">=</span><spanclass="pln">mysqlquery</span><spanclass="pun">(</span><spanclass="pln">query);
while(
r
o
w
<
/
s
p
a
n
>
<
s
p
a
n
c
l
a
s
s
=
"
p
u
n
"
>
=
<
/
s
p
a
n
>
<
s
p
a
n
c
l
a
s
s
=
"
p
l
n
"
>
m
y
s
q
l
f
e
t
c
h
a
r
r
a
y
<
/
s
p
a
n
>
<
s
p
a
n
c
l
a
s
s
=
"
p
u
n
"
>
(
<
/
s
p
a
n
>
<
s
p
a
n
c
l
a
s
s
=
"
p
l
n
"
>
row </span><span class="pun">=</span><span class="pln"> mysql_fetch_array</span><span class="pun">(</span><span class="pln">
row</span><spanclass="pun">=</span><spanclass="pln">mysqlfetcharray</span><spanclass="pun">(</span><spanclass="pln">result))
{
echo $row[‘0’] . " " . $row[‘1’];
echo “<br />”;
}
echo “<br/>”;
echo $query;
mysql_close($con);
?>
ASP+MSSQL版
<% strSQLServerName = "127.0.0.1" '服务器名称或地址 strSQLDBUserName = "sa" '数据库帐号 strSQLDBPassword = "andyou" '数据库密码 strSQLDBName = "test" '数据库名称 Set conn = Server.CreateObject("ADODB.Connection") strCon = "Provider=SQLOLEDB.1;Persist Security Info=False;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";" conn.open strCon set rs=Server.CreateObject("ADODB.recordset") id = request("id") sql="select * from admin where id="&id Response.Write(sql) rs.Open sql,conn %>
<table border=“1” width=“100%”>
<tr>
<%for each x in rs.Fields
response.write("<th>" & x.name & “</th>”)
next%>
</tr>
<%do until rs.EOF%>
<tr>
<%for each x in rs.Fields%>
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%>
</tr>
<%loop
rs.close
conn.close%>
</table>
ASP.NET+MSSQL版
<%@ Page Language="C#" AutoEventWireup="true" %> <%@ Import Namespace="System.Data" %> <%@ Import namespace="System.Data.SqlClient" %> <!DOCTYPE html> <script runat="server"> private DataSet resSet=new DataSet(); protected void Page_Load(object sender, EventArgs e) { String strconn = "server=.;database=test;uid=sa;pwd=andyou"; string id = Request.Params["id"]; //string sql = string.Format("select * from admin where id={0}", id); string sql = "select * from admin where id=" + id; SqlConnection connection=new SqlConnection(strconn); connection.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, connection); dataAdapter.Fill(resSet); DgData.DataSource = resSet.Tables[0]; DgData.DataBind(); Response.Write("执行语句:<br>"+sql); Response.Write("<br>结果为:"); }
</script>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head runat=“server”>
<meta http-equiv=“Content-Type” content=“text/html; charset=utf-8”/>
<title></title>
</head>
<body>
<form id=“form1” runat=“server”>
<div>
</span><span class="tag"><asp:DataGrid</span><span class="pln"> </span><span class="atn">ID</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">DgData</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">runat</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">server</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">White</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">BorderColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#3366CC</span></span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #000000;"><span class="pln">
</span><span class="atn">BorderStyle</span></span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">None</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">BorderWidth</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">1px</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">CellPadding</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">4</span></span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #000000;"><span class="pln">
</span><span class="atn">HeaderStyle</span></span><span class="atn">-CssClass</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">head</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">Width</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">203px</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="tag">></span><span class="pln">
</span><span class="tag"><FooterStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#99CCCC</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#003399</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="tag">/></span><span class="pln">
</span><span class="tag"><SelectedItemStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#009999</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">Font-Bold</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">True</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#CCFF99</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="tag">/></span><span class="pln">
</span><span class="tag"><PagerStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#99CCCC</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#003399</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">HorizontalAlign</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">Left</span></span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #000000;"><span class="pln">
</span><span class="atn">Mode</span></span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">NumericPages</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="tag">/></span><span class="pln">
</span><span class="tag"><ItemStyle</span><span class="pln"> </span><span class="atn">BackColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">White</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="atn">ForeColor</span><span class="pun">=</span><span style="color: #800000;"><span class="atv">"</span></span><span style="color: #800000;"><span class="atv">#003399</span></span><span style="color: #800000;"><span class="atv">"</span></span><span class="pln"> </span><span class="tag">/></span><span class="pln">
<HeaderStyle CssClass=“head” BackColor="#003399" Font-Bold=“True” ForeColor="#CCCCFF"></HeaderStyle>
</asp:DataGrid>
</span><span class="tag"></div></span><span class="pln">
</span><span class="tag"></form></span><span class="pln">
</body>
</html>
mssql构造数据库如下:
------------------------------------------------------------------------------------