E-Commerce + Countries Tables

wizzard81

Hello,

I'm working on an e-commerce but i have a question and maybe someone in here has experience with this:

I'm working worldwide Belgium, Japan, US,... now for all the countries there are different shipping costs and also per weight.

Like for Belgium, UPS, Express Mail US Same but their are different prices how do i best fix this with different tables for prices and countries... ?

I'm newbie and i'm also looking for some tutorials how to make a basket, products info... Anyone knows some tutorials?

Best Regards
Kris

marque

Database Ingredents

1: Company

Fields: CompanyID, CompanyName

2: Countries

Fields: CountryID, CountryName

3: Company2Country

Fields: Company2CountryID, CompanyID, CountryID

4: Prices

Fields: PriceID, Company2CountryID, Price

Directons:

Table 1 (Company) will hold an auto incremended ID and the company names.
Table 2 (Countries) holds an auto incremented id as well as the country names.
Table 3 (Company2Country) joins multiple companies to multiple countries
Table 4 (Prices) joins multiple company2country id's to 1 price.

You could of course have multiple prices for multiple countries for multiple companies, but i think thats going a little to far.

Serve with a clean SQL query toped with a well structured style sheet, and a Belgium Beer.

wizzard81

Thanks marque😉 You know the Belgium beers.

wizzard81

A little question if you work with sessions for the orders from a user. Do you have to set session_start(); on every page that the website requires or only on like cart.php prod_details.php ... ?

stolzyboy

if you want to keep the session on the whole site you will have to put that on every page, so if they are at cart.php and wander over to contact.php, and you leave out the session_start, your session will be lost and if that is how you are creating the shopping cart, that will be lost also

wizzard81

thanks i will put the session_start(); in my header so it will always be loaded.

marque

I know some of the beers, about 1% of all that i would like to get here in Australia.

It's very limited in choice of beer, mainly cause Australian's really don't have any taste in a good beer.

I'm going to set up a good butique online beer shop soon. Selling beers from all over the world. My two favorate things are beer and php. Put them together, it it becomes "Super, Dynamic, Database Driven, Beer Haven!"