Dynamically Populate Graph 1

[likelylad]

I am trying to dynamically produce a graph (using jp graph) from a database.

Getting the information from the database is not the problem.

This is where I am at the moment

//This line simulates info from the database
$xaxis="0,0,0,0,0,0,0,0,0,839,762,769,690,530,517,450,297,9,0,0,0,0,0,0";

//To work properly this is how it must appear
//$data1y=array(0,0,0,0,0,0,0,0,0,839,762,769,690,530,517,450,297,9,0,0,0,0,0,0);

$test="array(".$xaxis.");";
eval("\$test = \"$test\";");
$data1y=$test;

I am getting the following message on screen

array(0,0,0,0,0,0,0,0,0,839,762,769,690,530,517,450,297,9,0,0,0,0,0,0);JpGraph Error Either X or Y data arrays contains non-numeric values. Check that the data is really specified as numeric data and not as strings. It is an error to specify data for example as '-2345.2' (using quotes).

Thanking in advance for any help received

 

[jpadie]

i don't think you are using eval right.

try this instead:

//This line simulates info from the database
$xaxis="0,0,0,0,0,0,0,0,0,839,762,769,690,530,517,450,297,9,0,0,0,0,0,0";

//To work properly this is how it must appear
//$data1y=array(0,0,0,0,0,0,0,0,0,839,762,769,690,530,517,450,297,9,0,0,0,0,0,0);
eval('$data1y=array('.$xaxis.');');
print_r($data1y);

 

[likelylad]

Thats worked, thanks.

Believe it or not I had tried this as well but used double quotes instead and it didn't work.

For other peoples reference you don't need the "print_r($data1y);" part for the array to work in the graph.

 

[jpadie]

no worries.

 

[jpadie]

sorry. that was lazy of me. I'd made an assumption that you actively wanted to use eval().

you, of course, should not be using eval for this. there are better/neater ways of doing so.

ideally the array would be build directly from the database, but if for some reason you have the entire string in a single column, you should instead use this code:

$xaxis="0,0,0,0,0,0,0,0,0,839,762,769,690,530,517,450,297,9,0,0,0,0,0,0";
$data1y = explode(',',$xaxis);