PHP MYSQL Webservices

wuodpamela

I currently have a responsibility of integrating/consolidating numerous disparate/remote databases into a central local MySQL database.All these remote databases use WAMP/PHP/MySQL server.
The idea is to write a webservice that will carry out the database querying/extractions from each of the remote mysql databases and deposit the dataset/result onto the local Wamp/PHP/Mysql server.
I have been reading all the examples online on PHP and webservices but I'm confused as to whether to use the NuSOAP,SOAP or the others for implementatio.

Also,Any inputs/code examples expecially from guys who have done this implementation are greately appreciated.

Thanks

W.P

wuodpamela

I havent received any feedback from this forum regarding implementing a webservice in php .
As i said,I'm using Wamp server(with php,mysql ) to host the current database inhouse.
I need to write a webservice that can automate the process of extracting data from a remote mysql database into our inhouse mysql database.
I know many people in this forum have implemented webservices in php.

My questions are:

Is it worth it implementing webservices in php for my task?
2.I'm I better off doing just FTP from these sites?
3.What would be the advantages of using a webservice say as opposed to ftp?
4.If you have any additional materials,feel free to share .

Thanks

blackhorse

There are many ways to do this. I guess that is the reason you don't get response. Maybe you need to make it more specific.

If just use php and mysql

Make the remote database export to xml, text file, soap and then your central server gether them etc. merge them into your central database. Or your mysql dump the remote, ftp it etc. These tasks could be manually done or you can write cron to do these automatically. These are the ways that if you don't have direct tcp access to the remote mysql database.

If you have direct tcp access to remote database. then things will be very simple, you can just use php remote access these database and treate these database almost as they are running at the same server. very simple.

Or if your remote database doesn't allow tcp access but allow ssh access to the mysql for the security reason, then you can use ssh port forwarding, a little bit tricky then.