Difference between revisions of "mariadb get assoc"

From Onset Developer Wiki
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|Get the specified row's association.}}
{{FuncDescription|Get the specified row's association in a table with column name as the index.}}


{{FuncSyntax|mariadb_get_assoc(row_idx)}}
{{FuncSyntax|mariadb_get_assoc(row_idx)}}
Line 9: Line 9:
{{FuncParam|row_idx|The row index}}
{{FuncParam|row_idx|The row index}}


{{FuncReturnValue|__EDIT_ME__}}
{{FuncReturnValue|Returns table with index as the column name}}


== Example ==
== Example ==
<syntaxhighlight lang="Lua">
<syntaxhighlight lang="Lua">
-- code
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(i) -- 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
</syntaxhighlight>
</syntaxhighlight>


{{RelatedFunctions}}
{{RelatedFunctions}}
{{MariaDBFunctions}}
{{MariaDBFunctions}}

Revision as of 16:42, 11 April 2020

mariadb get assoc

Type: Function
Context: Server
Introduced: v1.0

NOTICE

This function is provided by the official MariaDB plugin.

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 index as the column name

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(i) -- 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