How to save an array of dates read from mysql on php?

Question

I have the following code to save save the data as an array for the next year, $info is read from sql:

$saved = []
for ($x = 0; $x <= 365; $x++) {
    $d=strtotime("+$x days");
    $cd = date("Y-m-d", $d);
    foreach($info as $i){
        if($i['date'] == $cd){  
            $saved[$cd] = $i;
        }
    }
}

it works, but when I have many data with the same date it overrides it, how can I differentiate it without ruining the structure of

You need another dimension....

Murad Hasan
– Murad Hasan

2016-10-02 04:12:41 +00:00
Commented Oct 2, 2016 at 4:12 — Murad Hasan
– Murad Hasan, Commented Oct 2, 2016 at 4:12

Aschab · Accepted Answer · 2016-10-02 04:13:38Z

1

try this:

$saved = []
for ($x = 0; $x <= 365; $x++) {
    $d=strtotime("+$x days");
    $cd = date("Y-m-d", $d);
    foreach($info as $i){
        if($i['date'] == $cd){  
            $saved[$cd][] = $i;
        }
    }
}

that way $saved[$cd] is being pushed. That way $saved['2016-10-03'] will give you 1 result if there is only one, or an array of N if there are N results.

answered Oct 2, 2016 at 4:13

Aschab

1,3992 gold badges15 silver badges32 bronze badges

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

Comments

Jacob Paulozz · Accepted Answer · 2016-10-02 08:08:41Z

0

try this

$saved = array();
$dates = array();
// separate array, make array for dates
for ($x = 0; $x <= 365; $x++) {
  $d=strtotime("+$x days");
  $cd = date("Y-m-d", $d);
  $dates[$cd] = $cd;
}

foreach($info as $i){
  if(isset($dates[$i['date'])) {
        $saved[$i['date']][] = $i;
    }
}

answered Oct 2, 2016 at 8:08

Jacob Paulozz

1596 bronze badges

Collectives™ on Stack Overflow

How to save an array of dates read from mysql on php?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related