mariadb prepare: Difference between revisions
From Onset Developer Wiki
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
== 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
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
- OnQueryError
- mariadb_log
- mariadb_connect
- mariadb_connect_file
- mariadb_close
- mariadb_unprocessed_queries
- mariadb_async_query
- mariadb_query
- mariadb_await_query
- mariadb_query_file
- mariadb_await_query_file
- mariadb_errno
- mariadb_error
- mariadb_escape_string
- mariadb_prepare
- mariadb_set_charset
- mariadb_get_charset
- mariadb_stat
- mariadb_get_row_count
- mariadb_get_field_count
- mariadb_get_result_count
- mariadb_get_field_name
- mariadb_set_result
- mariadb_get_value_index
- mariadb_get_value_index_int
- mariadb_get_value_index_float
- mariadb_get_value_name
- mariadb_get_value_name_int
- mariadb_get_value_name_float
- mariadb_save_result
- mariadb_delete_result
- mariadb_set_active_result
- mariadb_unset_active_result
- mariadb_is_any_result_active
- mariadb_is_valid_result
- mariadb_get_affected_rows
- mariadb_get_warning_count
- mariadb_get_insert_id
- mariadb_get_query_exec_time
- mariadb_get_query_string
- mariadb_get_row
- mariadb_get_assoc
