Display results not working

oracle765 · January 24, 2014

Hi I am querying skyscanner api and the output does not seem to show, even though it works fine for expedias on the same page, any ideas what I could be missing, it says something about An HTTP header value of 'application/json' should be specified to return data in json format

here is my code

skyscanner.php

denno020 · January 25, 2014

It looks like it's told you already what you need to do..

Without looking at your code, I would assume you're doing something like this:

$arr = array( /* lots of data*/);
echo json_encode($arr);

The error message is asking for the header, so on the line directly before your echo, you need to add

header('Content-Type: application/json');

Hope that helps.

Denno

Ch0cu3r · January 25, 2014

You are not accessing their api correctly. The url you are using is for setting up the api parameters.

With these parameters you need to create a session with a POST request. To do this you'll need to use cURL. Their api will then the return a session, which you'll use to retrieve the data.

// get the api parametures from setup url
$apiParamsUrl = "http://www.skyscanneraffiliate.net/portal/en-GB/UK/LivePricing/TestHarness?apikey=cc379434454338361714672782744594&country=GB&currency=GBP&locale=en-GB&originplace=edi&destinationplace=lon&outbounddate=2014-01-31&inbounddate=2014-02-07&adults=1&children=0&infants=0&locationschema=iata&cabinclass=economy";
$apiParamsStr = parse_url($apiUrl, PHP_URL_QUERY); // get the query string parametures
parse_str($apiParamsStr, $apiParamsArray); // parse into an array

// the api url. First we need to request for a session
$apiSessionUrl = 'http://partners.api.skyscanner.net/apiservices/pricing/v1.0';

//open connection
$ch = curl_init();

//set the url, number of POST vars, POST data
curl_setopt($ch,CURLOPT_URL, $apiSessionUrl);
curl_setopt($ch,CURLOPT_HTTPHEADER, array('Content-Type: application/x-www-form-urlencoded', 'Accept: application/json')); // make api return json data
curl_setopt($ch,CURLOPT_POST, count($apiParamsArray)); // set how many fiels
curl_setopt($ch,CURLOPT_POSTFIELDS, $apiParamsStr);    // set the fields

// caputre the headers
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_HEADER, 1);

//execute post
$response = curl_exec($ch);

// get the headers
$header_size = curl_getinfo($ch, CURLINFO_HEADER_SIZE);
$header = substr($response, 0, $header_size);
$body = substr($response, $header_size);

//close connection
curl_close($ch);

// get the api session url
preg_match('~Location: ([^\s]+)~', $header, $matches);
$apiSessionUrl = $matches[1];

// add on the api key for the session
$apiSessionUrl .= '?apiKey=' . $apiParamsArray['apikey'];

// get the json data
$data = file_get_contents($apiSessionUrl);

// decode the json
$array = json_decode($data);

// dump json array
printf('<pre>Poll Data  %s</pre>', print_r($array, true));

Edited January 25, 2014 by Ch0cu3r

oracle765 · January 27, 2014

thanks for that, but to be honest that's way beyond me lol

do you do any freelance work, I posted something like this but never got a reply in the freelance section

thankyou

oracle765 · January 27, 2014

because all I see in my screen when using this code is "poll data"

Ch0cu3r · January 27, 2014

because all I see in my screen when using this code is "poll data"

I have an error in my code, change $apiUrl to $apiParamsUrl

oracle765 · January 27, 2014

hey Ch0cu3r

That's great it works, so how as you can now see via www.compareandchoose.com.au/skyscanner.php

How do you actually get rid of all the => <> etc to pull the destination and price out of the arrays to present to the users

oracle765 · January 27, 2014

if tried

foreach ($array['Itineraries']['PricingOptions'] as $arr) {

echo " Price " .$arr['Price'], " price ,$arr['Price'] ?>

<?php

}

?>

to try and echo out the Price twice but I just get an error saying

Fatal Error: Cannot use object of type stdClass as array in /home/etc/etc/skyscanner.php

Ch0cu3r · January 27, 2014

Try setting json_decode to $array = json_decode($data, true);

You'd loop over the itinerary price options using

