How can I parse the output from HostIP's geolocation API?

Question

If I access the HostIP geolocation API via http://api.hostip.info/get_html.php?ip=193.148.1.1, it returns three lines of text:

Country: SPAIN (ES)
City: (Unknown city)
IP: 193.148.1.1

How can I parse that output in PHP to extract the country name?

not really, he has one, just needs a way to parse it. Though he should probably check that question (might already have an alternate solution). — Jess, Mar 27 '11 at 20:46

score 3 · Accepted Answer · answered Mar 27 '11 at 20:45

3

Try these preg_matches

$info = "Country: SPAIN (ES)
City: (Unknown city)
IP: 193.148.1.1";

preg_match("/Country: (.*)\n/", $info, $out);
echo $out[1];

## OR
preg_match ("/Country: (.*) \(.*\)?\n/", $info, $out);
echo $out[1];

answered Mar 27 '11 at 20:45

Jess

8,628
6
49
67

score 1 · Answer 2 · answered Mar 27 '11 at 20:49

1

Would some regex for PHP help?

if (preg_match('/Country: (.*[^\n\r])/i', $subject, $regs)) {
    $result = $regs[1];
} else {
    $result = "";
}

You will have: 

Match 1: Country: SPAIN (ES)
Group 1: SPAIN (ES)

answered Mar 27 '11 at 20:49

Glycerine

7,157
4
39
65

score 1 · Answer 3 · answered Mar 27 '11 at 21:18

You can obtain an XML response from hostip.info if you use the following URL:

http://api.hostip.info/?ip=193.148.1.1

instead of:

http://api.hostip.info/get_html.php?ip=193.148.1.1

Then, you can parse the XML which is kind of cleaner than Regex, and probably more immune to the possible changes of output formatting.

This is an example of parsing the output:

$response = file_get_contents('http://api.hostip.info/?ip=193.148.1.1');

$xml = new DOMDocument();
$xml->loadXml($response);

$xpath = new DOMXpath($xml);

$path = '/HostipLookupResultSet/gml:featureMember/Hostip/';

$ip = $xpath->evaluate($path . 'ip')->item(0)->nodeValue;
$city = $xpath->evaluate($path . 'gml:name')->item(0)->nodeValue;
$countryName = $xpath->evaluate($path . 'countryName')->item(0)->nodeValue;
$countryAbbrev = $xpath->evaluate($path . 'countryAbbrev')->item(0)->nodeValue;

quenotacom · Answer 4 · 2013-08-28T21:10:03.470

0

http://api.hostip.info/get_json.php?position=true

{"country_name":"VENEZUELA","country_code":"VE","city":"Caracas","ip":"xxx.xx.xxx.xx","lat":"x.xxx","lng":"-xx.xxxx"}

edited Aug 28 '13 at 21:10

answered Aug 28 '13 at 21:04

quenotacom

1
3

score 0 · Answer 5 · answered Dec 01 '14 at 20:02

0

function _get_country_from_IP($ip) {
  $data = json_decode(file_get_contents("http://ipinfo.io/{$ip}/json"));
  return $country = isset($data->country) ? $data->country : 'UNKNOWN';
}

answered Dec 01 '14 at 20:02

John O

71
1
3

2

Please add some comments as to how your code answers the question. – Chrismas007 Dec 01 '14 at 20:07

score 0 · Answer 6 · answered Mar 27 '11 at 20:47

0

country only: http://api.hostip.info/country.php?ip=193.148.1.1

answered Mar 27 '11 at 20:47

How can I parse the output from HostIP's geolocation API?

6 Answers6