Page 1 of 1
Access REMOTE MySQL DATA On Local Machine using http - PHP
Posted: Tue Feb 15, 2005 8:16 pm
by sanjay
I have a data entry application running on windows platform which reads/writes data on MySQL using ODBC. This data is displayed using php script on Web Pages.
Problem :
My new Web-Host allows MySQL to be accessed at localhost only.
So I have to quit ODBC anyways and modify my application that send and receives MySQL data on http.
Is there any simpler solution to this? or is there any existing script that does similar job?
Posted: Tue Feb 15, 2005 8:30 pm
by feyd
why not do entry via the web page?
Posted: Tue Feb 15, 2005 8:45 pm
by sanjay
Data entry programs are more suitable on a windows application when speed and gui support is required more than just viewing data. Moreover in future I have to expand it to use locally running SQL Server Data for reference.
This application is working fine with other hosts who allow access to MySQL from remote applications.
This new client of mine have been using this [No remote access] host for last few years.
1 way is to find a solution. Thats what I am looking for.
Last option is to skip the whole problem and just get a suitable Host.
I Welcome any sugesstion or solution
Posted: Tue Feb 15, 2005 9:05 pm
by feyd
Since you've decided against using pages for entry, then you need a script that can recieve the information needed to perform your query and return success/failure information. I'd suggest it only accepts encrypted information.. strong encryption.
Posted: Tue Feb 15, 2005 9:52 pm
by sanjay
thanks feyd for all your efforts and valuable suggestions.
I agree I have to do as you say.
As a requirement Local Application will send data(Encrypted SQL) to php and php on server end will connect to MySQL execute query and return resultset or parameters like Success/Failure rows effected.
Typically Query Patterns will be Simple
1> STANDARD SELECT STATEMENT (EXPECTING RESULT SET AS RESULT)
2> INSERT/UPDATE/DELETE (EXPECTING ROWS-EFECTED)
What I am intetested to know is if someone here has done this before and willing to share his experience. Even better if there is any existing class or code library that I can use.