PHP data formation with array with some existing value

Question

Suppose I have some value like this

Array
(
    [0] => stdClass Object
        (
            [amount] => 4000.00
            [monthyear] => 2018-02
        )

    [1] => stdClass Object
        (
            [amount] => 5000.00
            [monthyear] => 2018-01
        )
)

I want to generate some value like this

[5000,4000,0,0,0,0,0,0,0,0,0,0]

I used foreach loop and for loop but I can't understand how to do this, it's actually generating a sum of balance report by month.

Is it possible to generate this value via CodeIgniter?

My query for the above output is:

$this->cm->select_sum = "amount";
$this->cm->select = "DATE_FORMAT(date,'%Y-%m') as monthyear";
$this->cm->table_name = "personal_balance";
$this->cm->where = array("DATE_FORMAT(date,'%Y')" => date('Y'));
$this->cm->group_by = "DATE_FORMAT(date,'%m')";
$balance = $this->cm->get();

First you need to be able to successfully create a new array [5000, 4000] by iterating over the existing. Then you can use array_pad() to extend the new array with '0's to the desired length. — marekful
– marekful, Commented Jan 25, 2018 at 21:47
The report will be month based . this is not important to placed the values at the very first . those values can be anywhere . — Arif Sajal
– Arif Sajal, Commented Jan 25, 2018 at 23:27

Eiji · Accepted Answer · 2018-01-26 07:41:47Z

1

Something like that do the job I guess.

$monthBalance = [];
foreach($balance as $entry){
    $month = intval(substr($entry['monthyear']),6,7));
    $monthBalance[$month] = $entry;
}
//so there is [1=>obj(), 2=>obj(), 5=>obj] in it


$value = [];
for($m = 1; $m <= 12; $m++) {

    //if the balance month currently exists in the DB results
    if( isset($monthBalance[$m]) ){

       $value[] = $monthBalance[$m]->amount;

    } else {

       $value[] = 0;

    }
}

edited Jan 26, 2018 at 7:41

answered Jan 26, 2018 at 2:19

Eiji

4536 silver badges15 bronze badges

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

2 Comments

Arif Sajal Over a year ago

this not gonna work, cause if there was 3 value for month 1,2 and 5 the output for this code will be [1,2,5,0,0,0,0,0,0,0,0,0], But i need to get output like this [1,2,0,0,5,0,0,0,0,0,0,0,], Hope You Understand.

Eiji Over a year ago

Oh, okey, I try to fixe it ^^

Collectives™ on Stack Overflow

PHP data formation with array with some existing value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related