Web service in OSCommerce

[viki2mail]

Hi all . I just wanted to know whether we have a existing web service in OSCommerce or should we write ourselfs to access the data from the DB.

[Guest]

Vikram,

 

Can you explain a little more what you are trying to accomplish? I am sorry, I don't fully understand your question.

 

 

 

Chris

[MrPhil]

osC has an "admin" section to edit your store and product data, which is of course accessible over the Web. You should also be able to get to the database directly via phpMyAdmin (through your host's control panel), should you need to. What difficulties are you experiencing getting to your data? Wherever you have a Web browser, and your ID and password, you should be able to get to the data (unless you're coming in on a blocked IP address, or something).

 

On the other hand, osC has nothing to directly manipulate the database from a PC, over the net. Various third party solutions exist for this, but I don't think any are designed to work specifically with osC. Is that what you're looking to do? Perhaps make osC's database "look" like it's local to the PC, for purposes of running an application on the PC (e.g., accounting software for your store)?

[viki2mail]

@chris

See, the osC is in PHP , and i want to access the data from this site to a application on andriod phone . As andriod is using Java it would not be compatible with the site written in PHP. So i wanted a web service which takes the data from the site ( the database) and converts it into some form compatible with java , like XML or JSN , So that it can be all the features of the site are made available even on the phone .. I hope its clear now ?

[MrPhil]

Doesn't Java have an interface into MySQL? Will this be a web site (running through a server), or does the Android not use HTTP? I'm not familiar with mobile phone apps, so I may not be asking the right questions. Anyway, it's irrelevant that osC is written in PHP -- the database is MySQL, which is language-independent. If your Android app (Java) runs on the same server as osC, it may be able to talk to the database without having to fool with (or convert) the database itself.

 

On the other hand, if the phone itself is to talk directly to the database, and doesn't have the "hooks" to talk to MySQL, well then, you just may have to convert the data first.