PHP Array group by month

twistedindustries · May 10, 2011

I have been struggling with this for awhile now, and I think it isn't as hard as I making it. Basically I want to "group" my array by month making a multidimensional array by months. Basically right now my print_r($my_array) outputs:

I need to take that and make it look like this, grouping by the month of the 'dates' value:

Psycho · May 10, 2011

Where are you getting these values from? If you are getting from a DB you should order the records appropriately there. Although, there is usually no need to physically group them in an array since you can handle that in the processing code.

But, if you really need to do this, the only way I can see to do it is to loop over each record and create a new array. Also, I would set the key for the "grouped" elements to the month number for ease of use.

$groupedArray = array();
foreach($originalArray as $key => $valuesAry)
{
    $month = date('n', strtotime($valuesAry['dates']));
    $groupedArray[$month][] = $valuesAry;
}
//$groupedArray now holds the data from $originalArray in a grouped format

twistedindustries · May 10, 2011

Thank you for your help but after trying this code:

$originalArray = $this->_data;
$groupedArray = array();
foreach($originalArray as $key => $valuesAry)
{
    $month = date('n', strtotime($valuesAry['dates']));
    $groupedArray[$month][] = $valuesAry;
}

I get this error: Fatal error: Cannot use object of type stdClass as array

It says that it is coming from this line:

$month = date('n', strtotime($valuesAry['dates']));

twistedindustries · May 10, 2011

Aha! The line in question needed to look like this:

$month = date('n', strtotime($valuesAry->dates));

I think I have it now! Thanks again for your help!

twistedindustries · May 10, 2011

Where are you getting these values from? If you are getting from a DB you should order the records appropriately there. Although, there is usually no need to physically group them in an array since you can handle that in the processing code.

But, if you really need to do this, the only way I can see to do it is to loop over each record and create a new array. Also, I would set the key for the "grouped" elements to the month number for ease of use.
$groupedArray = array();
foreach($originalArray as $key => $valuesAry)
{
    $month = date('n', strtotime($valuesAry['dates']));
    $groupedArray[$month][] = $valuesAry;
}
//$groupedArray now holds the data from $originalArray in a grouped format

Quick question, what if instead of using the month number as the key I just wanted to start the key at 0 and have it increase for each month?

twistedindustries · May 10, 2011

I wish this form had an edit button, I have worked through my issue and I came to the conclusion that you are right and that I should probably try and accomplish what I need directly from the database. The problem is I don't know how. Can someone post someecode to help me? Here is my query as it is:

SELECT a.id, a.id AS did, a.dates, a.enddates, a.shortdescription, a.max_attendance, a.times, a.endtimes, a.registra, a.unregistra, a.titel, a.locid, a.status,a.shw_attendees, l.club, l.url, l.street, l.plz, l.city, l.country, l.locdescription, c.catname, c.id AS catid FROM #__registrationpro_dates AS a LEFT JOIN #__registrationpro_locate AS l ON l.id = a.locid LEFT JOIN #__registrationpro_categories AS c ON c.id = a.catsid WHERE a.published = 1 AND c.access <= 0 ORDER BY c.ordering, a.dates, a.times

Psycho · May 10, 2011

Quick question, what if instead of using the month number as the key I just wanted to start the key at 0 and have it increase for each month?

That makes the problem more complex, because now you will need to keep track of which month belongs to which index. In your example above "2011-06-01" is the date for the first record so you would make index 0 to represent "May". Now, when you get to the 2nd record and it has a date of "2011-06-05" how would the code "know" that the index of 0 already exists and that is represents the month of May. You could do it, but it would require creating another array to keep track of the month/index association and additional logic to check of the month of the current record is already in that array or if you need to create one. So, yes it can be done, but you would be making much more complicated than it should be

$groupedArray = array();
$monthsArray = array();
foreach($originalArray as $key => $valuesAry)
{
    //Get month of current record
    $month = date('n', strtotime($valuesAry['dates']));
    //Check if month exists in index array
    if(!in_array($month, $monthsArray))
    {
        //Month does not exist in index array add it
        $monthsArray[] = $month;
    }
    //Get month index value for current month
    $monthIndex = array_search($month, $monthsArray));
    //Add record to new array under month index
    $groupedArray[$monthIndex][] = $valuesAry;
}

