How to make use of Session and Cookie to keep values

Techissue2008

I created a mysql table to store currencies. User can select currency and all products' prices are updated automatically.

However, if differenct users change the currency in database, other users will see different currency if someone changes it.

So, I think the currency cannot be store in database table.

There are 10 currencies for user to change.

If same user visits the site again, the previous selected currency would be applied.

How should I do it?

Thanks

NogDog

Not 100% sure I follow you, but it sounds to me like you want a column in the users table for their preferred currency, presumably being a foreign key to the currencies table. Then part of the user sign-on process would be to retrieve their currency preference, probably saving in in the session data.

Techissue2008

I think cookie is more suitable to store data longer time?

Once the user selects the currency, the currency will be what did he select when he comes back to the site next time.

Is there any tutorial?

Techissue2008

I have a currency select page which has radio buttons for currencies.

When user visits index.php, it should check whether there is cookie set for currency.

If no, then there is a default currency.
If yes, then it should use the selected currency.

I do not know how to write it in index page and the currency selection page.

NogDog

[man]setcookie/man
$_COOKIE