MySQL 0.2

[Bimbol]

MySQL bind is a third-party module,  which provides Squirrel functions to access data from MySQL databases. More information about MySQL database you will find on the internet. If you looking for SQL language tutorial look here: http://www.w3schools.com/sql/

Implementation:
Add mysql to config as script.

Code:

<module src="MySQL.dll" type="server" /> // For windows
<module src="MySQL.so" type="server" /> // For linux

Squirrel function:
[return value = function(params)]
null/userpointer handler = mysql_connect(string host, string user, string password, string database, int port = 3306)
mysql_close(userpointer handler)
null/userpointer result = mysql_query(userpointer handler, string query)
null/int rowCount = mysql_num_rows(userpointer result)
null/int fieldCount = mysql_num_fields(userpointer result)
null/array data = mysql_fetch_row(userpointer result)
null/table data = mysql_fetch_assoc(userpointer result)
bool ping = mysql_ping(userpointer handler)
mysql_free_result(userpointer result)
null/string error = mysql_error(userpointer handler)
null/int errorId = mysql_errno(userpointer handler)

Short example:

Squirrel Script

local handler = mysql_connect("localhost", "root", "", "db_test");
if (handler)
{
	local result = mysql_query(handler, "SELECT * FROM mdb_users");
 
	if (result)
	{
		print("Query done " + mysql_num_rows(result));
		local row = mysql_fetch_row(result);
		if (row)
		{
			foreach (val in row)
			{
				print(type(val) + " " + val);
			}
		}
 
		mysql_free_result(result);
	}
	else
	{
		print(mysql_error(handler));
		print("Error ID: " + mysql_errno(handler));
	}
 
	result = mysql_query(handler, "SELECT * FROM mdb_users");
 
	if (result)
	{
		print("Query done " + mysql_num_fields(result));
		local row_assoc = mysql_fetch_assoc(result);
		if (row_assoc)
		{
			print(row_assoc["username"] + " " + row_assoc["email"]);
		}
 
		mysql_free_result(result);
	}
	else
	{
		print(mysql_error(handler));
		print("Error ID: " + mysql_errno(handler));
	}
 
	mysql_close(handler);
}

Download version 0.2:
Binares: https://bitbucket.org/Bimbol/sqmysql/downloads
Source code: https://bitbucket.org/Bimbol/sqmysql/src

[Bimbol]

MySQL module was updated, and now work on version 0.0.3

[Bimbol]

MySQL module update to 0.2!
Changes:
- Fixed crashes when row has NULL value
- Added controling parameter types

[Profesores]

Hi, I've been created 0.3 version last year, and now I would like to share it with you

Changelog:
-[EDITED] mysql_query - now return true, when query was successful, or false when there's errors.
-[ADDED] string(or false when there's problem) mysql_real_escape_string(handler, string to escape) - I don't think I need to expalin it

Binares (windows/linux): https://mega.nz/#!qLhgmQSI!2ZnVY8_VVhxaN...kTwZ_ErYnM
Source-Code: https://mega.nz/#!TH5mHIpT!exXcTYtV3gXXZ...IKn_J1U530