Include month if not there in php array

Question

I have an array like this in php

Array
(
    [0] => Array
        (
            [month] => April-2014
            [total_booking] => 2
        )

    [1] => Array
        (
            [month] => May-2014
            [total_booking] => 5
        )

    [2] => Array
        (
            [month] => June-2014
            [total_booking] => 25
        )

    [3] => Array
        (
            [month] => October-2013
            [total_booking] => 1
        )

    [4] => Array
        (
            [month] => July-2014
            [total_booking] => 4
        )

)

I have to make this array

if i selected two months from_month , to_month if there are no any months in this array it should be included eg:

i have selected from_month 2014 feb to_month 2014 may . but if in my array only 2014 feb, 2014 april,2014 may only so iwat to include 2014 march in correct place. like this

 Array
            (
                [month] => March-2014
                [total_booking] => 0
            )

this is my code

 foreach ($newarray as $month => total_booking) {
         //sorting 

      }



     foreach ($newarray as $month => total_booking) {
             //if there is no month in array betwean to_month and from_month it    

            should be  included in correct place as sorted

          }

You are asking how to sort it?

putvande
– putvande

2014-07-10 09:52:36 +00:00
Commented Jul 10, 2014 at 9:52 — putvande
– putvande, Commented Jul 10, 2014 at 9:52
@putvande no..,,,.....

Nisham Mahsin
– Nisham Mahsin

2014-07-10 10:03:58 +00:00
Commented Jul 10, 2014 at 10:03 — Nisham Mahsin
– Nisham Mahsin, Commented Jul 10, 2014 at 10:03

sumit · Accepted Answer · 2014-07-10 10:46:31Z

The best way is to take reference from the start date and end date you inputted and look it up in the master array..

Here it is(please scroll for answer)

$your_array=array
   (
     array
        (
            'month' => 'April-2014',
            'total_booking' => 2
        ),

    array
        (
            'month' => 'May-2014',
            'total_booking' => 5
        ),

    array
        (
            'month' => 'June-2014',
            'total_booking' => 25
        ),

    array
        (
            'month' => 'October-2013',
            'total_booking' => 1
        ),

    array
        (
            'month' => 'July-2014',
            'total_booking' => 4
        )

);
        $start_date="Jan 1 2013";
        $end_date="Dec 31 2014";
        $timestamp1=strtotime($start_date);
        $timestamp2=strtotime($end_date);
        for($i=$timestamp1;$i<$timestamp2;$i=$i+24*60*60){
            //echo $i;
            $gapmonth[]=date('F-Y',$i);
        }
        $gapmonth=array_unique($gapmonth);

        //convert $dataS(ORIGINAL ARRAY) to one dimentional array so the life will be easier
        foreach($your_array as $val){
            $derived_val[$val['month']]=$val['total_booking'];
        }

        foreach($gapmonth as $val){
            if(array_key_exists($val,$derived_val)){
                $total_booking=$derived_val[$val];
            }
            else{
                $total_booking=0;
            }
            $finaldate[]=array('month'=>$val,'total_booking'=>$total_booking);
        }
        echo "<pre>";
        print_r($finaldate);

OUTPUTS

I suggest you delete your array in the first codeblock and use a name like $your_array, I almost missed that you actually had code (I though you did it by hand;) )

Martijn · Accepted Answer · 2014-07-10 10:38:07Z

1

Loop through it and test if values are missing:

$prev_month = false;
foreach($your_array as $k=>$values){
    if($prev_month!==false){ // first itteration will be empty, dont do useless checks
        // Test if themonth after the previous month matches this one
        if( $prev_month+1 !== $values['month']  ){
            // FILL IN THE BLANKS
            // splice in at position $thisIndex (<- this you'll have to do)
            array_splice( $prev_month, $thisIndex-1, 0, $newDateBookingsArray); // -1, we want it before this item!
            // (dont forget to loop in case more than 1 items miss)
        }

    }
    $prev_month = $values['month']; // save value for next round
}

Edit: TS first asked to sort the array, the code to use a custom sort can be found in the edits of this post.

edited Jul 10, 2014 at 10:38

answered Jul 10, 2014 at 10:02

Martijn

16.2k4 gold badges39 silver badges73 bronze badges

4 Comments

Nisham Mahsin Over a year ago

actually this is not my requirment i want to include all months betwean this date as sorted. for eg: i have selected from_month 2014 feb to_month 2014 may . but if in my array only 2014 feb, 2014 april,2014 may only so iwat to include 2014 march in correct place

Martijn Over a year ago

You asked to "1. make this array sorted". The 2nd part of my answer answers part 2 of your question

Nisham Mahsin Over a year ago

that means i want to include as sorted. my mistake..my qn was confusing.. edited my qn

Martijn Over a year ago

I've editted my post. Included a method to add a value at the point you want, this way resroting isnt needed

Collectives™ on Stack Overflow

Include month if not there in php array

2 Answers 2

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related