PHP loop and get the lowest price
I need help navigating through a set of objects representing flight offers from country a
to b
, and each route can contain multiple offers. I want to get the lowest flight offer for each route ... I just don't know how to do this inside a loop. See this Answer on SO I tried working by giving me the lowest price, but how can I get the whole array of that price? I know this sounds stupid, but I'm stuck.
$results = array();
$offers = R::getAll( "SELECT * FROM fares WHERE available = 1 LIMIT 4");
$offers
returned sample dataset posted here on Fiddle
then I did the following:
foreach($offers as $key=>$val){
$results ['city'] = $val["name"];
$results ['country'] = $val["parent_name"];
$off = json_decode($val["Flights"]);
var_dump($off);
// here I need to loop through $off & grab the lowest
}
return $results;
$off
dump returns the following
object(stdClass)#60 (1) {
["BEY"]=>
array(4) {
[0]=>
object(stdClass)#61 (6) {
["price"]=>
int(490)
["airline"]=>
string(2) "ME"
["flight_number"]=>
int(276)
["departure_at"]=>
string(20) "2015-07-11T12:20:00Z"
["return_at"]=>
string(20) "2015-07-18T08:20:00Z"
["expires_at"]=>
string(20) "2015-06-30T14:31:43Z"
}
[1]=>
object(stdClass)#62 (6) {
["price"]=>
int(639)
["airline"]=>
string(2) "FZ"
["flight_number"]=>
int(716)
["departure_at"]=>
string(20) "2015-07-05T15:50:00Z"
["return_at"]=>
string(20) "2015-07-12T04:30:00Z"
["expires_at"]=>
string(20) "2015-07-01T08:11:49Z"
}
[2]=>
object(stdClass)#63 (6) {
["price"]=>
int(472)
["airline"]=>
string(2) "EY"
["flight_number"]=>
int(299)
["departure_at"]=>
string(20) "2015-07-18T03:10:00Z"
["return_at"]=>
string(20) "2015-07-28T04:30:00Z"
["expires_at"]=>
string(20) "2015-06-30T12:20:30Z"
}
[3]=>
object(stdClass)#64 (6) {
["price"]=>
int(2045)
["airline"]=>
string(2) "SU"
["flight_number"]=>
int(1861)
["departure_at"]=>
string(20) "2015-07-11T14:50:00Z"
["return_at"]=>
string(20) "2015-07-18T05:05:00Z"
["expires_at"]=>
string(20) "2015-06-30T14:31:43Z"
}
}
}
object(stdClass)#65 (1) {
["BEY"]=>
object(stdClass)#66 (3) {
["1"]=>
object(stdClass)#67 (6) {
["price"]=>
int(1903)
["airline"]=>
string(2) "EY"
["flight_number"]=>
int(461)
["departure_at"]=>
string(20) "2015-07-17T22:40:00Z"
["return_at"]=>
string(20) "2015-07-31T04:30:00Z"
["expires_at"]=>
string(20) "2015-07-01T10:46:41Z"
}
["2"]=>
object(stdClass)#68 (6) {
["price"]=>
int(1535)
["airline"]=>
string(2) "QF"
["flight_number"]=>
int(341)
["departure_at"]=>
string(20) "2015-07-17T11:00:00Z"
["return_at"]=>
string(20) "2015-07-31T22:55:00Z"
["expires_at"]=>
string(20) "2015-07-01T10:46:41Z"
}
["3"]=>
object(stdClass)#69 (6) {
["price"]=>
int(2321)
["airline"]=>
string(2) "AY"
["flight_number"]=>
int(5014)
["departure_at"]=>
string(20) "2015-07-17T11:45:00Z"
["return_at"]=>
string(20) "2015-07-31T22:55:00Z"
["expires_at"]=>
string(20) "2015-07-01T10:46:41Z"
}
}
}
ect .....
Any idea?
Thanks a lot!
+3
source to share
2 answers
Try the following:
foreach($offers as $key=>$val){
$results ['city'] = $val["name"];
$results ['country'] = $val["parent_name"];
$off = json_decode($val["Flights"], true); //note the true
$lowest = PHP_INT_MAX;
foreach ($off['BEY'] as $item)
$lowest = min($item['price'], $lowest);
//now $lowest is the lowest price
$lowest_item = null;
foreach ($off['BEY'] as $item)
if ($item['price'] == $lowest) {
$lowest_item = $item;
break;
}
//now you can do something with $lowest_item, like $lowest_item['flight_number']
}
+2
source to share
I think you can skip the last loop.
<?php
foreach ($offers as $key => $val) {
$results['city'] = $val["name"];
$results['country'] = $val["parent_name"];
$off = json_decode($val["Flights"], true);
$lowest = PHP_INT_MAX;
$lowest_item = null;
foreach ($off['BEY'] as $item) {
$lowest = min($item['price'], $lowest);
if ($item['price'] == $lowest) {
$lowest_item = $item;
}
}
// Now $lowest is the lowest price and
// you can do something with $lowest_item,
// like $lowest_item['flight_number'].
}
+3
source to share