Sign in to follow this  
Followers 0
Moos Hueting

Total beginner in a hurry :P

6 posts in this topic

Ok, I'm verry that I should ask this maybe stupid question, but I'm kind of in a hurry (deadline :whistle: ).

I want to fill in a html form with autoit, and get the values for the fields from a mysql database. Is this easy to do? And if so, where do I start? because I can't find in the manual how to send text to specific textboxes in an application.

Share this post


Link to post
Share on other sites



Ok, I'm verry that I should ask this maybe stupid question, but I'm kind of in a hurry (deadline :) ).

I want to fill in a html form with autoit, and get the values for the fields from a mysql database. Is this easy to do? And if so, where do I start? because I can't find in the manual how to send text to specific textboxes in an application.

Welcome to AutoIT! :)

"Is this easy to do?" -- NO. Not for a complete beginner with AutoIT. If you have any experience with other scripting languages, though, you could be up to snuff on AutoIT in no time (couple days). Depends on your experience.

Filling in a form with AutoIT can certainly be done. Some are easier than others, depending on the API in play: Windows controls or IE, for example. There are ways to deal with either.

There are good techniques on this forum for accessing databases via ODBC connects and specific discussions on doing all kinds of magic with MySQL.

As for where to start, if you want to do this in AutoIT, start with downloading and installing AutoIT, the latest AutoIT Beta, and the latest SciTE editor. Then run Valuater's AutoIT-1-2-3 tutorial linked in my sig, below.

Don't be afraid to post broken code to this forum for help with it. That's what this forum does. But don't post specifications for someone else to write it for you, either. For that, go to RentACoder.

Cheers! :whistle:


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites

Thanks :)

I already have another question :whistle:

Is there a possibility in AutoIT to connect to a mysqlserver via http tunneling? Because the host I need the mysqlinfo from doesn't allow external connections, a http tunnel would be perfect.

Share this post


Link to post
Share on other sites

it is probrely posible with IE

Share this post


Link to post
Share on other sites

Thanks :)

I already have another question :whistle:

Is there a possibility in AutoIT to connect to a mysqlserver via http tunneling? Because the host I need the mysqlinfo from doesn't allow external connections, a http tunnel would be perfect.

The term in use here is 'screen scraping'. Yes, look at the extensive work done by DaleHolm in these forums on the IE.au3 UDF. I think there has been a lot of work done on a MySQL UDF as well, but I'm not sure of the current status.

Hint: In any case, use the AutoIT beta version to do the above. The help file and forum searches will fill in the rest. Any diificulties can usually be work out if you post some actual code you have written for people to look at.

Good luck!

Share this post


Link to post
Share on other sites

#6 ·  Posted (edited)

I think that the MySQL UDF library is a pinned topic in the Scripts & Scraps forums.

#)

edit: Sorry, that was SQLite.

Edited by nfwu

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