[CLASS] MySQLAPI - MySQL wrapper

[needle]

The project was cancelled, and currently I havn't time as well as interest to continue the work on the class script. It might be useful anyway, that's why it's here:

Hello everybody,
I need to connect a script I wrote to a MariaDB and I'd like to know if these are the latest and most complete SQL libs or there have been further developments: all the info I'm finding is several years old.
Thanks a lot!

[Elendiar]

Hi, thanks you for usefull scripts, but i have and issue.
Try connect to server, reject with message:
Connection failed!
2026 - SSL connection error: Unable get certificate

Connection from HeiduSQL successfull, connect to another server through lib successfull too. How can i disable ssl or connect and ignore this ? I have no access to sql server, nead read data. What can it be ?

[kyuuuri]

Hello, i have a problem with libmysql.dll

I get this error when running MySQLAPI_demo.ahk:
"could not load" (path to libmysql.dll / it is the same folder as the demo.ahk) ... "is not a valid win32 app".
I already downloaded all x32 versions from here https://downloads.mysql.com/archives/c-c/ and none of those work, even tried the x64 ones and i get the same error.

Any help is appreciated, thank you.

[kyuuuri]

Hello, i have a problem with libmysql.dll

I get this error when running MySQLAPI_demo.ahk:
"could not load" (path to libmysql.dll / it is the same folder as the demo.ahk) ... "is not a valid win32 app".
I already downloaded all x32 versions from here https://downloads.mysql.com/archives/c-c/ and none of those work, even tried the x64 ones and i get the same error.

Any help is appreciated, thank you.

I solved it, i feel stupid, i was running the .ahk with ahk 64 bits hahaha. You have to run it with x32.

[iaveto]

Hi just me!

I tried to connect to my database using your class but got a message box with this:

Query:
(here is my query)

Result:
Name =
Value =

What should I do?

[just me]

What should I do?

At least you should post your code. I'm not a MySQL expert, but others here might be able to answer your question.

[cdkdang]

Can someone tell me what the array format of Fetch_Row() is?

Normally i use print_r in php to find out but apparently there's no equivalent for ahk.

thanks

[just me]

MYSQL_ROW

Excerpt from the class code:

Code: Select all

   ; ===================================================================================================================
   ; Returns the values of the next row of the given MYSQL_RES as an array.
   ; Parameters:    MYSQL_RES - Pointer to a MYSQL_RES structure.
   ; Return values: Array of values, False if there is no more row
   ; ===================================================================================================================
   GetNextRow(MYSQL_RES) {
      If (MYSQL_ROW := This.Fetch_Row(MYSQL_RES)) {
         Row := []
         Lengths := This.Fetch_Lengths(MYSQL_RES)
         Loop, % This.Num_Fields(MYSQL_RES) {
            J := A_Index - 1
            If (Len := NumGet(Lengths + 0, 4 * J, "UInt"))
               Row[A_Index] := (StrGet(NumGet(MYSQL_ROW + 0, A_PtrSize * J, "UPtr"), Len, "UTF-8"))
            Else
               Row[A_Index] := ""
         }
         Return Row
      }
      Return False
   }

[cdkdang]

Just a reminder to myself and anyone else who are having the "Could not find [path]\libmysql.dll"

Just downloading the dll and having it in the script path is not enough.

The operating system actually has to have the appropriate libmysqlclient installed.

Once that is installed, having a correct copy of the libmysql.dll in the script path is sufficient.

Maybe change the error message from "could not find" to "could not load", as the first message indicates a location issue.

Probably self evident to anyone with half a brain, but I wasted days on finding and downloading various libmysql.dll and putting them into various folders (script folder, modules folder, system32, root, etc).

[Klarion]

@cdkdang
nice

[manehscripts]

Hello, the program works perfectly but I wanted to know how do I enable the connection of any IP? In order to make it work, I had to register my IP on the DB Server. I need to release access to everyone who needs to use the program. Thanks!

Solved: I just gave the permission with (%) on my server to everyone.

[hot hot 85]

I was looking in the library for command to close the connection but I , didn't find it , some one knows how can i do it?

[just me]

There's a Close() method called internally when the DB object is destroyed (e.g. MyDB := ""). External calls might need some additional actions on the DB object.

[chelste1824]

I want all the stored mac back in the database but I can't find how to do it, I can't find the necessary function, example GetNextRow, help me, plz

SQL= select macpc from registro
+--------------+
| macpc |
+--------------+
| xxxxxxxxxxxx |
| yyyyyyyyyyyyyy |
| zzzzzzzzzzzzzz |
+--------------+

example.

resp:=Result(SQL)

Msgbox % resp

---------------------------------------
;Print
xxxxxxxxxxxx
yyyyyyyyyyyyyy
zzzzzzzzzzzzzz

[william_ahk]

DBGVIEWCLEAR[ERROR] SSL error: Unable to get certificate from ''.
I'm also having this issue with the latest dll of MySQL 8.0. Oddly the AHK DBA library works.

[Skywalker]

Hi Wiliam,
i also try at the moment to connect with SSL to MySQL
With Heidi everthing works fine, but i cannot get a connection with AHK and DBA

Do you have a hint for me ?
Thank you so much in advance!

[william_ahk]

@Skywalker It seems there's something incompatible with MySQL 8.0 in this API class. I switched back to MySQL 5.7 at the moment.

[Chutriel]

Hi,

same here. Have to stay on 5.7, I am using this class in a very big application, and I love it for its simplicity. Is there anyone, that had any success in using it with MySQL 8 ?

[just me]

Hi,

which errors do you get when you try to use MySQL v8?

[Jovannb]

Hi,

I learned to know, that until this month, the 32-bit libmysql.dll from 2017 worked problem-free with Win10 22H2 64 bit together with AHK1.1.xx A32 on more than 15 computers.
But beginning with this month, with a new computer (Dell 9440) and Win10 22H2 64-bit, driver wont work, I got a message, that the library (libmysql.dll) cant be found, despite it was there and accessible for my .ahk-scripts.

After a longer investigation period, with procmon (sysinternals, russinovich) and not getting any satisfying result, we (a fellow and me) found, that there is a newer 32-bit libmysql.dll from 2022 - you can find it in 32-bit release of www.heidisql.com.
With that newer libmysql.dll everything works smoothly as previously with all my clients which use AHK 1.1.xx A32.

Hopefully somebody else can use that information which costs me more than 10 hours.
JB.