[RESOLVED] array format - phplot

[jeepin81]

Hello,

I am using phplot to create a graphical chart but I am having issues formatting my array correctly. Right now my array looks like:

Array
(
    [0] => Array
        (
            [0] => 20100104,
            [1] => 3775,
            [2] => 661,
            [3] => 953,
            [4] => 0,
            [5] => 0,
            [6] => 0,
            [7] => 1635,
        )

[1] => Array
    (
        [0] => 20100104,
        [1] => 3775,
        [2] => 661,
        [3] => 953,
        [4] => 0,
        [5] => 0,
        [6] => 0,
        [7] => 1635,
    )

[2] => Array
    (
        [0] => 20100104,
        [1] => 3775,
        [2] => 661,
        [3] => 953,
        [4] => 0,
        [5] => 0,
        [6] => 0,
        [7] => 1635,
    )
etc, etc....

I need to get it into this format:

$example_data = array(
			    array('jan',3,4,2, 1),
			    array('march',5,3,9, 8),
			    array('april',7,2,6, 3),
			    array('may',8,1,4, 5),
			    array('june',2,4,6, 1),
			    array('july',6,4,5, 8),
			    array('aug',7,2,3, 4)
				);

Instead of the actual text for the month in my array I am using a date. My data is stored in a db like the following:

PROD  |  COUNT  |  DATE
-------------------------------
ABC    |  1234     | 20130101
-------------------------------
XYZ    |  4321     | 20130101
-------------------------------
ABC    |  6789     | 20130102
-------------------------------
XYZ    |  9876     | 20130102

Seems like this would be easy enough to query correctly out of the DB but I am not having any luck.

any insight would be appreciated....

Thanks,
j

[Weedpacket]

It probably is doable, but without any clue about how what you want is related to what you have (beyond possibly wanting to group by the month part of the date)...

[dalecosp]

Where's the PHP that's creating the array?

[jeepin81]

Thanks for the responses... Below is the code to create my array.... it's kind of ugly :bemused: I first call the function to get the dates and use array_unique() to get an unique array of dates. Then loop through the dates array to get the counts. [0] is the date - [1]-[7] are my counts.

The returned results appear as:

Array
(
    [0] => Array
        (
            [0] => 20100104,
            [1] => 3775,
            [2] => 661,
            [3] => 953,
            [4] => 0,
            [5] => 0,
            [6] => 0,
            [7] => 1635,
        )

[1] => Array
    (
        [0] => 20100201,
        [1] => 4326,
        [2] => 1452,
        [3] => 2177,
        [4] => 0,
        [5] => 0,
        [6] => 0,
        [7] => 2902,
    )

[2] => Array
    (
        [0] => 20100301,
        [1] => 5193,
        [2] => 1610,
        [3] => 1840,
        [4] => 0,
        [5] => 0,
        [6] => 0,
        [7] => 2820,
    )
etc,etc..
);

and I am trying to re-format the array to look like

$example_data = array(
			    array('20100104', 3775, 661, 953, 0, 0, 0, 1635),
			    array('20100201', 4326, 1452, 2177, 0, 0, 0, 2902),
			    array('20100301', 5193, 1610, 1840, 0, 0, 0, 2820),
			    etc,
			    etc,
			    ..
				);

$allDatesPre = getDates($conn);
$allDates = array_unique($allDatesPre);
$data = array();

foreach($allDates as $d){

//query db to get site hits
$sql = "SELECT wdate,whits FROM internet.ws_xxx WHERE wdate = '".db2_escape_string($d)."'";
$res = db2_exec($conn,$sql) or die(db2_stmt_errormsg());

$m[] = $d.',';
while($row = db2_fetch_assoc($res)){

	$m[] .= trim($row['WHITS']).',';	
}	

$data[] = $m;	


unset($m);

}

echo '<pre>'.print_r($data,1).'</pre>';


//----------------------------------------------
//function to get all dates
//----------------------------------------------
function getDates($conn){
	$sql = "SELECT wdate FROM internet.ws_xxx";
	$res = db2_exec($conn,$sql);

$dates = array();
while($row = db2_fetch_assoc($res)){
	$dates[] = trim($row['WDATE']);
}

return $dates;

//end function getDates();	
}

Again, I appreciate the help. Let me know if I need to supply more info. I apologize for being to vague in my prior post.

[jeepin81]

reading over phplot documentation I was able to use this array format:

foreach($allDates as $d){
	$sql = "SELECT wdate,whits FROM internet.xxx WHERE WDATE = '".db2_escape_string($d)."'";
	$res = db2_exec($conn,$sql) or die(db2_stmt_errormsg());

while($row = db2_fetch_assoc($res)){

		if(trim($row['WSITE']) == 'XXXX'){
			$XXXX = trim($row['WHITS']);
		}
		if(trim($row['WSITE']) == 'SXXXX'){
			$sXXXX = trim($row['WHITS']);
		}
		if(trim($row['WSITE']) == 'CXXXX'){
			$cXXXX = trim($row['WHITS']);
		}
		if(trim($row['WSITE']) == 'CXXXX'){
			$cXXXX = trim($row['WHITS']);
		}
		if(trim($row['WSITE']) == 'CXXXX'){
			$cXXXX = trim($row['WHITS']);
		}
		if(trim($row['WSITE']) == 'AXXXX'){
			$aXXXX = trim($row['WHITS']);
		}
		if(trim($row['WSITE']) == 'OXXXX'){
			$oXXXX = trim($row['WHITS']);
		}

}


$data[] = array($d, $jds, $sport, $corp, $cry, $color, $acrylic, $oe);

}

and that worked. That other format was a bit confusing for me.

I will mark resolved.