How to setCookie with MySQL

[Techissue2008]

Hi

I need to build a shopping mall which supports multi-currencies.
The transaction currency is USD. And, there is a php page let user to select other reference currencies.

e.g. Price of a product is US$100, and the default reference currency is GBP. it will be shown like that:
US$100 (GBP$60)

If user changes reference currency to be AUD, then it will be saved in cookie and it will show:
US$100 (AUD$85)

Do I need to set a temporarily table to store the cookie_id with random number and the reference currency_id?

How should I write the setCookie and retrieve the data from temp table?

Thanks for help

[efficacious]

Well If your users aren't logging in.. just set it in your session data.

Whatever you use for them to choose which currency..

Since I don't know i'll assume a select box

<?php

echo("

<form action='process.php' method='post'>
<select onchange='this.form.submit' name='Currency'>
<option value='USD'>USD</option>
<option value='GBP'>GBP</option>
<option value='AUD'>AUD</option>
</select>
</form>


");
//* CODE TO SET CURRENCY *//
$Currency = (!(isset($_POST['Currency']))) ? '' : $_POST['Currency'];

switch ($Currency)
{
case 'USD':
$_SESSION['Currency']='USD';
break;

case 'GBP':
$_SESSION['Currency']='GBP';
break;

case 'AUD':
$_SESSION['Currency']='AUD';
break;

default:
session_unset($_SESSION['Currency']);
break;
}

//Then code from there to mark your pages.
?>

hope that helps :queasy:

this would be the most effient way i can think of..

and being session data you won't have to waste time querying back to your DB each time.

also i was thinking.. if this is a shopping cart type thing... you'll want to save all the shopping cart info in sessions aswell..
again this will be the most effiencient way.. and is usually recommended for shopping carts.

[Techissue2008]

Dear Sir

Thank you for your help. May I ask whether the session can be saved for a long time such as a year? I have a setcookie code which as 3 parameters: currency, currency symbol and exchange rate. All of them retrieved from DB. Do you know how do they use?

if (isset($currency)) {
$sql = "SELECT * FROM `currency` where currencyid='".$currency."'"; 
$result = mysql_query($sql);							
while( $item = mysql_fetch_array($result)){
$currency_symbol=$item["symbol"];
$exchange_rate=$item["exchangerate"];
}

setcookie ("last_currency","",time()-60,"/","localhost",0); 
setcookie ("last_currency",$currency,time()+60*60*24*365*10),"/","localhost",0); 

setcookie ("last_currency_symbol","",time()+(60*60*24*365*10),"/","localhost",0); 		
setcookie ("last_currency_symbol",$currency_symbol,time()+(60*60*24*365*10),"/","localhost",0); 

setcookie ("last_currency_exchange_rate","",time()+(60*60*24*365*10),"/","localhost",0); 			
setcookie ("last_currency_exchange_rate",$exchange_rate,time()+(60*60*24*365*10),"/","localhost",0); 

The table has the fields: currencyid, currency, symbol, exchangerate.

Thanks for your great help

[Kudose]

Techissue2008;10883853 wrote:

May I ask whether the session can be saved for a long time such as a year?

Yes. See session.gc_maxlifetime

php.ini

session.gc_maxlifetime = 3153600

or

ini_set('session.gc_maxlifetime', 3153600);