jqcx.lua:
local args = ngx.req.get_uri_args()
--ngx.req.read_body()
--local args = ngx.req.get_post_args()
local name =
args.namelocal page = args.page
local action = "">
action = "">local mysql = require "resty.mysql"
local db = mysql:new()
db:set_timeout(30000) -- 1 sec
local ok, err, errno, sqlstate = db:connect({
host = "127.0.0.1",
port = "3306",
database = "jmsf",
user = "root",
password = "yjiawje",
max_packet_size=10485760})
if not ok then
ngx.say("failed to connect: ", err, ": ", errno, " ", sqlstate)
return
end
local query
query="select count(*) as t from SF_SFXXK"
res, err, errno, sqlstate = db:query(query)
if not res then
ngx.say("bad result: ", err, ": ", errno, ": ", sqlstate, ".")
return
end
local content
content = [[
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<title></title>
<link href="" type=text/css rel=stylesheet>
<script language="_javascript_" src=""><script language="_javascript_" src=""><script>
$(function(){
$("#pos1").paginate({
count:]] .. res[1].t .. [[,
start:1,
display:10,
border:true,
border_color: '#BEF8B8',
text_color:'#79B5E3',
background_color: '#E3F2E1',
border_hover_color: '#68BA64',
text_hover_color: '#2573AF',
background_hover_color: '#CAE6C6',
images: false,
mouse: 'press',
onChange: function(page){
$("#content").load("/mysqlcxjq?page="+page);
}
});
$("#content").ajaxSend(function(event, request, settings){
$(this).html("<img src="" /> 正在读取。。");
});
});
</script>
</head>
<body>
<form action="" id="form" name="form" method="post" _onsubmit_="return false;">
一卡通交费情况查询-->请输入姓名:<input id="name" name="name" type="text" value="">
<input id="Button1" type="button" value="查看" _onclick_="getData()">
<br><input type="text" id="xiaoqu" name="xiaoqu">
</form>
<div id="count"></div>
<br>
<div id="content">
</div>
<div id="pos1">
</div>
</body>
</html>
]]
ngx.say(content)
只要 中间这行 count:]] .. res[1].t .. [[,有，就会让浏览器死掉。
