JS+Python（ajax+json）例子
#用户行为分析图def goods_st_pic(request):
return render(request,website.goods_st_pic,None)
#用户行为数据
def goods_st(request):
#连接数据库
conn = MySQLdb.connect(host='120.26.38.125',user='root', passwd='passw0rd',db='jkbrother3',charset='utf8')
sql = "select distinct(g.name), \
g.marked_count, \
g.collected_count,\
g.purchased_count,\
(select sum(count) from adminer_access_record\
where mold ='0' and action_id =g.id) browse_count \
from adminer_goods g, adminer_access_record ar \
where g.id=ar.action_id"
cur = conn.cursor()
#执行sql
cur.execute(sql)
#列出数据
records = cur.fetchall()
result = []
for row in records:
temp = (row,row,row,row,row)
result.append(temp)
conf = {'goods_st':result}
#关闭连接
cur.close()
conn.close()
return HttpResponse(json.dumps(conf))
注意带参数传值，字典：
var tdata = {"time":"2015-05-17"};
//商品统计
$("#traffic_statistics").click(function(){
$.ajax({
type: 'post',
url: base_url + '/statistics/traffic_st',
data : tdata,
success: function(e){
result = JSON.parse(e);
print(result.traffic_st);
}
})
});
#网站流量统计
def traffic_st(request):
time = request.POST["time"]
#连接数据库
页:
[1]