mariadb prepare: Difference between revisions

From Onset Developer Wiki
No edit summary
No edit summary
 
(2 intermediate revisions by one other user not shown)
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 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 ==
__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}}

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"