mariadb prepare: Difference between revisions

From Onset Developer Wiki
← Older editNewer edit →
28days (talk | contribs)
833 edits
No edit summary
28days (talk | contribs)
833 edits
No edit summary
Line 2: Line 2:
{{Notice|This function is provided by the official [[MariaDB]] plugin.}}
{{Notice|This function is provided by the official [[MariaDB]] plugin.}}


{{FuncDescription|__EDIT_ME__}}
{{FuncDescription|Prepares a SQL statement with SQL-injection safe query.}}


{{FuncSyntax|mariadb_prepare(handle_id, format_str)}}
{{FuncSyntax|mariadb_prepare(handle_id, format_str)}}
Line 13: Line 13:


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


{{RelatedFunctions}}
{{RelatedFunctions}}
{{Template:MariaDBFunctions}}
{{Template:MariaDBFunctions}}

Revision as of 17:29, 18 December 2019

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

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=3283"