New MySQL plugin.

[cosenodefi]

Hi, everyone.

I've made a plugin for the access to a MySQL Database server. It's in an early delevopment stage. So, please, be carefull and read de documentation before.

It uses an direct access to the database server, relying on an external DLL (libmysql.dll) that must be present in the system. It can be found in the MySQL Tools for win32, from the MySQL site, and obviously in the win32 version of the MySQL server (also in the Apache and PHP extensions for MySQL for win32 platforms).

It was tested against several MySQL versions on diferent OS, and runs fairly well. Uses a INI file to configure the settings, and has three functions:

Function 1 - Data retrieval
Function 19 - Data retrieval (Debug mode, with filedump)
Function 20 - About Info

The functions of data retrieval can be used in four modes, depending on the parameters passed to the functions.

UPDATE (2011-Feb-14):
- New version. (v0.31). Multi query, and customizable user messages.

The changes imply a new syntax, so I've updated the 'readme.txt' and provided a new config file from a working example.

The parameters are:
<param1> - A string. The name of the column (field) of the result set.
<param2> - IGNORED

Syntax: $dll(mysqldb,1,<qry_idx>,)

The same modes & syntax can be applied to function 19.

This plugin was tested with LCDSmartie v5.4 runnning in WinXPSP3, Win2kSP4. The MySQL Server versions tested were:
- MySQL v5.067 & v5.1.54 in Win2K
- MySQL v4.018 in SUSE v9.1
- MySQL v3.23 in SUSE v7.0

[caesar]

Thanks!
Will look into it but already think that I'll love it!
Just realized that it comes in really handy.

[cosenodefi]

Thanks!
Will look into it but already think that I'll love it!
Just realized that it comes in really handy.

Thank you!!
I needed to check some values in a CMS (drupal), and I remembered that someone asked for it... (and I have got some spare days last week).