openresty - nginx - 配置

local function local_print(str)  
    local dbg = io.open("conf/lua/logs/output.txt", "a+")
    local str = str or ""
    if dbg then
        dbg:write(str..'\n')
        dbg:close()
    end
end

local template = require("resty.template")
local redis = require("resty.redis")
local mysql = require("resty.mysql")



local context = {
    title = "测试",
    name = "张三",
    description = "<script>alert(1);</script>",
    script = "alert(1)",
    age = 20,
    hobby = {"电影", "音乐", "阅读"},
    -- score = {"语文" = 90, "数学" = 80, "英语" = 70},
    score2 = {
      {name = "语文", score = 901},
      {name = "数学", score = 810},
      {name = "英语", score = 710},
    },
    file = 'xiaowu'
  }
  


-- 关闭redis链接
local function close_redes( red )
    if not red then
      return
    end
    local ok, err = red:close()
    if not ok then
        local_print("close redis error:" .. err)
    end
end


-- 创建实例
local red = redis:new()
-- 设置超时(毫秒)
red:set_timeout(2000)
-- 建立连接
local ip = "192.168.10.10"
local port = 7000
local ok, err = red:connect(ip, port)
    if not ok then
        return
    end
-- 没有密码不需要写
-- local res, err = red:auth("")
-- if not res then
--     local_print("connect to redis error : " .. err)
--     return
-- end

-- 调用api进行操作
res, err = red:set("msg", "hello world")
if not res then
    local_print("set msg error : " .. err)
end

local resp, err = red:get("msg")
if not resp then
    local_print("get msg erro:" .. err)
else
    context.title = resp
end


close_redes(red)

---------------------------------------------------------------------------------------
local function close_db( db )
    if not db then
      return
    end
    db:close()
  end
  
  
  -- 创建实例
  local db, err = mysql:new()
  if not db then
    local_print("new  mysql error:" .. err)
    return
  end
  -- 设置超时时间(毫秒)
  db:set_timeout(5000)
  
  local props = {
    host = "192.168.10.5",
    port = 3306,
    database = "union",
    user = "rshy",
    password = "123456"
  }
  
  local res, err, errno, sqlstate = db:connect(props)
  
  if not res then
    local_print("connect to mysql error : " .. err, " , errno : " .. errno, " , sqlstate : " .. sqlstate)
    return close_db(db)
  else
    local select_sql = "select teacherid from teacher limit 2"
    res, err, errno, sqlstate = db:query(select_sql)
    if not res then
        local_print("select error : " .. err, " , errno : " .. errno, " , sqlstate : " .. sqlstate)
        return close_db(db)
    else
        for k, v in pairs(res) do
            local_print(k .. v.teacherid)
        end
    end

  end
---------------------------------------------------------------------------------------


template.render("t1.html", context)
local function local_print(str)  
    local