foreach ($array['Itineraries'] as $Itineraries) {
	foreach($Itineraries['PricingOptions'] as $Option) {
              echo "<b> Price </b> " .$Option['Price'], " <br> price </b>",$Option['Price'] ,"<br />";
        }
}

Edited January 27, 2014 by Ch0cu3r

oracle765 · January 27, 2014

thanks again but it still comes up with that fatal error for some reason!

I have included my whole page just incase I am missing something as you can see at www.compareandchoose.com.au/skyscanner.php my end goal is to provide an itinery to the users so they can go and book, but the out put in that array is a bit confusing for me to try and present nicely to them

skyscanner.php

oracle765 · January 27, 2014

I forgot to set json to true sorry, that managed to get the price

oracle765 · January 27, 2014

Hi Ch0cu3r

I have been trying to extract all the information to provide the customer with a readable itinerary however the array within arrays has me so confused it just will not work.

here is what I have so far to try and loop through the file

thanks

Alan

skyscanner.txt

Ch0cu3r · January 28, 2014

For displaying the Legs, Carriers and Places you don't need the secondary foreach loop. Also $Option['Agents'] contains an array of agents, to display these implode them.

		//Itineraries
		foreach ($array['Itineraries'] as $Itineraries) {
		
			foreach($Itineraries['PricingOptions'] as $Option) {
              	echo "<b> Price </b> " .implode(',', $Option['Agents']), " <br> price </b>",$Option['Price'] ,"<br />";
        	}
		}
		
		//Legs
		foreach ($array['Legs'] as $Leg) {
		
			echo "<b> Departure </b> " .$Leg['Departure'], " <br> <b>Arrival </b>",$Leg['Arrival'] ,"<br />";
		}
		
		//Carriers
		foreach ($array['Carriers'] as $Carrier) {
		
				echo "<b> Name </b> " .$Carrier['Name'], " <br> Image </b>",$Carrier['ImageUrl'] ,"<br />";
		}
		
		//Places
		foreach ($array['Places'] as $Place) {
		
			echo "<b> Code </b> " .$Place['Code'], " <br> Name </b>",$Place['Name'] ,"<br />";
		}

Also checkout the code I sent you in PM

Edited January 28, 2014 by Ch0cu3r

oracle765 · January 29, 2014

hi CH0cu3r

Thanks for that as it now extracts results, but as you can see it just produces lines and lines of prices, airlines etc, how do you actually know which Agent, flight, airline, price etc is linked to which

EG Image, British airways, from, to, departure, arrival, price etc

Image, Air Lingus, from, to, departure, arrival, price etc and so on

again thanks in advance you have been a massive help in figuring out my array problems which I am totally new to

Ch0cu3r · January 29, 2014

The Itinerary array contains a list of flights. Each flight contains a PricesOption array which lists the booking agents and their price. Each agent has their own unique id, to get the agent name/image you need to look up the agent id within the $array['Agents'] array.

To get the flight information you need to look up the OutboundLegId and InboundLegId within the $array['Legs'] array. This will return an array of information about depature and arrival airports. The OriginStation (departure) and DestinationStation (arrival) keys return the airport ids. To the get the airport names you need to look up these ids within the $array['Places'] array.

You'll also get the flight carrier from the $array['Legs'] array, again each carrier has their own unique id which you you need to loop up within the $array['Carriers'] array.

.

Edited January 29, 2014 by Ch0cu3r

oracle765 · January 29, 2014

ok thanks just on the last part you say

You'll also get the flight carrier from the $array['Legs'] array, again each carrier has their own unique id which you need to loop up within the $array['Carriers'] array

could you explain what you mean by loop up with that array, sorry to be a pain but arrays are my weekpoint lol

thanks again your an excellent role model to this forum

Ch0cu3r · January 29, 2014

By look up I mean loop through the array of carriers within $array['Carriers']. You'd check to see if the Id matches the carrier for the flight Id.

The easiest way I found to do this was to create a function. It'll extract the Agents, Carriers, Legs and Places arrays. It'll then loop through these arrays setting the Id as the key for each item. This makes looking up the ids for Agents, Carriers, Legs and Places arrays alot easier as you can just pass in the necessary id to get their data.

