kra55 Posted February 11, 2011 Share Posted February 11, 2011 sorry if i am asking the wrong people. But any help would be appreciated. Basically i am creating a instant messenger program for a game re in game logistics I need to create a login system. Then once the user is logged in they will be able to view/modify upto about 10 differant values at a time. This i can do. Thinking forward. When accessing MYSQL via autoit though a webhost. My ip address has to be entered in to the remote sql/allow list. I assume this is here for security and me allowing the entire WWW will cause friction between me and my host. So my understanding is i have 2 options at this time. I can either find a MYSQL host with unrestricted remote MYSQL access allowed(any ip can access DB) Or i can teach myself tcp/ip connections via auto it. Then make my home computer a "server" that recieves requests from the user's and pass's it on to my webhosts MYSQL database. The second option is obviously not prefered as it will slow the whole process down. If what i have said makes sense :S. Can anyone suggest what to do here. If my thinking is correct?/are either of these the correct option?/what other options do i have?/Can anyone suggest a MYSQL host?. Once again i understand if i have asked in the wrong place and i do very much thank anyone for any assistance they can provide.... Link to comment Share on other sites More sharing options...
JohnOne Posted February 11, 2011 Share Posted February 11, 2011 (edited) you make a serverside script on a website with something like php. make your autoit script send requests to the php script, which in turn deals with the database queries. Edited February 11, 2011 by JohnOne AutoIt Absolute Beginners Require a serial Pause Script Video Tutorials by Morthawt ipify Monkey's are, like, natures humans. Link to comment Share on other sites More sharing options...
MirnesC2 Posted February 11, 2011 Share Posted February 11, 2011 (edited) Make sure you don't store important information such as database log-in information in your AutoIt code. Edited February 11, 2011 by MirnesC2 Link to comment Share on other sites More sharing options...
kra55 Posted February 11, 2011 Author Share Posted February 11, 2011 Posted 29 minutes agoyou make a serverside script on a website with something like php.make your autoit script send requests to the php script, which in turn deals with the database queries.This post has been edited by JohnOne: 28 minutes agoSo do you mean to actually create a page to be brought up in IE and the information accessed?/would i imbeded a webpage into the form somhow? or is there another way i can pass information between AUTOIt and PHP?Posted 20 minutes agoMake sure you don't store important information such as database log-in information in your AutoIt code.This post has been edited by MirnesC2: 19 minutes agoHehe definitely will not do this. have thought about the logic behind the login process a little but as i have been focusing on the other workings of it. This will probably be the last step. Link to comment Share on other sites More sharing options...
kra55 Posted February 11, 2011 Author Share Posted February 11, 2011 Can somone please point me in the direction of AUTOIT sending requests to PHP??? Link to comment Share on other sites More sharing options...
4ggr35510n Posted February 12, 2011 Share Posted February 12, 2011 WinHTTPRequest Link to comment Share on other sites More sharing options...
John Posted February 12, 2011 Share Posted February 12, 2011 You make the php submission form work on your site without AutoIt. Then you write your AutoIt script to interact with that page, just like any other form submission page. Link to comment Share on other sites More sharing options...
kra55 Posted February 12, 2011 Author Share Posted February 12, 2011 Thank you so much have something to work with now Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now