Modules/MySQL/MysqlQuery - Revision history

Sebassje at 20:48, 29 September 2009

2009-09-29T20:48:18Z

← Older revision		Revision as of 20:48, 29 September 2009
Line 5:		Line 5:

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

	===Required Arguments===		===Required Arguments===
	*'''db''' : A ''mysql'' object created by [[Modules/MySQL/MysqlCreate\|mysqlCreate]]		*'''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

Awwu: /* Example */

2008-06-15T08:30:24Z

Example

← Older revision		Revision as of 08:30, 15 June 2008
Line 49:		Line 49:
	end		end
	</syntaxhighlight>		</syntaxhighlight>
	~~[[Category:Scripting Concepts]]~~

Borov at 16:39, 8 May 2008

2008-05-08T16:39:35Z

← Older revision		Revision as of 16:39, 8 May 2008
Line 49:		Line 49:
	end		end
	</syntaxhighlight>		</syntaxhighlight>
			[[Category:Scripting Concepts]]

IJs at 22:00, 29 January 2007

2007-01-29T22:00:56Z

← Older revision		Revision as of 22:00, 29 January 2007
Line 2:		Line 2:
	{{ModuleFunction\|MySQL}}		{{ModuleFunction\|MySQL}}

	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 functions queries the MySQL server through the MySQL connection that has been opened by [[Modules/MySQL/MysqlOpen\|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==		==Syntax==
Line 8:		Line 8:

	===Required Arguments===		===Required Arguments===
	*'''db''' : A ''mysql'' object created by [[mysqlCreate]]		*'''db''' : 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

IJs at 21:54, 29 January 2007

2007-01-29T21:54:48Z

← Older revision		Revision as of 21:54, 29 January 2007
Line 8:		Line 8:

	===Required Arguments===		===Required Arguments===
	*'''db''' : A ''mysql'' object ~~returned~~ by [[~~mysqlOpen~~]]		*'''db''' : A ''mysql'' object created by [[mysqlCreate]]
	*'''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 (see below)
	*'''query''' : The MySQL query that is sent		*'''query''' : The MySQL query that is sent

Line 30:		Line 30:
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	function onMySQLResult ( table )		function onMySQLResult ( table )
	outputServerLog ( "~~GOT RESULT~~" )		outputServerLog ( "Printing some test results" )
	outputServerLog ( table[1][1] )		outputServerLog ( table[1][1] )
	outputServerLog ( table[1][2] )		outputServerLog ( table[1][2] )
	end		end

	function onMySQLOpen ( ~~mysql,~~ result )		function onMySQLOpen ( result )
	if ( result ) then		if ( result ) then
	outputServerLog ( "~~CONNECTED~~" )		outputServerLog ( "MySQL connection established." )
	mysqlQuery ( ~~mysql~~, "onMySQLResult", "SELECT * FROM test" )		mysqlQuery ( db, "onMySQLResult", "SELECT * FROM test" )
	else		else
	outputServerLog ( "~~DIDNT WORK~~" )		outputServerLog ( "MySQL connection failed." )
	end		end
	end		end

	function mysqltest ()		function mysqltest ()
	mysqlOpen ( "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 )		db = mysqlCreate ()
			mysqlOpen ( db, "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 )
	end		end
	</syntaxhighlight>		</syntaxhighlight>

EAi at 13:25, 1 November 2006

2006-11-01T13:25:53Z

← Older revision		Revision as of 13:25, 1 November 2006
Line 3:		Line 3:

	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 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 [[Module functions\|ml_mysql]] module.~~

	==Syntax==		==Syntax==

EAi at 13:25, 1 November 2006

2006-11-01T13:25:47Z

← Older revision		Revision as of 13:25, 1 November 2006
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	~~==Description==~~		{{ModuleFunction\|MySQL}}

	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 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]].

EAi: MysqlQuery moved to Modules/MySQL/MysqlQuery

2006-11-01T13:14:17Z

MysqlQuery moved to Modules/MySQL/MysqlQuery

← Older revision

Revision as of 13:14, 1 November 2006

IJs at 01:24, 1 November 2006

2006-11-01T01:24:49Z

← Older revision		Revision as of 01:24, 1 November 2006
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

IJs at 01:20, 1 November 2006

2006-11-01T01:20:51Z

← Older revision		Revision as of 01:20, 1 November 2006
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	==Description==		==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.		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.~~		This function is provided by the [[Module functions\|ml_mysql]] module.

	~~Use '''both'''~~ [[~~mysqlGetField~~]] ~~and [[mysqlCleanupResult]] to deal with the ''mysql_result'' object returned by this function~~.

	==Syntax==		==Syntax==