I have roughly 4000 car products for sale on my main website stored in the form of a single mysql databse. I was wondering, what would be the easiest way to open several new websites with each specialising in a different make ( e.g. Audi, BMW etc ) and get each new website to take the relevant info from the main mysql databse so I dont have to edit the products in my main website + each and every new site I create everytime there is a price change etc. Surely there has to be a simple procedure for doing this Any Help greatly appreciated.
You can just make your other sites get their data from the same database. You'll need to filter the products you want displayed but that should be fairly trivial.
sounds simple.but i have very limited knowledge of mysql. also..I have been using oscommerce for my main site and not too happy with it...what alternatives does I have to oscommerce for my new sites?
Another alternative is using a prefix for each manufacturer's data for the table name: audi_price audi_descrip bmw_price etc. This would make the data easier to manage through queries. If you are considering splitting database access among many webservers, you will get extremely slow pageloads if the database machine and the website aren't on the same server or at least the same network. You can easily share the database among many machines, just give the IP/hostname of the webserver the proper permissions in mysql.
The websites and the database are all with the same host on the same server...how do I set the proper permission for this?
If you don't know what you're doing (and it sounds like you don't), I'd advise you get someone who does to undertake the task on your behalf. I'm sure there are plenty of coders on here who would be happy to help you for a small payment.
Hi, This is what you have to do. Currently you are connecting using something like this: mysql_connect(localhost,usernamehere,passwordhere); Instead of this, use: mysql_connect(Server-IP-here,usernamehere,passwordhere); Example if your username is "admin" and password is "pass", domain name is "yourdomain.com", then first connection string (when connecting from same domain) will look like: mysql_connect(localhost,admin,pass); Now it becomes on domain2.com : mysql_connect(1.2.3.4,admin,pass); where 1.2.3.4 is the IP address of "localhost.yourdomain.com" If you use it, then PLEASE change the IP I mentioned above. That's only to show you. Replace it with your own IP for the domain where you actually have the mysql located. Your web host will give it to you. Tell them that you want "IP" for "localhost.yourdomain.com" If you still have problem or don't want to do it yourself, then please let me know. Regards jeet
what i want is a simple template design which i can use to reproduce in multiple sites. the products displayed will just have the desciption and the price accessed from my main mysql database. One site will be BMW only, other wil be covering citroen only etc. There will be no purchase portals on these sites..its just to be a simple item pic. item description and item price. "JEET"..can you incoporate this into a template and how much will you charge me?