mariadb prepare

From Onset Developer Wiki
Revision as of 17:29, 18 December 2019 by 28days (talk | contribs)
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