DbExec

2022-07-30T14:21:49Z

Dzakub25: Clarify what does "result" mean

__NOTOC__
{{Server function}}
This function executes a database query using the supplied connection. No query result is returned.
{{Tip|The server command [[Server_Commands#debugdb|debugdb 2]] will output verbose information on each query to a logging file (usually '''logs/db.log''')}}
==Syntax==
<syntaxhighlight lang="lua">
bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )
</syntaxhighlight>
{{OOP||[[connection]]:exec}}
===Required Arguments===
*'''databaseConnection:''' A database connection element previously returned from [[dbConnect]]
*'''query:''' An SQL query. Positions where parameter values will be inserted are marked with a '''?'''

===Optional Arguments===
*'''paramX:''' A variable number of parameters. These must be strings or numbers - it is important to make sure they are of the correct type. Also, the number of parameters passed must be equal to the number of '''?''' characters in the query string.
String parameters are automatically quoted and escaped as required. (If you do not want a string quoted, use '''??''') Make sure that numbers are in number format as a string number is treated differently.

===Returns===
Returns ''true'' unless the connection is incorrect, in which case it returns ''false''.

==Example==
This example executes an INSERT query:
<syntaxhighlight lang="lua">
dbExec( connection, "INSERT INTO table_name VALUES (?,?,?)", "aaa", "bbb", 10 )
</syntaxhighlight>

This example shows how to use '''??''' for parts of the query that are not column values:
<syntaxhighlight lang="lua">
dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue )
</syntaxhighlight><br>
'''''Note''': It is usually good practice to surround table and column names with backticks (`) in case they contain spaces or SQL keywords (and therefore cause syntax errors). This is especially true when using variables for table and column names, as potential problems may not be apparent when the script is first written.''<br>

This example shows how to use backticks and '''??''' for parts of the query that are not column values:
<syntaxhighlight lang="lua">
dbExec( connection, "UPDATE `??` SET `??`=?", tableName, columnName, columnValue )
</syntaxhighlight>

==Requirements==
{{Requirements|1.1.1-9.03341|n/a}}

==See Also==
{{Registry_functions}}

LoadBrowserURL

2020-12-21T14:40:09Z

Dzakub25: Add note about createBrowser being asynchronous, with reference to onClientBrowserCreated

__NOTOC__
{{Client function}}
{{New feature/item|3.0150|1.5||
This function loads the specified URL.
{{Note|You should use [[requestBrowserDomains]] first to request permission to load the url on the client.}}
{{Note|Calling loadBrowserURL right after [[createBrowser]] will not work normally due to the nature of the asynchronous browser interface. Refer to [[onClientBrowserCreated]] for more information.}}
}}

==Syntax==
<syntaxhighlight lang="lua">bool loadBrowserURL ( browser webBrowser, string url [, string postData = "", bool urlEncoded = true ] )</syntaxhighlight>
{{OOP||[[Element/Browser|browser]]:loadURL|url|getBrowserURL}}

===Required arguments===
*'''webBrowser:''' The [[Element/Browser|browser]] element which will load the URL
*'''url:''' The url you want to load. It can either contain a remote website ("http://" prefix) or a website stored within a local resource ("http://mta/local/gui.html" for example, see [[Local_Scheme_Handler|Local Scheme Handler]] for details).

===Optional Arguments===
*'''postData:''' The post data passed to the website. Its content type can be any type (e.g. JSON) if urlEncoded is set to ''false''
*'''urlEncoded:''' If set to ''true'', it will be available f.e. in PHP's $_POST variable (the content type is: ''application/x-www-form-urlencoded'')

===Returns===
Returns ''true'' if the URL was successfully loaded.

==Example==
<syntaxhighlight lang="lua">
-- In order to render the browser on the full screen, we need to know the dimensions.
local screenWidth, screenHeight = guiGetScreenSize()

-- Let's create a new browser in local mode. We will not be able to load an external URL.
local webBrowser = createBrowser(screenWidth, screenHeight, false, false)

-- This is the function to render the browser.
function webBrowserRender()
-- Render the browser on the full size of the screen.
dxDrawImage(0, 0, screenWidth, screenHeight, webBrowser, 0, 0, 0, tocolor(255,255,255,255), true)
end

-- The event onClientBrowserCreated will be triggered, after the browser has been initialized.
-- After this event has been triggered, we will be able to load our URL and start drawing.
addEventHandler("onClientBrowserCreated", webBrowser,
function()
-- After the browser has been initialized, we can load our website.
loadBrowserURL(webBrowser, "https://www.youtube.com/")

-- Now we can start to render the browser.
addEventHandler("onClientRender", root, webBrowserRender)
end
)
</syntaxhighlight>

==See also==
{{CEF_functions}}

[[hu:loadBrowserURL]]
[[RO:loadBrowserURL]]

Multi Theft Auto: Wiki - User contributions [en]

DbExec

LoadBrowserURL