can you guys tell me what i need to do to get the inet_aton() function to work?
I seem to need some arpa/inet.h file but I can't find it anywhere
thanks guys
the code it's in is:
<? echo inet_aton('$REMOTE_ADDR')
?>
inet_aton()
Moderator: General Moderators
I'm trying to convert a user's ip address, then look in a database for the corresponding country and then output the country.
Here's the whole set of code for context:
// Establishing a database connection
$dbh=mysql_connect("localhost","$username","$password");
mysql_select_db("$username");
// Query for getting visitor countrycode
$country_query = "SELECT country_code2,country_name FROM iptoc ".
"WHERE IP_FROM<=inet_aton('$REMOTE_ADDR') ".
"AND IP_TO>=inet_aton('$REMOTE_ADDR') ";
// Executing above query
$country_exec = mysql_query($country_query);
// Fetching the record set into an array
$ccode_array=mysql_fetch_array($country_exec);
// getting the country code from the array
$country_code=$ccode_array['country_code2'];
// getting the country name from the array
$country_name=$ccode_array['country_name'];
// Display the Visitor coountry information
echo "$country_code - $country_name";
// Closing the database connection
mysql_close($dbh);
Here's the whole set of code for context:
// Establishing a database connection
$dbh=mysql_connect("localhost","$username","$password");
mysql_select_db("$username");
// Query for getting visitor countrycode
$country_query = "SELECT country_code2,country_name FROM iptoc ".
"WHERE IP_FROM<=inet_aton('$REMOTE_ADDR') ".
"AND IP_TO>=inet_aton('$REMOTE_ADDR') ";
// Executing above query
$country_exec = mysql_query($country_query);
// Fetching the record set into an array
$ccode_array=mysql_fetch_array($country_exec);
// getting the country code from the array
$country_code=$ccode_array['country_code2'];
// getting the country name from the array
$country_name=$ccode_array['country_name'];
// Display the Visitor coountry information
echo "$country_code - $country_name";
// Closing the database connection
mysql_close($dbh);