Example code for getting the agent names

$Agents   = extractItem($array, 'Agents');   // get array of agents
//...

foreach ($array['Itineraries'] as $Itineraries) {
        foreach($Itineraries['PricingOptions'] as $Option) {
             echo "<b> Agents: </b> ";

             // loop over agents for current priceOption
             foreach($Option['agents'] as $agentId) {
                  echo $Agents[ $agentId ]['Name']. ', '; // echo the agent name that matches agentId.
             }
               
             echo " <br> price </b>",$Option['Price'] ,"<br />";
       }
}

The code for extractItem() is

function extractItem(&$array, $itemkey)
{
	$data = array();
        
	foreach($array[$itemKey] as $item)
	{
              $Id = $item['Id'];  // get the id
              unset($item['Id']); // remove the id from item array
              $data[$Id] = $item; // set id as the key
	}

	unset($array[$itemKey]); // remove item from array.

	return $data; // return the new item array
}

Edited January 29, 2014 by Ch0cu3r

oracle765 · January 30, 2014

Hi again

Now I just get Agents , just a comma and Price is fine, no name showing, I thought it might have been agents supposed to show a capital A but that didn't work either

you can see on www.compareandchoose.com.au/skyscanner.php

here is my code for clarity sake

once again many thanks

skyscanner.php

Ch0cu3r · January 30, 2014

