PHP/MYSQL Programmer Needed

[Toon]

I require the assistance of someone with PHP/MYSQL and possibly Oscommerce knowledge.

I want to setup a main site with oscommerce and need multiple other sites to share a portion of the main sites database. Each site will require it's own database to store it's own customer and sales information. I want each site to share the product part of the database so that when I delete/change or add a new product/attribute on one site then all of the other sites will automatically update with the new information.

All of the sites will be on a reseller hosting package so will be independant to each other although they should be on the same server.

At the moment I have to manually update each site with the easypopulate function which isn't too bad when I only have 4 or 5 sites to change but I'm planning on having 100's of sites and updating them will take all day.

[creospace]

You need a specialised hosting deal where the host allows remote (external) access to the mysql database from another domain. Most hosts won't let you do this even if it's a reseller account. I think you can get away with it if the databases are all on the same server but that is unlikely but i can't comment on your individual host.

If you are planning on having 100's of sites in the future you should be allowing for that now, which will save a whole load of hassle in the future.

I can do your php-mysql stuff and have experience with oscommrce, in fact setting one up now. Send me a pm if you would like to talk further, only to happy to offer advice.

Gary

[Toon]

PM sent. Hope you can help.

[Rob Holmes]

You need a specialised hosting deal where the host allows remote (external) access to the mysql database from another domain.

I'm reliably informed by a client that our systems will do this (I've never tried) :)

Give us a shout if I can help.

Rob

[Robert]

If you use CPanel there is an option to add a limited number of permitted external IP addresses for a specific DB.

[GaryReid]

As long as all of the domains are on the same server you shouldn't need anything special setting up as far as access goes, just make sure you put 'localhost' as the MySQL server name when you install OScommerce.

If they were on different servers then it depends on both your panel and your host. Cpanel you can setup remote access from within cpanel itself, if it's Plesk then you need to ask the host to change the permissions on the mysql perms database to allow remote access either from wildcard (any IP/domain) or from specific IP's. Most say no because they aren't quite sure how to do it.

As for using different databases for customer information and one for products you are probably better just adjusting the standard oscommerce database to accept a domain ID into the customer database, then use a single database for all of the installs. The domain id will flag which domain the customer came from. This will make it scalable and a bit easier to manage as you'll have just the one admin access point.