Display data from PHP in jqplot chart

Question

i have simple php page with script where i fetch data from DB

$plot_row1 = array();
$plot_row2 = array();
$query1 = "SELECT date, name, value FROM list WHERE date between '$s_date' and '$e_date'      
ORDER BY date";

$result = $mysqli->query($query1);
    while ($row = $result->fetch_array(MYSQL_ASSOC))
{
    $sum_list = $sum_list + $row['value'];
    $plot_row1[] = $row['value'];
    $plot_row2[] = $row['date'];
}

Then I would like to have jqplot chart where X axis consists of dates from $plot_row2[] and Y axis contains values from $plot_row2[]

I started with the following code and what I need is to somehow prepared the values (in PHP) in the appropriate way to be used as an input for the jqplot (instead of the question marks).

echo "<div id='loggerChart1' style='height:400px;width:400px;'>";
echo "<script class='code' type='text/javascript' language='javascript'>";

echo "$.jqplot('loggerChart1',  [?????]);";
echo "</script>";
echo "</div>";

Thank you

And how would the prepared data look like? Comma separated strings/numbers? — djot
– djot, Commented Sep 22, 2013 at 22:25

djot · Accepted Answer · 2013-09-22 23:02:34Z

2

<?php

$prepared_array = ARRAY();

foreach ($plot_row1 AS $key => $value) {
  $prepared_array[] = '['.$plot_row2[$key].','.$value.']';
}
$prepared_string = '['.implode(',', $prepared_array).']';

var_dump($prepared_string);

?>

answered Sep 22, 2013 at 23:02

djot

2,9474 gold badges21 silver badges28 bronze badges

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

Comments

djot · Accepted Answer · 2013-09-22 22:28:45Z

1

x-axis values (you don't have JS code for anything else, so no y-axis, captions, etc.)

$prepared_x_values = '[['.implode(',', $plot_row2).']]';

answered Sep 22, 2013 at 22:28

djot

2,9474 gold badges21 silver badges28 bronze badges

2 Comments

Strimer_SK Over a year ago

Thank you, but I do not understands your statement about Y axis. I need the data looks like this: [[$plot_row2,$plot_row1],[$plot_row2,$plot_row1],...] continuously from the 2 arrays...

djot Over a year ago

Well, I had a "short" look on the jqPlot website... And the JS-Code there looks different for all charts I have seen.

Collectives™ on Stack Overflow

Display data from PHP in jqplot chart

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related