How to use php imap_sort to sort and retrieve last 10 messages

Issue

I want to retrieve the last 10 messages from gmail account and display them in a page. I have the following so far:

<!DOCTYPE html>
<html lang="en">
<head>
<link href="css/bootstrap.min.css" rel="stylesheet">
    <!--    <!--[if lt IE 9]>
            <script src="//html5shim.googlecode.com/svn/trunk/html5.js"></script>
        <![endif]-->
    <link href="css/styles.css" rel="stylesheet">

<!--<link rel="stylesheet" href="mail.css"/> -->

</head>

<body>
<?php

ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);
/* connect to gmail */
$user = '*****';
$password = '*********';
$mailbox = "{imap.gmail.com:993/imap/ssl}INBOX";

?>

<?php
$mbx = imap_open($mailbox , $user , $password);

/*imap_check returns information about the mailbox
including mailbox name and number of messages*/
//$check = imap_check($mbx);


/* grab emails */
$emails = imap_search($mbx, 'SINCE "10 Mar 2015"');

/* if emails are returned, cycle through each... */
if($emails) {

    /* begin output var */
    $output = '';


?>

<table class="table table-bordered table-hover">

 <tr> 
        <th>From</th>
        <th>Date</th>
        <th>Subject</th>
 </tr>

<?php    




    /* for every email... */
    foreach($emails as $email_number) {
       /* get information specific to this email */
        $overviews = imap_fetch_overview($mbx,$email_number,0);


/*imap_fetch_overview returns an overview for a message.
An overview contains information such as message subject,
sender, date, and if it has been seen. Note that it does
not contain the body of the message. Setting the second
parameter to "1:n" will cause it to return a sequence of messages*/

//$overviews = imap_fetch_overview($mbx,"1:{$check->Nmsgs}");
?>





<?php
 /* put the newest emails on top.Doesnt work.*/
 //   rsort($overviews);
 rsort($overviews);
 print_r($overviews);
foreach($overviews as $overview)
{
?>



     <tr>
          <td><?php echo $overview->from; ?></td>
          <td><?php echo $overview->date; ?></td>
          <td><a href="open.php?id=<?php echo $overview->uid; ?>"><?php echo $overview->subject; ?></a></td>
     </tr>
     <?php

   }
 }     

}
?>
</table>

</body>
</html>

I see a post here How can I sort arrays and data in PHP? but I’m having a hard time understanding how to sort on $overviews[date]. The rsort or any other sort not working. How do you specify you want to sort on the [date] property.thanks.

P.S. here is array:

Array ( [0] => stdClass Object ( [subject] => Fwd: A Short Course  STI #4653 [from] => Fran ***8olo [to] => Fran ****lo [date] => Tue, 10 Mar 2015 12:42:46 GMT [message_id] => <[email protected]> [size] => 28928 [uid] => 1532 [msgno] => 743 [recent] => 0 [flagged] => 0 [answered] => 0 [deleted] => 0 [seen] => 0 [draft] => 0 [udate] => 1425991366 ) )

Updated code using usort:

<?php

/* grab emails */
$emails = imap_search($mbx, 'SINCE "10 Mar 2015"');

/* if emails are returned, cycle through each... */
if($emails) {

    /* begin output var */
    $output = '';


?>

<table class="table table-bordered table-hover">

 <tr> 
        <th>From</th>
        <th>Date</th>
        <th>Subject</th>
 </tr>

<?php    




    /* for every email... */
    foreach($emails as $email_number) {
       /* get information specific to this email */
        $overviews = imap_fetch_overview($mbx,$email_number,0);


/*imap_fetch_overview returns an overview for a message.
An overview contains information such as message subject,
sender, date, and if it has been seen. Note that it does
not contain the body of the message. Setting the second
parameter to "1:n" will cause it to return a sequence of messages*/

//$overviews = imap_fetch_overview($mbx,"1:{$check->Nmsgs}");
?>





<?php
 /* put the newest emails on top.Doesnt work.*/
 //   rsort($overviews);
 usort($overviews, function($a1, $a2) {
   $v1 = strtotime($a1['date']);
   $v2 = strtotime($a2['date']);
   return $v1 - $v2; // $v2 - $v1 to reverse direction
});

 print_r($overviews);
foreach($overviews as $overview)
{
?>



     <tr>
          <td><?php echo $overview->from; ?></td>
          <td><?php echo $overview->date; ?></td>
          <td><a href="open.php?id=<?php echo $overview->uid; ?>"><?php echo $overview->subject; ?></a></td>
     </tr>
     <?php

   }
 }     

}
?>
</table>

Still getting a random sort when I retrieve the emails.

Solution

You can use USORT in php

usort($overviews, function($a1, $a2) {
   $v1 = strtotime($a1['date']);
   $v2 = strtotime($a2['date']);
   return $v1 - $v2; // $v2 - $v1 to reverse direction
});

Answered By – unixmiah

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published