Sign in to follow this  
Followers 0
cdkid

MySQL?

3 posts in this topic

ok...i have an ASP page that writes a form with a bunch of fields to a DB....i wanna read the Varchar field called 'Charname' & assign a variable to that...any help would be much appricaited

--thanks


AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

I only know php but an example would be:

Quick piece of code:

mysql_connect(localhost,"USERNAME","PASSWORD");
@mysql_select_db($_GET["DB"]) or die( "Unable to select database");

$query = "
    SELECT `".$_GET["VAR"]."`
    FROM `".$_GET["TBL"]."`
";

$result=mysql_query($query);
//if u want, add some error handling here

echo mysql_result($result,0,$_GET["VAR"]);

//close the DB here

Then just call the webpage from autoit (query.php?DB=database&TBL=tablename&VAR=variablename)...This isn't too secure though and you might want to find a way to do a "post" from autoit so the user name and password can be passed, not allowing just anyone to acces your database

Edited by computergeekxp

Share this post


Link to post
Share on other sites

alright, thanks...it doesn't really need to be secure it's just for a SuperGroup (like a guild) in COH...making auto-join script :lmao:

--thanks for ur help


AutoIt Console written in C#. Write au3 code right at the console :D_FileWriteToLineWrite to a specific line in a file.My UDF Libraries: MySQL UDF Library version 1.6 MySQL Database UDF's for AutoItI have stopped updating the MySQL thread above, all future updates will be on my SVN. The svn location is:kan2.sytes.net/publicsvn/mysqlnote: This will still be available, but due to my new job, and school hours, am no longer developing this udf.My business: www.hirethebrain.com Hire The Brain HireTheBrain.com Computer Consulting, Design, Assembly and RepairOh no! I've commited Scriptocide!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0