xwinterx Posted October 16, 2006 Share Posted October 16, 2006 First off... yes... I have looked at the mysql UDF's and have used them to accomplish what I wanted but now I want to try something different.... Does anyone know or has anyone tried to access a MySQL database through PHP using AutoIt? Example... say I want someone to run a program from any computer connected to the internet. I want that person to be able to "log into" the program using a password and login name. I want that information to go into a PHP url that will query the MySQL database and return the value of a specific field. The need for this is simple, the MySQL UDF's require you to install the ODBC drivers. I cannot have these drivers installed on certain machines due to permission restrictions and/or policies and proceedures set inplace by the organizations that own the computers. I have already created a test php script that will return the data to the IE window it was browsed to in. What I am getting at is to have AutoIt access the URL then have the PHP script return or pass a result to AutoIt. Probably impossible, I've been looking at all sorts of past posts, but nothing is that specific. Any questions, suggestions or solutions? Link to comment Share on other sites More sharing options...
Uten Posted October 16, 2006 Share Posted October 16, 2006 Through a PHP standalone thing or embeded script in a web page? Please keep your sig. small! Use the help file. Search the forum. Then ask unresolved questions :) Script plugin demo, Simple Trace udf, TrayMenuEx udf, IOChatter demo, freebasic multithreaded dll sample, PostMessage, Aspell, Code profiling Link to comment Share on other sites More sharing options...
xwinterx Posted October 16, 2006 Author Share Posted October 16, 2006 Through a PHP standalone thing or embeded script in a web page?Ummmm... either? I was imagining possibly through a script in a webpage through. Link to comment Share on other sites More sharing options...
McGod Posted October 16, 2006 Share Posted October 16, 2006 You could if u really wanted to. #include <IE.au3> _IEOpen ( "http://www.site.com/emp.php?user=username&pass=password" ) But that would be like so easy to get. My suggestion, use SQLite, 1 DLL and 1 Regserv32 and your done. [indent][center][u]Formerly Chip[/u][/center]~UDFs~[/indent][u]IRC.au3 - Allows you to connect to IRC ServersINetCon.au3 - Connects/Disconnects/Check Status of InternetHardware Key - Creates a unique hardware hashScriptComm - Allows you to communicate between scripts using WM_COPYDATA[/u][indent]~Programs~[/indent][indent]SimonAu3ForumsIRC Bot~Web Site~Web Autoit Example[/indent][indent][b][/b][/indent][u][/u] Link to comment Share on other sites More sharing options...
xwinterx Posted October 17, 2006 Author Share Posted October 17, 2006 You could if u really wanted to.#include <IE.au3>_IEOpen ( "http://www.site.com/emp.php?user=username&pass=password" )But that would be like so easy to get. My suggestion, use SQLite, 1 DLL and 1 Regserv32 and your done.hmmm...okies... thanks! I thought I ruled those things out. Will try it! Link to comment Share on other sites More sharing options...
xwinterx Posted October 17, 2006 Author Share Posted October 17, 2006 aha! I got it to work after fiddling around with the php and using the HTTP UDF's found elsewhere on this site. If there is some interest, I'll post the code for the au3 and php... or anyone can PM if interested. Link to comment Share on other sites More sharing options...
Moderators SmOke_N Posted October 17, 2006 Moderators Share Posted October 17, 2006 aha! I got it to work after fiddling around with the php and using the HTTP UDF's found elsewhere on this site. If there is some interest, I'll post the code for the au3 and php... or anyone can PM if interested.GJ on finding your own issue!! Yes, that would be great to post your findings/solutions... That way when someone visits your thread topic in a search, they may find just what they are looking for. Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer. Link to comment Share on other sites More sharing options...
xwinterx Posted October 18, 2006 Author Share Posted October 18, 2006 GJ on finding your own issue!! Yes, that would be great to post your findings/solutions... That way when someone visits your thread topic in a search, they may find just what they are looking for.Thanks... as soon as I get things cleaned up a bit I will do it! 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