Dynamic creation of a multidimensional array in php

Question

I am fetching for some values from the database, and i need to dynamicaly create a multidimensional array to look like this:

$found_data = 
array( 
    array('2011-11-02' => 'Mobile'),
    array('2011-11-02' => 'Mobile'),
    array('2011-11-04' => 'Mobile'),
    array('2011-11-08' => 'Desktop'),
    array('2011-11-08' => 'Mobile'),
    array('2011-11-08' => 'Mobile'),
    array('2011-11-08' => 'Mobile'),
    array('2011-11-15' => 'Mobile'),
    array('2011-11-18' => 'Mobile'),
    array('2011-11-21' => 'Desktop'),
    array('2011-11-23' => 'Mobile'),
    array('2011-11-28' => 'Desktop'),
    array('2011-11-30' => 'Mobile')
);

I am thinking something in the lines of:

$found_data = array();

while($last_30_days_fetch = mysql_fetch_assoc($last_30_days_result))
{
    $hit_date = $last_30_days_fetch['hit_date'];
    $hit_device = $last_30_days_fetch['hit_device'];    
    array_push($found_data, array($clean_date=>$hit_device));

}

However the above code, does not work as intended. Any ideas?

// Thanks

ThW · Accepted Answer · 2013-11-25 19:07:27Z

1

You are using a variable $clean_date that is not defined. Check your error_reporting level it should report this (undefined variable).

PHP allows the use of the [] syntax to append elements to an array.

$found_data = array();

while($last_30_days_fetch = mysql_fetch_assoc($last_30_days_result))
{
    $found_data[] = array(
        $last_30_days_fetch['hit_date'] => $last_30_days_fetch['hit_device']
    );
}

answered Nov 25, 2013 at 19:07

ThW

19.5k3 gold badges25 silver badges47 bronze badges

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

Comments

Dave · Accepted Answer · 2013-11-25 19:05:56Z

0

$found_data = array();

while($last_30_days_fetch = mysql_fetch_assoc($last_30_days_result))
{
    $found_data[] = array($last_30_days_fetch['hit_date']=>$last_30_days_fetch['hit_device']);
}

why over complicate it or as Dan says put it into a single array there's no need for a multi array unless there's additional data you're not telling us about

answered Nov 25, 2013 at 19:05

Dave

3,2882 gold badges25 silver badges40 bronze badges

Comments

Dan Walker · Accepted Answer · 2013-11-25 19:05:36Z

0

Could you not just use:

$array[$hit_date] = $hit_device

answered Nov 25, 2013 at 19:05

Dan Walker

4741 gold badge6 silver badges16 bronze badges

1 Comment

Hans Preutz Over a year ago

i could not, since i needed the data packed in an array: $found_data.

Collectives™ on Stack Overflow

Dynamic creation of a multidimensional array in php

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related