Json Data Fetch in php

Question

i was using ip geolocation service but it limited per day so now iam tring to make a local script that do same thing i will try with php function thats get country dialing code from hostname here is my example

<?php
$country = geoip_country_code_by_name($_SERVER['REMOTE_ADDR']);

then i found in github an json data thats contain all countrys data that i want but i have a problem

json data that i have like that

[
    {
        "code": "AD",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1E9",
        "name": "Andorra",
        "title": "flag for Andorra",
        "dialCode": "+376"
    },
    {
        "code": "AE",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EA",
        "name": "United Arab Emirates",
        "title": "flag for United Arab Emirates",
        "dialCode": "+971"
    },
    {
        "code": "AF",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EB",
        "name": "Afghanistan",
        "title": "flag for Afghanistan",
        "dialCode": "+93"
    },
    {
        "code": "AG",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EC",
        "name": "Antigua and Barbuda",
        "title": "flag for Antigua and Barbuda",
        "dialCode": "+1268"
    },
    {
        "code": "AI",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EE",
        "name": "Anguilla",
        "title": "flag for Anguilla",
        "dialCode": "+1 264"
    },
    {
        "code": "AL",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F1",
        "name": "Albania",
        "title": "flag for Albania",
        "dialCode": "+355"
    },
    {
        "code": "AM",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F2",
        "name": "Armenia",
        "title": "flag for Armenia",
        "dialCode": "+374"
    },
    {
        "code": "AO",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F4",
        "name": "Angola",
        "title": "flag for Angola",
        "dialCode": "+244"
    },
    {
        "code": "AQ",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F6",
        "name": "Antarctica",
        "title": "flag for Antarctica",
        "dialCode": null
    },
    {
        "code": "AR",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F7",
        "name": "Argentina",
        "title": "flag for Argentina",
        "dialCode": "+54"
    }
]

so i want when i tell php to get me info about example : AO it return me the dialCode , name and emoji

can any one help me to do that in php

i do not have idea to make that i want

and iam so sorry for my bad language because iam from arabian country

THNX

Does this answer your question? [Getting the location from an IP address](https://stackoverflow.com/questions/409999/getting-the-location-from-an-ip-address) — Jacob Mulquin, Sep 20 '21 at 02:10
because i want to get the dialing code and emoji and the api services is limited so i will make it localy — tramp Kolo, Sep 20 '21 at 02:16
You can make use of their API to get the 2 letter code, and then use the JSON file you provided to get that bit of information. — Jacob Mulquin, Sep 20 '21 at 02:27
yes that what i want to do but my problem is how can i get that data from this json file with country 2 letters code/ — tramp Kolo, Sep 20 '21 at 02:30
You need to loop through JSON and build a new array with the 2 letter code as the key — Jacob Mulquin, Sep 20 '21 at 02:31
i did not tried codes becaus i dont have a good idea to make it i tried to fetch it manualy only — tramp Kolo, Sep 20 '21 at 02:39
OK well this is not the place where people code things for you, we can only help if you show us what you have tried. — Jacob Mulquin, Sep 20 '21 at 02:46

score 1 · Answer 1 · answered Sep 20 '21 at 02:52

Another approach is to create your own array and then just request your $code:

<?php
$json = '[
    {
        "code": "AD",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1E9",
        "name": "Andorra",
        "title": "flag for Andorra",
        "dialCode": "+376"
    },
    {
        "code": "AE",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EA",
        "name": "United Arab Emirates",
        "title": "flag for United Arab Emirates",
        "dialCode": "+971"
    },
    {
        "code": "AF",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EB",
        "name": "Afghanistan",
        "title": "flag for Afghanistan",
        "dialCode": "+93"
    },
    {
        "code": "AG",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EC",
        "name": "Antigua and Barbuda",
        "title": "flag for Antigua and Barbuda",
        "dialCode": "+1268"
    },
    {
        "code": "AI",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EE",
        "name": "Anguilla",
        "title": "flag for Anguilla",
        "dialCode": "+1 264"
    },
    {
        "code": "AL",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F1",
        "name": "Albania",
        "title": "flag for Albania",
        "dialCode": "+355"
    },
    {
        "code": "AM",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F2",
        "name": "Armenia",
        "title": "flag for Armenia",
        "dialCode": "+374"
    },
    {
        "code": "AO",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F4",
        "name": "Angola",
        "title": "flag for Angola",
        "dialCode": "+244"
    },
    {
        "code": "AQ",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F6",
        "name": "Antarctica",
        "title": "flag for Antarctica",
        "dialCode": null
    },
    {
        "code": "AR",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F7",
        "name": "Argentina",
        "title": "flag for Argentina",
        "dialCode": "+54"
    }
]';
$array = json_decode($json,true);
echo '<pre>';
foreach($array as $arry){
    $myArray[$arry['code']]['dialCode'] = $arry['dialCode'];
    $myArray[$arry['code']]['name'] = $arry['name'];
    $myArray[$arry['code']]['emoji'] = $arry['emoji'];
}
$code = 'AO';
print_r($myArray[$code]);

Returns :

Array
(
    [dialCode] => +244
    [name] => Angola
    [emoji] => 
)

Encoding should be utf-8.

score 0 · Answer 2 · answered Sep 20 '21 at 02:47

This is trivial, but here you go:

<?php

$data = <<<DATA
[
    {
        "code": "AD",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1E9",
        "name": "Andorra",
        "title": "flag for Andorra",
        "dialCode": "+376"
    },
    {
        "code": "AE",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EA",
        "name": "United Arab Emirates",
        "title": "flag for United Arab Emirates",
        "dialCode": "+971"
    },
    {
        "code": "AF",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EB",
        "name": "Afghanistan",
        "title": "flag for Afghanistan",
        "dialCode": "+93"
    },
    {
        "code": "AG",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EC",
        "name": "Antigua and Barbuda",
        "title": "flag for Antigua and Barbuda",
        "dialCode": "+1268"
    },
    {
        "code": "AI",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1EE",
        "name": "Anguilla",
        "title": "flag for Anguilla",
        "dialCode": "+1 264"
    },
    {
        "code": "AL",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F1",
        "name": "Albania",
        "title": "flag for Albania",
        "dialCode": "+355"
    },
    {
        "code": "AM",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F2",
        "name": "Armenia",
        "title": "flag for Armenia",
        "dialCode": "+374"
    },
    {
        "code": "AO",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F4",
        "name": "Angola",
        "title": "flag for Angola",
        "dialCode": "+244"
    },
    {
        "code": "AQ",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F6",
        "name": "Antarctica",
        "title": "flag for Antarctica",
        "dialCode": null
    },
    {
        "code": "AR",
        "emoji": "",
        "unicode": "U+1F1E6 U+1F1F7",
        "name": "Argentina",
        "title": "flag for Argentina",
        "dialCode": "+54"
    }
]
DATA;



$code = "AR";


$data = json_decode($data);
foreach($data as $country) {
    if ($country->code == $code) {
        $emoji = $country->emoji;
        $dialCode = $country->dialCode;
        $name = $country->name;
        break;
    }
}
echo $name;
echo $emoji;
echo $dialCode;

THANKS IN THE SECONDE U REPLIED I FOUND THE ANSWER BUT Iam thanking U TOO answerthat i found is same wuth some changers — tramp Kolo, Sep 20 '21 at 02:52
https://stackoverflow.com/questions/6661530/php-multidimensional-array-search-by-value — tramp Kolo, Sep 20 '21 at 02:52

Json Data Fetch in php

2 Answers2