我这样一个数组传过去了,我该怎么接收,怎么样才能保存到数据库中
var data = {
arr_sekuan : [],
arr_pic : [],
arr_guige : [],
arr_pirce2 : [],
arr_shulian : [],
arr_ku : []
}
$('#getInput').click(function(){
for(var i = 0; i < $('.shulian').size(); i++){
data.arr_sekuan[i] = $('.sekuan').eq(i).html();
data.arr_pic[i] = $('.pic').eq(i).val();
data.arr_guige[i] = $('.guige').eq(i).html();
data.arr_pirce2[i] = $('.pirce2').eq(i).val();
data.arr_shulian[i] = $('.shulian').eq(i).val();
data.arr_ku[i] = $('.ku').eq(i).val();
}
$.post("1234.asp",data,function(infomation){window.alert(infomation);});
1234.asp页面
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("GuestBook.mdb")
exec="select * from data"
set rs=server.createobject("adodb.recordset")'
rs.open exec,conn,1,3
for i=1 to Request.Form("guige").count
rs.addnew
rs("guige")=request.form("guige")(i)
rs("pic")=request.form("pic")(i)
rs("sekuan")=request.form("sekuan")(i)
rs("price2")=request.form("price2")(i)
rs("shulian")=request.form("shulian")(i)
rs("ku")=request.form("ku")(i)
rs.update
next
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
------解决思路----------------------
for(var i in data)data[i]=data[i].join(',')
$.post("1234.asp",data,function(infomation){window.alert(infomation);});
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("GuestBook.mdb")
exec="select * from data"
set rs=server.createobject("adodb.recordset")'
rs.open exec,conn,1,3
rs.addnew
rs("guige")=request.form("arr_guige")
'。。。。。。。。。。。。。。。。。。。。。
rs.update
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
------解决思路----------------------
1、把JS数组转成JSON。
2、AJAX的POST请求把JSON字符串传到后台。
3、后台解析JSON成数组对象
------解决思路----------------------
直接js传数组,后台可用数组接收,然后保存数据库就是