Modules/MySQL/MysqlQuery: Difference between revisions

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 6: Line 6:


==Syntax==
==Syntax==
bool mysqlQuery ( [[mysql]] object, string callback_function, string query )
<syntaxhighlight lang="lua">bool mysqlQuery ( mysql db, string callback_function, string query )</syntaxhighlight>


===Required Arguments===
===Required Arguments===
*'''[[mysql]]''' : The [[mysql]] object returned by [[mysqlOpen]]
*'''db''' : A ''mysql'' object returned by [[mysqlOpen]]
*'''callback_function''' : The function that is called if the operation is done (please see below)
*'''callback_function''' : The function that is called if the operation is done (please see below)
*'''query''' : The MySQL query that is sent
*'''query''' : The MySQL query that is sent

Revision as of 01:24, 1 November 2006

Description

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.

This function is provided by the ml_mysql module.

Syntax

bool mysqlQuery ( mysql db, string callback_function, string query )

Required Arguments

  • db : A mysql object returned by mysqlOpen
  • callback_function : The function that is called if the operation is done (please 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 ( "GOT RESULT" )
	outputServerLog ( table[1][1] )
	outputServerLog ( table[1][2] )
end

function onMySQLOpen ( mysql, result )
	if ( result ) then
		outputServerLog ( "CONNECTED" )
		mysqlQuery ( mysql, "onMySQLResult", "SELECT * FROM test" )
	else
		outputServerLog ( "DIDNT WORK" )
	end
end

function mysqltest ()
	mysqlOpen ( "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 )
end