Срещу ип да показва град

[rutera24]

По този начин си изкарвам от базата ип-адресите.

<?php
$con = mysql_connect("localhost","root","9856985696");
mysql_select_db("123", $con);

$result = mysql_query("SELECT * FROM gora");
echo "<table>";
while($row = mysql_fetch_array($result))
  {
  echo $row['ip'];
  echo "<br />";
  }
echo "</table>";
mysql_close($con);
?>

Идеята ми е срещу всяко изкарано ип да ми показва от кой град е.

Как ще стане.

 

[Player_pz]

сваляш тези неща -
http://geolite.maxmind.com/download/geoip/api/php/

и след това

<?php

// include functions
include("geoip.inc");

// read GeoIP database
$handle = geoip_open("GeoIP.dat", GEOIP_STANDARD);

// map IP to country
echo "IP address 62.149.130.132 located in " . geoip_country_name_by_addr($handle, "62.149.130.132") . " (country code " . geoip_country_code_by_addr($handle, "62.149.130.132") . ")";

// close database handler
geoip_close($handle);

// print compulsory license notice
echo "<p> -- This product includes GeoIP data created by MaxMind, available from http://maxmind.com/ --";

?>

 

[rutera24]

сваляш тези неща -
http://geolite.maxmind.com/download/geoip/api/php/

и след това

<?php

// include functions
include("geoip.inc");

// read GeoIP database
$handle = geoip_open("GeoIP.dat", GEOIP_STANDARD);

// map IP to country
echo "IP address 62.149.130.132 located in " . geoip_country_name_by_addr($handle, "62.149.130.132") . " (country code " . geoip_country_code_by_addr($handle, "62.149.130.132") . ")";

// close database handler
geoip_close($handle);

// print compulsory license notice
echo "<p> -- This product includes GeoIP data created by MaxMind, available from http://maxmind.com/ --";

?>

Мерси сега ще го мъча