QCherry: Automatyczna aktualizacja dokumentacji funkcji

2026-08-04T12:44:10Z

Automatyczna aktualizacja dokumentacji funkcji

New page

= dbQuery =
Starts an asynchronous prepared SQL query.

== Syntax ==
<syntaxhighlight lang="lua">
DatabaseQuery dbQuery([function callback, table callbackArguments,] DatabaseConnection connection, string statement, ...)
</syntaxhighlight>

== Parameters ==
{| class="wikitable"
! Name !! Type !! Required !! Description
|-
| <code>callback</code> || <code>function</code> || no || Optional function called when the result becomes available.
|-
| <code>callbackArguments</code> || <code>table</code> || no || Optional values passed to the callback after the query handle.
|-
| <code>connection</code> || <code>DatabaseConnection</code> || yes || The connection used to execute the query.
|-
| <code>statement</code> || <code>string</code> || yes || SQL containing <code>?</code> value placeholders.
|-
| <code>...</code> || <code>nil/bool/number/string</code> || no || Values bound to the statement placeholders.
|}

== Returns ==
Returns a <code>DatabaseQuery</code> handle on success, or <code>false</code> if the query could not be queued.

== Examples ==
Load one player asynchronously:
<syntaxhighlight lang="lua" line>
dbQuery(function(query)
local rows = dbPoll(query, 0)
if rows then
for _, row in ipairs(rows) do
print(row.name, row.level)
end
end
end, {}, db, "SELECT name, level FROM players WHERE id = ?", playerId)
</syntaxhighlight>

== Notes ==
* Available only in server-side resource scripts.
* Prefer the callback form so that the server script does not block while waiting for the database.

[[Category:Server Functions]]
[[Category:Database Functions]]

DbQuery - Revision history

QCherry: Automatyczna aktualizacja dokumentacji funkcji