Modules/MySQL/MysqlQuery: Difference between revisions
Jump to navigation
Jump to search
m (→Example) |
No edit summary |
||
Line 5: | Line 5: | ||
==Syntax== | ==Syntax== | ||
<syntaxhighlight lang="lua">bool mysqlQuery ( mysql | <syntaxhighlight lang="lua">bool mysqlQuery ( mysql mysqlobj, string callback_function, string query )</syntaxhighlight> | ||
===Required Arguments=== | ===Required Arguments=== | ||
*''' | *'''mysqlobj''' : A ''mysql'' object created by [[Modules/MySQL/MysqlCreate|mysqlCreate]] | ||
*'''callback_function''' : The function that is called if the operation is done (see below) | *'''callback_function''' : The function that is called if the operation is done (see below) | ||
*'''query''' : The MySQL query that is sent | *'''query''' : The MySQL query that is sent |
Latest revision as of 20:48, 29 September 2009
This function is provided by the external module MySQL. You must install this module to use this function. | |
This functions queries the MySQL server through the MySQL connection that has been opened by mysqlOpen. The result of the query is then passed to the script by calling callback_function. It's syntax and functionality is similar to that of executeSQLSelect.
Syntax
bool mysqlQuery ( mysql mysqlobj, string callback_function, string query )
Required Arguments
- mysqlobj : A mysql object created by mysqlCreate
- callback_function : The function that is called if the operation is done (see below)
- query : The MySQL query that is sent
Callback Arguments
Your callback function has to accept the following arguments.
On success:
- table: The 2-dimensional table where the results are stored in: table [row_index] [column_index].
On failure:
- boolean: False, when no rows are found or an error occured.
Optional Arguments
None
Example
function onMySQLResult ( table ) outputServerLog ( "Printing some test results" ) outputServerLog ( table[1][1] ) outputServerLog ( table[1][2] ) end function onMySQLOpen ( result ) if ( result ) then outputServerLog ( "MySQL connection established." ) mysqlQuery ( db, "onMySQLResult", "SELECT * FROM test" ) else outputServerLog ( "MySQL connection failed." ) end end function mysqltest () db = mysqlCreate () mysqlOpen ( db, "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 ) end