Home     ReadMe   Plans You need to log in --> login

MySQL Query

Return a single query result from MySQL

Arguments:
- "sql" (string - sql query with ? for placeholders, eg: SELECT COUNT(*) AS count FROM mytable WHERE status=? )
- "params" (text - JSON array of parameters in order as required by query, eg: ["foo"] )

Returns:
JSON array of results, eg: {"count":12}

NB: Don't forget to set your headers and use POST (not GET) for the arguments !!!

Try it out

headers:
POST url:
sql:
params:
You are not logged in
output: