Php array sort by date after merge

Question

Hi i have an array which is combinations of 2 separate array producing same result, following are my array after merge :

Array
(
    [0] => Array
        (
            [event_id] => 16
            [user_id] => 3
            [date_created] => 20130227095010

        )

    [1] => Array
        (
            [event_id] => 15
            [user_id] => 2
            [date_created] => 20130227101734

        )

    [2] => Array
        (
            [event_id] => 16
            [user_id] => 2
            [date_created] => 20130227094856

        )

)

From here onwards how can i sort again based on date_created desc or asc without using previously 2 arrays which i used to merge?

Update: previous array result

array1:

Array
(
    [0] => Array
        (
            [event_id] => 15
            [user_id] => 2
            [date_created] => 20130227101734


        )

    [1] => Array
        (
            [event_id] => 16
            [user_id] => 2
            [date_created] => 20130227094856

        )

)

array 2:

Array
(
    [0] => Array
        (
            [event_id] => 16
            [user_id] => 3
            [date_created] => 20130227095010

        )

)

How can i use loop within these function to extract date_created for each of above arrays

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

array_map is used to apply a function to each element of the array, not sorting the array itself — MatRt
– MatRt, Commented Feb 27, 2013 at 2:32

alex · Accepted Answer · 2013-02-27 02:31:53Z

2

Very easy with something like usort().

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

answered Feb 27, 2013 at 2:31

alex

492k205 gold badges890 silver badges992 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Matthew Over a year ago

The date_created key of $a and $b should be compared.

alex Over a year ago

@Matthew Whoops, I missed that somehow :)

d3bug3r Over a year ago

@alex is there away to sort after merge without using previously 2 arrays used to merge?

alex Over a year ago

@zlippr I'm not using two arrays.

d3bug3r Over a year ago

@alex how can i use loop to get $a['date_created'] - $b['date_created'] since for me it looks like this $a[$i]['date_created'] - $b[$i]['date_created'] ?

MatRt · Accepted Answer · 2013-02-27 02:31:33Z

1

You can create your own sort function callback and use it with the usort method. There is need to re-use your first 2 arrays.

usort($yourMergedArray, yourCallBackSort);

and

function yourCallBackSort($firstEntry, $secondEntry)
{
    // Do some stuff to compare your values and return -1, 0 or 1
    // depend if $firstEntry id <, = or > to $secondEntry
}

answered Feb 27, 2013 at 2:31

MatRt

3,5441 gold badge22 silver badges15 bronze badges

Comments

Prasanth Bendra · Accepted Answer · 2013-02-27 04:38:55Z

0

Try this,

$sort = array();
foreach($your_combined_array as $k=>$v) {
    $sort['date_created'][$k] = $v['date_created'];
}

array_multisort($sort['date_created'], SORT_DESC, $your_combined_array);


echo "<pre>";
print_r($your_combined_array);

answered Feb 27, 2013 at 4:38

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

Collectives™ on Stack Overflow

Php array sort by date after merge

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related