View source for DbExec

<!-- This page is generated automatically from the function definition: dbExec. -->
= dbExec =
Executes a prepared SQL statement when no row result is required.

== Syntax ==
<syntaxhighlight lang="lua">
bool dbExec(DatabaseConnection connection, string statement, ...)
</syntaxhighlight>

== Parameters ==
{| class="wikitable"
! Name !! Type !! Required !! Description
|-
| <code>connection</code> || <code>DatabaseConnection</code> || yes || The connection used to execute the statement.
|-
| <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 placeholders.
|}

== Returns ==
Returns <code>true</code> when the statement is queued successfully; otherwise returns <code>false</code>.

== Examples ==
Update a player's level safely:
<syntaxhighlight lang="lua" line>
local ok = dbExec(db,
    "UPDATE players SET level = ? WHERE id = ?",
    newLevel,
    playerId
)

if not ok then
    outputDebugString("Could not queue level update", 1)
end
</syntaxhighlight>

== Notes ==
* Available only in server-side resource scripts.
* Use placeholders instead of concatenating untrusted values into SQL.

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