mariadb prepare

From Onset Developer Wiki
Revision as of 09:13, 2 September 2020 by BlueMountains (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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