Multi dimensional array from MySQL query

Question

I'm trying to create multidimensional array with start_date and end_date values

$array = [];
$i = 0;

while ($row = mysqli_fetch_assoc($result)) {
    $array[$i]['start_date'] = $row['current_status_start_time'];
    $array[$i]['end_date'] = '';
    $i++;
}
print_r($array);

This returns me array like this:

  Array ( 
    [0] => Array (
         [start_date] => 2013-07-25 11:18:42
         [end_date] => )
    [1] => Array (
         [start_date] => 2013-07-26 05:24:08
         [end_date] => )
    [2] => Array ( 
         [start_date] => 2013-07-31 17:25:05
         [end_date] => )
 )

end_date should get next array [start_date] node value:

        Array ( 
    [0] => Array (
         [start_date] => 2013-07-25 11:18:42
         [end_date] =>   **2013-07-26 05:24:08**)
    [1] => Array (
         [start_date] => **2013-07-26 05:24:08**
         [end_date] =>   2013-07-31 17:25:05)
    [2] => Array ( 
         [start_date] => 2013-07-31 17:25:05
         [end_date] => current_date)
 )

As you can see in the last code example, array[0][end_date] should get array[1][start_date] value and so on, the last array end_date should get current time value, because there is end of array.

Should I use second loop to achieve that? or there is alternative and more simple way?

Orangepill · Accepted Answer · 2013-07-25 13:24:57Z

2

This should get you what you want:

$array = [];
$i = 0;

while ($row = mysqli_fetch_assoc($result)) {
    $array[$i]['start_date'] = $row['current_status_start_time'];
    $array[$i]['end_date'] = '';
    if ($i > 0){
        // if we are pass the first item set the previous item to the current start date
        $array[$i-1]["end_date"] = $array[$i]['start_date'];
    }
    $i++;
}
// fill in the last end_date with the current_date
$array[$i]["end_date"] = date("Y-m-d H:i:s");
print_r($array);

edited Jul 25, 2013 at 13:24

answered Jul 25, 2013 at 13:14

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

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

Comments

denvdancsk · Accepted Answer · 2013-07-25 13:25:33Z

1

I would go with a loop. Something like this:

foreach($mainArray as $key => $value)
{
    $next = $key + 1;

    if(!is_null($mainArray[$next]['start_date']))
    {
        $mainArray[$key]['end_date'] = $mainArray[$next]['start_date'];
    }
    else
    {
        $mainArray[$key]['end_date'] = current_date;
    }
}

print_r($main_array);

answered Jul 25, 2013 at 13:25

denvdancsk

3,0532 gold badges28 silver badges42 bronze badges

Collectives™ on Stack Overflow

Multi dimensional array from MySQL query

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