好吧,我承认我问得有点傻。
我用下面方法实现的。
local query = "select qymc as suggestions from SFGL_QY where qymc like " .. xiaoqu
res, err, errno, sqlstate = db:query(query)
if not res then
ngx.say("bad result: ", err, ": ", errno, ": ", sqlstate, ".")
return
end
local result={}
for i, row in ipairs(res) do
result[i] = res[i].suggestions
end
result = {query=
args.name,suggestions=result}
local cjson = require "cjson"
ngx.say(cjson.encode(result))
输出:
{"query":"明","suggestions":["光明一小区","光明二小区","文明一小区","文明二小区","新明苑小区","河明小区","通明苑小区"]}
在 2012年3月8日 下午12:39,lhmwzy <
lh...@gmail.com> 写道:
> 全部用纯lua实现
>
> 输入一个查询条件,名字为xxx
> 然后从数据库中查询,select qymc as suggestions from SFGL_QY where qymc like " .. xxx
>
> 然后,如何将输出的结果表达为json的格式?
> 格式为:
> {"query":"查询条件 xxx","suggestions":["结果1","结果2",.....]}