Psycho · May 10, 2011

I wish this form had an edit button, I have worked through my issue and I came to the conclusion that you are right and that I should probably try and accomplish what I need directly from the database. The problem is I don't know how. Can someone post someecode to help me? Here is my query as it is:
SELECT a.id, a.id AS did, a.dates, a.enddates, a.shortdescription, a.max_attendance, a.times, a.endtimes, a.registra, a.unregistra, a.titel, a.locid, a.status,a.shw_attendees, l.club, l.url, l.street, l.please, l.city, l.country, l.locdescription, c.catname, c.id AS catid FROM #__registrationpro_dates AS a LEFT JOIN #__registrationpro_locate AS l ON l.id = a.locid LEFT JOIN #__registrationpro_categories AS c ON c.id = a.catsid WHERE a.published = 1 AND c.access <= 0 ORDER BY c.ordering, a.dates, a.times 

There IS an edit button, but it is only available for about 20 minutes after making a post. I can help you, but the problem you need to resolve is NOT the actual query, but how you process the query. You already have an ORDER BY clause and I will assume it is in the correct order that you will present the values. Here is some rough code to show one way to display the records in a "grouped" format.

I only added the output for some of the fields since I am lazy.

<?php

//Run query to get records returned in proper order
$query = "SELECT a.id, a.id AS did, a.dates, a.enddates, a.shortdescription, a.max_attendance,
                 a.times, a.endtimes, a.registra, a.unregistra, a.titel, a.locid, a.status, a.shw_attendees,
                 l.club, l.url, l.street, l.please, l.city, l.country, l.locdescription,
                 c.catname, c.id AS catid
                 FROM #__registrationpro_dates AS a
                 LEFT JOIN #__registrationpro_locate AS l
                     ON l.id = a.locid
                 LEFT JOIN #__registrationpro_categories AS c
                     ON c.id = a.catsid
                 WHERE a.published = 1
                   AND c.access <= 0
                 ORDER BY c.ordering, a.dates, a.times ";
$result = mysql_query($query) or die(mysql_error());

//Create output for the records grouped by month/year
$output = ''; //Variable to store HTML output
$currentMonthYear = false; //Flag to detect when month/year changes between records
while($row = mysql_fetch_assoc($result))
{
    //Get MM-YYYY value for current record
    $thisMonthYear = date('F-Y', $row['dates']);

    //If this Month/Year different than current Month/Year create new header
    if($currentMonthYear != $thisMonthYear)
    {
        $currentMonthYear = $thisMonthYear;
        $output .= "<tr><th colspan=''><h1>Records for {$currentMonthYear}</h1><th></tr>\n";
        $output .= "<tr>\n";
        $output .= "<tr><th>Description</th></tr>\n";
        $output .= "<tr><th>Max Attendance</th></tr>\n";
        $output .= "<tr><th>Times</th></tr>\n";
        $output .= "<tr><th>End Times</th></tr>\n";
        $output .= "<tr><th>Club</th></tr>\n";
        $output .= "<tr><th>City</th></tr>\n";
        $output .= "<tr><th>Country</th></tr>\n";
        $output .= "<tr><th>Description</th></tr>\n";
        $output .= "</tr>\n";
    }

    //Display current record
    $output .= "<tr>\n";
    $output .= "<td>{$row['shortdescription']}</td>\n";
    $output .= "<td>{$row['max_attendance']}</td>\n";
    $output .= "<td>{$row['times']}</td>\n";
    $output .= "<td>{$row['endtimes']}</td>\n";
    $output .= "<td>{$row['club']}</td>\n";
    $output .= "<td>{$row['city']}</td>\n";
    $output .= "<td>{$row['country']}</td>\n";
    $output .= "<td>{$row['locdescription']}</td>\n";
    $output .= "</tr>\n";
}

?>
<table>
    <?php echo $output; ?>
</table>

Sign In

PHP Array group by month

Recommended Posts

twistedindustries

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

twistedindustries

Link to comment

Share on other sites

twistedindustries

Link to comment

Share on other sites

twistedindustries

Link to comment

Share on other sites

twistedindustries

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information