mariadb get assoc: Difference between revisions
From Onset Developer Wiki
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
{{FuncParam|row_idx|The row index}} | {{FuncParam|row_idx|The row index}} | ||
{{FuncReturnValue|Returns table with the column name as index}} | {{FuncReturnValue|Returns table with the column name as index. Returns '''false''' on error.}} | ||
== Example == | == Example == | ||
| Line 19: | Line 19: | ||
function OnLoadVehicle() | function OnLoadVehicle() | ||
local result = mariadb_get_assoc( | local result = mariadb_get_assoc(1) -- result is now a table with indexes of column name | ||
local id = tostring(result["id"]) -- This means that the result is basically a table, and the index is the column... pretty simple, right? | local id = tostring(result["id"]) -- This means that the result is basically a table, and the index is the column... pretty simple, right? | ||
Latest revision as of 08:42, 2 September 2020
Description
Get the specified row's association in a table with column name as the index.
Syntax
mariadb_get_assoc(row_idx)
Parameters
- row_idx
The row index
Return Value
- Returns table with the column name as index. Returns false on error.
Example
function LoadVehicle()
local query = mariadb_prepare(sql, "SELECT * FROM vehicles WHERE id = 1;")
mariadb_async_query(sql, query, OnLoadVehicle)
end
function OnLoadVehicle()
local result = mariadb_get_assoc(1) -- result is now a table with indexes of column name
local id = tostring(result["id"]) -- This means that the result is basically a table, and the index is the column... pretty simple, right?
local modelid = math.tointeger(result["modelid"])
end
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
