lua-resty-mysql icon indicating copy to clipboard operation
lua-resty-mysql copied to clipboard

PDO style query

Open kmaneesh opened this issue 8 years ago • 3 comments

Do we have PDO style query in lua-resty-mysql The query and params can be sent separately rather than a string and it takes care of sql injection etc.

kmaneesh avatar Nov 11 '15 21:11 kmaneesh

@kmaneesh No, this is still a TODO. Patches welcome :)

agentzh avatar Nov 15 '15 15:11 agentzh

How would one escape a potentially dangerous SQL string before concatenating it in lieu of this?

brendon avatar May 24 '17 02:05 brendon

Sorry I found it: https://github.com/openresty/lua-resty-mysql#sql-literal-quoting

brendon avatar May 24 '17 22:05 brendon