Sort an object array by a column [duplicate]

Question

I want to sort my object array by date, which is like that:

$array = array( 
[0] = array ('date' => '2012-05-15', 'name' => 'jon')
[1] = array ('date' => '2012-05-10', 'name' => 'jon')
[2] = array ('date' => '2012-05-09', 'name' => 'jon')
[3] = array ('date' => '2012-05-16', 'name' => 'jon')
);

What method should I use?

Where do you get the data from? If you pull the data out of a database, you could edit the SQL query. — Ahatius
– Ahatius, Commented Apr 25, 2012 at 5:18
you cold edit the sql query, order by date :) so the result data will be order by date, it depends on you if you want ascending or descending 1keydata.com/sql/sqlorderby.html — SuperNoob
– SuperNoob, Commented Apr 25, 2012 at 5:25
yes I get this from database, but for my reasons I cant do sorting in database :) — Donatas Veikutis
– Donatas Veikutis, Commented Apr 25, 2012 at 5:25

Sampson · Accepted Answer · 2012-04-25 05:24:41Z

You could use usort() with some custom logic to accomplish this:

$array = array(
    array('date' => '2012-05-15', 'name' => 'jon'),
    array('date' => '2012-05-10', 'name' => 'jon'),
    array('date' => '2012-05-09', 'name' => 'jon'),
    array('date' => '2012-05-16', 'name' => 'jon')
);

function mySorter( $a, $b ) {
  if ( $a['date'] < $b['date'] ) return -1;
  if ( $a['date'] > $b['date'] ) return 1;
  return 0;
}

usort( $array, mySorter );

When all is said and done, $array now looks like this:

Array
(
    [0] => Array
        (
            [date] => 2012-05-09
            [name] => jon
        )
    [1] => Array
        (
            [date] => 2012-05-10
            [name] => jon
        )
    [2] => Array
        (
            [date] => 2012-05-15
            [name] => jon
        )
    [3] => Array
        (
            [date] => 2012-05-16
            [name] => jon
        )
)

Jack · Accepted Answer · 2012-04-25 05:32:30Z

1

uasort() is another option.

$array = array( 
array ('date' => '2012-05-15', 'name' => 'jon'),
array ('date' => '2012-05-10', 'name' => 'jon'),
array ('date' => '2012-05-09', 'name' => 'jon'),
array ('date' => '2012-05-16', 'name' => 'jon')
);

function date_sort($a, $b)
{
    if ( $a['date'] < $b['date'] ) return -1;
    if ( $a['date'] > $b['date'] ) return 1;
    return 0;
}

uasort($array, 'date_sort');
var_dump($array);

edited Apr 25, 2012 at 5:32

answered Apr 25, 2012 at 5:27

Jack

5,82812 gold badges52 silver badges76 bronze badges

Add a comment |

Community · Accepted Answer · 2023-11-21 15:10:29Z

Obviously, usort is the answer. But, if you want to specify the sorting criterion (sort by date or sort by name), you can do the following:

<?php
$sortOrder = 'date'; // default is to sort by date
$array = array( 
[0] = array ('date' => '2012-05-15', 'name' => 'jon')
[1] = array ('date' => '2012-05-10', 'name' => 'jon')
[2] = array ('date' => '2012-05-09', 'name' => 'jon')
[3] = array ('date' => '2012-05-16', 'name' => 'jon')
);

function date_sort($a, $b)
{
    global $sortOrder;

    if( $sortOrder == 'date' ) {
        if ( strtotime( $a['date'] ) < strtotime( $b['date'] ) ) return -1;
        if ( strtotime( $a['date'] ) > strtotime( $b['date'] ) ) return 1;
        return 0;
    } else if( $sortOrder == 'name' ) {
        return strcmp( $a['name'], $b['name'] );
    }
}

// sorted by date
uasort($array, 'mysort');


// sorted by name
$sortOrder = 'name';
uasort($array, 'mysort');
?>

Hope this helps.

Avyakt · Accepted Answer · 2012-04-25 05:43:44Z

-1

$array = array(
array ('date' => '2012-05-15', 'name' => 'jon'), 
array ('date' => '2012-05-10', 'name' => 'jon'),
array ('date' => '2012-05-09', 'name' => 'jon'),
array ('date' => '2012-05-16', 'name' => 'jon')

);

sort($array);

echo '<pre>';
print_r($array);
echo '</pre>';

Use already existing methods.

edited Apr 25, 2012 at 5:43

answered Apr 25, 2012 at 5:36

Avyakt

3134 silver badges11 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Sort an object array by a column [duplicate]

4 Answers 4

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Linked

Related