How to filter array using same key value of(preview_url and countries code) and return higher amount of array and unmatch array data will be same

Question

I have this array i want sorting using same preview_url and same countries code and want result which array have higher amount of value and unmatch array data remain same. I want result i have add in comment please provide sollution for same i have stuck on this issue from couple of days

Thanks in advance

Array
(
    [id] => 377556        
    [amount] => 1.46000
    [preview_url] => https://itunes.apple.com/app/id543186831?mt=8
    [countries] => Array
        (
            [US] => Array
                (
                    [id] => 840
                    [code] => US
                    [name] => united states
                    [regions] => Array
                        (
                        )
                )
        )
)
Array
(
    [id] => 377557        
    [amount] => 2.46000
    [preview_url] => https://itunes.apple.com/app/id543186831?mt=8
    [countries] => Array
        (
            [US] => Array
                (
                    [id] => 840
                    [code] => US
                    [name] => united states                        
                )
            [UK] => Array
                (
                    [id] => 841
                    [code] => UK
                    [name] => united kingdom
                )    
        )
)

i want this result Array ( [id] => 377557 [amount] => 2.46000 [preview_url] => https://itunes.apple.com/app/id543186831?mt=8[countries] => Array ( [US] => Array ( [id] => 840 [code] => US [name] => united states) [UK] => Array ( [id] => 841 [code] => UK [name] => united kingdom [regions] => Array ( ) ) ) ) — Er Nilay Parekh, Mar 30 '17 at 11:42

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

You can sort it by using usort.

usort($array, function($a, $b) {
     return $a['amount'] < $b['amount'];
});

For details refer this great answer by christian. Kudos

Happy Coding.

edited Jun 20 '20 at 09:12

Community

1
1

answered Mar 30 '17 at 11:55

Touheed Khan

2,149
16
26

thanks for answering but i have to compare with preview_url and countrie code so how can i compare? – Er Nilay Parekh Mar 30 '17 at 12:03
how can i comapare for preview url and countri code? – Er Nilay Parekh Mar 30 '17 at 12:14
you want to sort on basis of amount or preview url ? – Touheed Khan Mar 30 '17 at 12:52
i want to sort with both previewurl and country with higher amount value – Er Nilay Parekh Mar 30 '17 at 13:02
can you please mention priority of order in which you want to sort. clear what you want to achieve. First sort on basis of amount, then on preview url, am I right ? country is an array, on what key of country you want to sort ? – Touheed Khan Mar 30 '17 at 13:11
i want this result Array ( [id] => 377557 [amount] => 2.46000 [preview_url] => itunes.apple.com/app/id543186831?mt=8[countries] => Array ( [US] => Array ( [id] => 840 [code] => US [name] => united states) [UK] => Array ( [id] => 841 [code] => UK [name] => united kingdom [regions] => Array ( ) ) ) ) – Er Nilay Parekh Mar 31 '17 at 04:20
if preview_url and countri code is same then i want to display array who has higher amount value – Er Nilay Parekh Mar 31 '17 at 04:41
is there any update on my question i am still not getting proper sollution for same – Er Nilay Parekh Mar 31 '17 at 12:32

score 0 · Answer 2 · answered Mar 30 '17 at 12:14

0

You have to use multisort

$mylist = array(
array('ID' => 1, 'title' => 'Boring Meeting', 'event_type' => 'meeting'),
array('ID' => 2, 'title' => 'Find My Stapler', 'event_type' => 'meeting'),
array('ID' => 3, 'title' => 'Mario Party', 'event_type' => 'party'),
array('ID' => 4, 'title' => 'Duct Tape Party', 'event_type' => 'party')
);
# get a list of sort columns and their data to pass to array_multisort
$sort = array();
foreach($mylist as $k=>$v) {
$sort['title'][$k] = $v['title'];
$sort['event_type'][$k] = $v['event_type'];
}
# sort by event_type desc and then title asc
array_multisort($sort['event_type'], SORT_DESC, $sort['title'], SORT_ASC,$mylist);
$mylist = array(
array('ID' => 1, 'title' => 'Boring Meeting', 'event_type' => 'meeting'),
array('ID' => 2, 'title' => 'Find My Stapler', 'event_type' => 'meeting'),
array('ID' => 3, 'title' => 'Mario Party', 'event_type' => 'party'),
array('ID' => 4, 'title' => 'Duct Tape Party', 'event_type' => 'party')
);
# get a list of sort columns and their data to pass to array_multisort
$sort = array();
foreach($mylist as $k=>$v) {
$sort['title'][$k] = $v['title'];
$sort['event_type'][$k] = $v['event_type'];
}
# sort by event_type desc and then title asc
array_multisort($sort['event_type'], SORT_DESC, $sort['title'], SORT_ASC,$mylist);

now my array will

array (
0 => 
array (
'ID' => 4,
'title' => 'Duct Tape Party',
'event_type' => 'party',
),
1 => 
array (
'ID' => 3,
'title' => 'Mario Party',
'event_type' => 'party',
),
2 => 
array (
'ID' => 1,
'title' => 'Boring Meeting',
'event_type' => 'meeting',
),
3 => 
array (
'ID' => 2,
'title' => 'Find My Stapler',
'event_type' => 'meeting',
),
)

answered Mar 30 '17 at 12:14

Jagdish Chaudhary

287
1
17

This is not my sollution – Er Nilay Parekh Mar 30 '17 at 12:24
can you explain in detail? – Jagdish Chaudhary Mar 30 '17 at 12:44
if preview_url and countri code is same then i want to display array who has higher amount value – Er Nilay Parekh Mar 31 '17 at 06:48
i want this result Array ( [id] => 377557 [amount] => 2.46000 [preview_url] => itunes.apple.com/app/id543186831?mt=8[countries] => Array ( [US] => Array ( [id] => 840 [code] => US [name] => united states) [UK] => Array ( [id] => 841 [code] => UK [name] => united kingdom [regions] => Array ( ) ) ) ) – Er Nilay Parekh Mar 31 '17 at 06:48
First you have to sort your inner array using foreach..and then you can easily sort your outer erray using sort function [plz visit here](http://php.net/manual/en/function.array-multisort.php) and you have to use some good logic – Jagdish Chaudhary Mar 31 '17 at 06:52
but which method i have to use for sorting (preview_url and countries code ) and then i have to select higher amount of array – Er Nilay Parekh Mar 31 '17 at 12:20
Bro as per your requirements take your any one array and sort it using sort function after it sort another array – Jagdish Chaudhary Mar 31 '17 at 12:24
can you code what you want to say? – Er Nilay Parekh Mar 31 '17 at 12:32
not now but i will do it when i will free. i will also learn something new from this – Jagdish Chaudhary Mar 31 '17 at 12:33
ok please update me when you get time and thanks in advance ...!! – Er Nilay Parekh Mar 31 '17 at 13:01
Sure i will update asap – Jagdish Chaudhary Mar 31 '17 at 13:30
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/139635/discussion-between-er-nilay-parekh-and-jagdish-chaudhary). – Er Nilay Parekh Apr 01 '17 at 04:16

How to filter array using same key value of(preview_url and countries code) and return higher amount of array and unmatch array data will be same

2 Answers2