AutoHotkey Community

[Titan]

If a computer/server has PHP and MySQL installed, theoritically you could use AutoHotkey to make a script which would append some PHP commands to a file, run that file from its virtual directory and use the browser to get the PHP-output text - which in this case would be data extracted from a MySQL database.

I know this way is not great but are there any better solutions or workarounds until AutoHotkey supports ODBC internally?

[BoBo]

I'm using isql to do queries on our billing platform. It works the way you descriped. create sql (batch) file. run that file via AHK to start the query. parse the response from the db (caught at the requested log) using AHK.

[lingoist]

Could you explain me step by step?

May I use it through Command Line such as:

[Kerry]

Bobo, I'm interested in this too
_________________
String Manipulator - GrabIco

[PhiLho]

Running an SQL engine is indeed a good solution.
Also note that recent versions of PHP are designed to work standalone on the command line, ie. like any scripting language: no need for Apache server nor Web browser, output directly on stdout.
_________________
vPhiLho := RegExReplace("Philippe Lhoste", "^(\w{3})\w*\s+\b(\w{3})\w*$", "$1$2")