I want to display product price in USD and GBP. My default currency is USD. If user come from UK ip range this script will set currency code GBP in cookie.
How to display price based on Cookie value(java-Script method)?
script:
<?php
$con=mysqli_connect("localhost","userip","asdfgh","userip");
$ip = $_SERVER['REMOTE_ADDR'];
$query = "SELECT id FROM ip WHERE '$ip' BETWEEN f AND t"; // check user ip from UK ip range
$result = mysqli_query($con,$query);
if(mysqli_num_rows($result) > 0)
{
setcookie('currency', 'GBP', time()+604800);
}
mysqli_close($con);
?>