JSON response through URL not displaying

Question

Hi I have a page link with json data. I wanted to fetch them from url. I tried below code. But that not working for me.

<?php
echo $URL1 = "https://www.the-worldwide.com/wp-content/themes/thewebconz/Live-6-cid/functions.php";
    $vars1 = "action=Hotel_Description&hotel_id=438271&cid=457428&apiKey=5jjdvgnq9aug1a4ucvatvq4b8u&ModeType=Live&secret=9hs897nn3e9av";
$URLs_Fetch1 = $URL1."?".$vars1; 

        $json = file_get_contents($URLs_Fetch1);

$data = json_decode($json,true);

$Geonames = $data;

echo "<pre>";

print_r($Geonames);     
?>

But if you normally visit that page you can see many json data there.

https://www.the-worldwide.com/wp-content/themes/thewebconz/Live-6-cid/functions.php?action=Hotel_Description&hotel_id=438271&cid=457428&apiKey=5jjdvgnq9aug1a4ucvatvq4b8u&ModeType=Live&secret=9hs897nn3e9av

Demo

The error you get is pretty obvious, not? **Warning: file_get_contents(): Unable to find the wrapper "https" - did you forget to enable it when you configured PHP?** — Ofir Baruch, Feb 02 '17 at 05:47
@Deep is there any way I can print full json response data? It will help me to parse data from resource. — Lemon Kazi, Feb 02 '17 at 05:47
@OfirBaruch Bro my site link is that https://www.the-worldwide.com/ How can I make it http:// I have to use https:// — Lemon Kazi, Feb 02 '17 at 05:50
You can either change your code (use cURL) or update your php configuration (http://stackoverflow.com/a/9791203/998096) — Ofir Baruch, Feb 02 '17 at 05:53
@OfirBaruch I used curl method too. https://eval.in/728830 that also not working. — Lemon Kazi, Feb 02 '17 at 05:58
Your PHP is missing the cURL extension. You need to install it (http://www.php.net/manual/en/curl.setup.php) — Ofir Baruch, Feb 02 '17 at 05:59
Actually the output from the given url is not a valid json response — M A SIDDIQUI, Feb 02 '17 at 06:46

score 2 · Accepted Answer · answered Feb 02 '17 at 07:06

If you use jsonlint to validate the response of the url directly from browser you will find that the output is not a valid json response. hence you are unable to decode it. All you need to do is remove html tags which are hidden and hotel_id content and and issues with new lines . After solving those issues it becomes a valid json response. and there you go.

<?php
$base_url = "https://www.the-worldwide.com/wp-content/themes/thewebconz/Live-6-cid/functions.php";
$data = [
    "action" => "Hotel_Description",
    "hotel_id" => 438271,
    "cid" => 457428,
];
$config = [
    "apiKey" => "5jjdvgnq9aug1a4ucvatvq4b8u",
    "ModeType" => "Live",
    "secret" => "9hs897nn3e9av"
];
function buildUrl($base_url, $data, $config)
{
    $url = $base_url."?";
    $data_uri = "";
    foreach ($data as $data_key => $data_value) {
        $data_uri .= "$data_key=$data_value&";
    }
    $config_uri = "";
    foreach ($config as $config_key => $config_value) {
        $config_uri .= "$config_key=$config_value&";
    }
    $url= $base_url."?".$data_uri.rtrim($config_uri, "&");
    unset($data_uri);
    unset($config_uri);
    return $url;
}
$url = buildUrl($base_url, $data, $config);
$content = file_get_contents($url);
$new_content = str_replace("<HotelInformationRequest><hotelId>".$data['hotel_id']."</hotelId><options>0</options></HotelInformationRequest>", "", $content);
$json_content = str_replace("\n", " ", $new_content);

thanks bro. u are right. the output data was not as json response. i solved that. thanks. — Lemon Kazi, Feb 02 '17 at 08:46
Whoever down voted please take out your precious time to mention the reason — M A SIDDIQUI, Feb 03 '17 at 06:19

score 0 · Answer 2 · edited May 23 '17 at 10:30

0

Install php5-openssl Restart Apache afterwards. There is already an answer on SO about this,

if not worked then add extension=php_openssl.dll to your php.ini file located in xampp/php/php.ini or wamp\path to php.ini file.

i.e. just add two lines in your php.ini file.

extension=php_openssl.dll
allow_url_include = On

If these will not help you out then please let me know.

edited May 23 '17 at 10:30

Community

1
1

answered Feb 02 '17 at 05:50

Deep Kakkar

5,831
4
39
75

Thanks Deep for answer. I am trying it from my end. I will let you know soon. :) – Lemon Kazi Feb 02 '17 at 06:06

JSON response through URL not displaying

2 Answers2