$Option['agents'] should be $Option['Agents]

function extractItem(&$array, $itemkey) should be function extractItem(&$array, $itemKey)

oracle765 · February 17, 2014

Hey Ch0cu3r hope your keeping ok

Im really stuck again with these arrays lol how do I drill down in this array,this might be simple to you but its very complex for me

I have attached the data its extracted so far

what I am looking to pull out is the

description, manufacturer, the store name who sells it EG appliances online, image of the item and logo of the store etc, your intelligent enough so you will know what I mean.

thanks in advance

alan

oracle765 · February 17, 2014

print_r($json_arr);

		foreach ($json_arr ['categories'] as $categories) 
		{		
			foreach($categories['category'] as $category) 
			{
				echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
				 
				foreach($category['item'] as $Option) 
				{
              	echo "<b> Name </b> " .implode(',', $Option['name']), " <br> manufacturer </b>",$Option['manufacturer'] ,"<br />";
				}
        	}
		}

PS ive tried this but its returning nothing

Edited February 17, 2014 by oracle765

Ch0cu3r · February 17, 2014

$category['item'] will contain a sub array, either offer or product. You need to loop through this sub array to get the products info

Try

foreach ($json_arr['categories'] as $categories) 
{		
    foreach($categories['category'] as $category) 
    {
        echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
		 
        foreach($category['item'] as $item)
        {
             // get the sub array key
             $key = key($item);

             echo "<p><b> Name </b> " .implode(',', $item[$key]['name']), " <br> manufacturer </b>",$item[$key]['manufacturer'] ,"<p>";

             // get item description, 
             // for offer use description key
             // for product use fullDescription key
             echo "<p><b>Description</b> " . (($key == 'offer') ? $item[$key]['description'] : $item[$key]['fullDescription']) . '</p>';

            // display product images
            echo '<p><b>Images: </b>';
            foreach($item[$key]['imageList']['image'] as $image)
            {
                echo '<img src="'.$image['SourceUrl'].'" />   ';
            }
            echo '</p>

            // the store logo and name
            echo '<p><b>Store: </b> <img src="'$item[key]['store']['logo']['sourceURL']'" /> ' .$item[key]['store']['name'] .'</p>';
            echo '<hr />';
       }
   }
}

oracle765 · February 17, 2014

foreach ($json_arr['categories'] as $categories) 
{		
    foreach($categories['category'] as $category) 
    {
        echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
		 
        foreach($category['item'] as $item)
        {
             // get the sub array key
             $key = key($item);

             echo "<p><b> Name </b> " .implode(',', $item[$key]['name']), " <br> manufacturer </b>",$item[$key]['manufacturer'] ,"<p>";

             // get item description, 
             // for offer use description key
             // for product use fullDescription key
             echo "<p><b>Description</b> " . (($key == 'offer') ? $item[$key]['description'] : $item[$key]['fullDescription']) . '</p>';

            // display product images
            echo '<p><b>Images: </b>';
            foreach($item[$key]['imageList']['image'] as $image)
            {
                echo '<img src="'.$image['SourceUrl'].'" />   ';
            }
            echo '</p>';

            // the store logo and name
           // echo '<p><b>Store: </b> <img src="' $item[key]['store']['logo']['sourceURL']'" /> ' .$item[key]['store']['name'] '</p>';
            echo '<hr />';
       }
   }
}

Hi again

ive tried this today but nothing seems to be coming back again

my dreamweaver was showing an error on the second last line of echo code that I commented out because I could not figure it out and I did notice a semi colon missing from an echo statement above which I fixed but its still showing nothing

here is what I have so far, I think it might be just a formatting error with the " ' etc but not sure

oracle765 · February 18, 2014

//THIS ONE WORKS OK

foreach($json_arr ['categories']['category'] as $arr){

    // $arr will be an array of each url data
	echo "<b> Link </b><a href=" .$arr['categoryURL'].">Apple</a>"?><br /><br /><?php 

}

foreach($json_arr ['categories'] as $categories) 
{		
    foreach($categories ['category'] as $category) 
    {
        echo "<b> Link </b>" .$category['categoryURL'] ,"<br/>";
		/*
        foreach($category['item'] as $item)
        {
             // get the sub array key
             $key = key($item);

             echo "<p><b> Name </b> " .implode(',', $item[$key]['name']), " <br> manufacturer </b>",$item[$key]['manufacturer'] ,"<p>";

             // get item description, 
             // for offer use description key
             // for product use fullDescription key
             echo "<p><b>Description</b> " . (($key == 'offer') ? $item[$key]['description'] : $item[$key]['fullDescription']) . "</p>";

            // display product images 
			
            echo "<p><b>Images: </b>";
            foreach($item[$key]['imageList']['image'] as $image)
            {
                echo "<img src='" .$image['sourceUrl']. "' />   ";
            }
            echo "</p>";
			
            // the store logo and name
            echo "<p><b>Store: </b> <img src='" .$item[key]['store']['logo']['sourceURL']. "' /> " .$item[key]['store']['name']. "</p>";
            echo "<hr />";
       } */
   }
}

Hi ive commented out the inner foreach loops to try and figure out whats going on but it seems not to work still

im a bit confused as the second attachment loop works

Ch0cu3r · February 18, 2014

The code I posted was untested. I coded it from looking at array structure you posted. Try the following instead

foreach ($json_arr['categories']['category'] as $category) 
{       
    echo "<b> Link </b>" .$category['categoryURL'] ."<br/><hr /><h2>Products</h2>";
     
    foreach($category['items']['item'] as $item)
    {
         // get the sub array key
         $key = key($item);

         echo "<p><b>Name: </b> " .$item[$key]['name']. " </p>";
         echo "<p><b>Manufacturer: </b>" . (isset($item[$key]['manufacturer']) ? $item[$key]['manufacturer'] : '') . "</p>";

         // get item description, 
         // for offer use description key
         // for product use fullDescription key

         $descriptionKey = ($key == 'offer') ? 'description' : 'fullDescription';
        echo "<p><b>Description</b> " . $item[$key][$descriptionKey] . '</p>';

        // display product images
        echo '<p><b>Images: </b>';

        $imageListKey = ($key == 'offer') ? 'imageList' : 'images';
        foreach($item[$key][$imageListKey]['image'] as $image)
        {
            echo '<img src="'.$image['sourceURL'].'" />   ';
        }
        echo '</p>';

        // the store logo and name
        echo '<p><b>Buy From: </b>';
        if(isset($item[$key]['store']))
        {
            echo '<img src="'.$item[$key]['store']['logo']['sourceURL'].'" /> ' .$item[$key]['store']['name'] .'</p>';
        }
        echo '<hr />';
   }
}

Sign In

Display results not working

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information