MySql + Autoit

[nichata]

is it possible make with autoit a regist system which someone put in inputbox username and pw, and then it regist to a mysql-database?

Is there any example? :/

Edited March 1, 2012 by nichata

[DelStone]

What is a "regist system"? Your question is a little unclear - if you want to access a mysql database you'll need a UDF library like

MySQL.au3.

Do a search on the forums and you'll find instructions of how to connect to a database using function calls in the library.

Here's some code I use to initialise a mysql database

#include <MySQL.au3>

_MySQL_InitLibrary()
If @error Then Exit MsgBox(0, "Database Error", "Could not initialise MySQL library [" & _MySQL_Error($Sql) & "]")
$Sql = _MySQL_Init()
If @error Then Exit MsgBox(0, "Database Error", "Could not initialise MySQL connection [" & _MySQL_Error($Sql) & "]")
If _MySQL_Real_Connect($Sql, $SqlHost, $SqlId, $SqlPwd) = 0 Then Exit MsgBox(16, 'MySQL Connection Error', _MySQL_Error($Sql))
Query($Sql, "SET GLOBAL WAIT_TIMEOUT=7786800")
_MySQL_Real_Query($Sql, "SHOW DATABASES") ; If abc database does not exist, create it
$res = _MySQL_Store_Result($Sql)
$arr = _MySQL_Fetch_Result_StringArray($res)
If _ArraySearch($arr, "abc") = -1 Then _MySQL_Real_Query($Sql, "CREATE DATABASE abc")
_MySQL_Real_Query($Sql, "USE abc")
; If no tables or a table has been deleted...
$no_of_tables = CountTables($Sql) - 1
If $no_of_tables < $TotalTables Then
  SplashTextUpdate(35, "Recreating tables...")
  CreateDatabase()
EndIf

[Mechaflash]

Googling "autoit mysql", the first 3 links seem informational enough to start you off. And it looks like you already know what function to use (InputBox) so there ya go.

[nichata]

I will try clear my question.

I wanna make a program,which you put a username and password.Then the program write to a mysql database the username and pw,so someone can login with the user.

[Mechaflash]

you basically just want to make a GUI with AutoIT to login to a mysql database... or do you want to store the credentials, and have AutoIT send them to MySQL to automatically log in?

[nichata]

I wanna make a regist system.Someone will enter a username & pw and it will be written to a mysql server.Then the user can login everytime to the program.

I was also thinking about make a php file,which u write username and pw and it write it in php.I got a login system with php,but not a regist system

[MPHillier]

My understanding of what is being asked...

1. User creates an account - Stored in MySql.

2. User logs in using a front end connected to Mysql to verify credentials - then runs?

Is this a database program with MySql... Bounce credentials off one table to access another?

[MPHillier]

Or, what I do is use Active Directory credentials to access a Mysql database. Sign inOut program.