mariadb prepare: Difference between revisions

From Onset Developer Wiki
← Older edit
28days (talk | contribs)
833 edits
No edit summary
No edit summary
 
(One intermediate revision by one other user not shown)
Line 10: Line 10:
{{FuncParam|format_str|The query to prepare}}
{{FuncParam|format_str|The query to prepare}}


{{FuncReturnValue|String with sql-injection safe query}}
{{FuncReturnValue|String with sql-injection safe query, or '''false''' if there's an error in query.}}


== Example ==
== Example ==
<syntaxhighlight lang="Lua">
<syntaxhighlight lang="Lua">
local query = mariadb_prepare(db, "SELECT * FROM accounts WHERE steamid = ? LIMIT 1",
local query = mariadb_prepare(db, "SELECT * FROM accounts WHERE steamid = ? LIMIT 1;",
     tostring(GetPlayerSteamId(player))
     tostring(GetPlayerSteamId(player))
)
)

Latest revision as of 09:13, 2 September 2020

mariadb prepare

Type: Function
Context: Server
Introduced: v1.0

NOTICE

This function is provided by the official MariaDB plugin.

Description

Prepares a SQL statement with SQL-injection safe query.

Syntax

mariadb_prepare(handle_id, format_str)

Parameters

  • handle_id
    The databse handle identifier
  • format_str
    The query to prepare

Return Value

  • String with sql-injection safe query, or false if there's an error in query.

Example

local query = mariadb_prepare(db, "SELECT * FROM accounts WHERE steamid = ? LIMIT 1;",
    tostring(GetPlayerSteamId(player))
)
mariadb_async_query(db, query, OnAccountLoad, player)

See also

Retrieved from "https://dev.playonset.com/index.php?title=mariadb_prepare&oldid=4292"