Access REMOTE MySQL DATA On Local Machine using http - PHP

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
sanjay
Forum Newbie
Posts: 3
Joined: Tue Feb 15, 2005 7:17 pm

Access REMOTE MySQL DATA On Local Machine using http - PHP

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

why not do entry via the web page?
sanjay
Forum Newbie
Posts: 3
Joined: Tue Feb 15, 2005 7:17 pm

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
sanjay
Forum Newbie
Posts: 3
Joined: Tue Feb 15, 2005 7:17 pm

Post 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.
Post Reply