php find two array values in result multidimensional array

Question

I am looking for last three month state wise data.I have all state code array and last three month array with the following values,

$stateArray = array("Nj","va","Ca","BS","TS");
$MonthArray =array("Nov 2016","Dec 2016","Jan 2017");

Below is my result array fetch from the database,

and so on for all states.

I am trying to array array_search() and in_array() functions for each but it is not working.What I would like to accomplish to loop each state wise array.Below I am trying for looping,

foreach ( $result_array as $val ) {
    $month = array_search ( $val ['month'], $monthArray );
    $state = array_search ( $val ['state'], $stateArray );
    if ($val ['count'] == '' || $val ['count'] == 'NULL') {
        $countValue = 0;
    } else {
        $countValue = $val ['count'];
    }
    $final_array [] = $countValue;
}

All such patterns are not valid php: $val ['month']. Remove the blank character between variable name and brackets. — arkascha
– arkascha, Commented Feb 28, 2017 at 8:21
ok,I removed this blank space but expected result not getting. — bdevloper
– bdevloper, Commented Feb 28, 2017 at 8:27

arkascha · Accepted Answer · 2017-02-28 08:45:10Z

1

Take a look at this simple example:

<?php
$input = [
    [
        'month' => "Nov 2016",
        'count' => "150",
        'state' => "NJ"
    ],
    [
        'month' => "Nov 2016",
        'count' => "100",
        'state' => "va"
    ],
    [
        'month' => "Dec 2016",
        'count' => "270",
        'state' => "NJ"
    ],
];
$output = [];
foreach (["Nj", "va", "Ca", "BS", "TS"] as $state) {
    $output[strtoupper($state)] = [];
};

array_walk($input, function($entry) use (&$output) {
    $output[strtoupper($entry['state'])][] = [
        'month' => $entry['month'],
        'count' => $entry['count']
    ];
});

print_r($output);

The result of the above code is:

Array
(
    [NJ] => Array
        (
            [0] => Array
                (
                    [month] => Nov 2016
                    [count] => 150
                )

            [1] => Array
                (
                    [month] => Dec 2016
                    [count] => 270
                )

        )

    [VA] => Array
        (
            [0] => Array
                (
                    [month] => Nov 2016
                    [count] => 100
                )

        )

    [CA] => Array
        (
        )

    [BS] => Array
        (
        )

    [TS] => Array
        (
        )

)

This appears to be the exact output structure you ask for.

edited Feb 28, 2017 at 8:45

answered Feb 28, 2017 at 8:27

arkascha

43.2k8 gold badges61 silver badges97 bronze badges

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

8 Comments

bdevloper Over a year ago

We have set of state and moth.We have to loop each state with each month set.

arkascha Over a year ago

@bhagwanpawar Sure, I understood that from your question. That example does loop all entries in your given result set. Do you want to say that your result set does not contain entries for all combinations of state and month? So you have incomplete data?

bdevloper Over a year ago

We want to append zero result set those are not in resultant array

bdevloper Over a year ago

yes arkascha, In result set does not contain entries for all combinations.We are not getting data for all month and state.Those month and state data not getting we set zero result set.

arkascha Over a year ago

@bhagwanpawar Just add those emty default entries in your resulting array as shown in the updated answer...

|

Андрей Танечник · Accepted Answer · 2017-02-28 09:20:55Z

       $stateArray = array("Nj","va","Ca","BS","TS");
    $MonthArray =array("Nov 2016","Dec 2016","Jan 2017");
    $fromDB =    Array (
        Array (
            'month' => 'Nov 2016',
            'count' => 150,
            'state' => 'NJ'
            ),
        Array (
            'month' => 'Nov 2016',
            'count' => 100,
            'state' => 'va'
            )
        );
    $info = array();
    foreach ($fromDB as $row){
        $info[strtoupper($row['state'])][$row['month']] = $row['count'];
    }
    $result = array();
    foreach ($stateArray as $state){
        foreach ($MonthArray as $month){
            $result[$state][]=array('month'=>$month, 'count'=>isset($info[strtoupper($state)][$month])?$info[strtoupper($state)][$month]:0);
        }
    }
print_r($result);

will output

Thanks Андрей Танечник,This is what I want.Thanku u very much

Collectives™ on Stack Overflow

php find two array values in result multidimensional array

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related