jpgraph and mysql passing array

Chris Stinemetz <chrisstinemetz@xxxxxxxxx> · Wed, 23 Mar 2011 15:59:50 -0500

Hello,

I hope you can help me. The Jpgraph forum seems to be pretty
uneventful with participation.

I am trying to pass arrays through the image tag to populate my
variables for my graph.

I keep getting an error that there is no input. Do you have any suggestions?

I would greatly appreciate it! I have been trying to figure this out
for several hours.

Below is my code:

I need some help with finding a solution. For some reason my graph is
not showing up when it evident that my arrays are being passed.

When I use:

echo "TEST DATA PRINT";

print_r($datay,false);

-------------------

I keep getting the error:

Empty input data array specified for plot.

-----------------------

My php script is as follows:

-----------------------

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>

<html xmlns="http://www.w3.org/1999/xhtml";>

<head>

<title>KCRF Dashboard</title>

<?php

ini_set('display_errors', 1);

error_reporting(E_ALL);

$term=$_POST['term'];

$term2=$_POST['term2'];

$term3=$_POST['term3'];

//include ('err_reporting.php');

require ('PHP_Scripts/config.php');

require_once ('jpgraph/jpgraph.php');

require_once ('jpgraph/jpgraph_line.php');

   $sql = ("SELECT * FROM evdobanding WHERE Market like '%$term' and
Cell_Sect = '$term2' and Date = '$term3' ORDER BY distance asc");

   $result = mysql_query($sql);

   while($row = mysql_fetch_array($result))

   {

   $datay[] = $row["MBusage"];

   $datax[] = $row["Distance"];

   }

  echo "TEST DATA PRINT";

  print_r($datay,false);

?>

<style type="text/css">

<!--

 #navbar ul {

        margin: 0;

        padding: 5px;

        list-style-type: none;

        text-align: center;

        background-color: #000;

        }

#navbar ul li {

        display: inline;

        }

#navbar ul li a {

        text-decoration: none;

        padding: .2em 1em;

        color: #fff;

        background-color: #000;

        }

#navbar ul li a:hover {

        color: #000;

        background-color: #fff;

        }

-->

</style>

</head>

<fieldset style="border: 1px ridge limegreen; color: limegreen;">
<legend style="color: #000; font-family: verdana; font-size:
14pt;">EVDO PCMD BANDING</legend> <body> <div id="navbar">

  <ul>

        <li><a href="index.php">Home</a></li>

        <li><a href="dd3.php">EVDO PCMD KPI</a></li>

        <li><a href="banding.php">EVDO Distance Banding</a></li>

        <li><a href="test.php">TEST_BANDING</a></li>

        <li><a href="">LinkHere</a></li>

  </ul>

</div>

</fieldset>

<?php

echo "You Selected the following:<br>Market = $term <br>Cell_Sector =
$term2<br>Timestamp = $term3<br>"; ?>

<img src="bandingGraph.php?$datax=$row["Distance"]&$datay=$row["MBusage"];">
// I think this is where I am having issues.

</body>

</html>

---------------------------

My graph script is:

<?php // content="text/plain; charset=utf-8"

require_once ('jpgraph/jpgraph.php');

require_once ('jpgraph/jpgraph_line.php');

   // Create the graph.

   $graph = new Graph(1024,450,"auto");

   $graph->SetScale("textlin");

   $graph->SetShadow();

   // Slightly adjust the legend from it's default position

   $graph->legend->Pos(0.03,0.5,"right","center");

   $graph->legend->SetFont(FF_FONT1,FS_BOLD);

   //Setup X-scale

     $graph->xaxis->SetTextTickInterval(10);

     $graph->xaxis->SetTickLabels($datax);

     //$graph->xtick_factor = 1;

    $graph->xaxis->SetLabelAngle(30);

   // Create the linear plot

   $lineplot= new LinePlot($datay);

   $p1 = new LinePlot($datay);

   $p1->mark->SetType(MARK_DIAMOND);

   $p1->mark->SetFillColor("blue");

   $p1->mark->SetWidth(;

   $p1->SetColor("blue");

   $p1->SetCenter();

   $p1->SetLegend("EVDO F1 Carrier");

   $graph->Add($p1);

   // Add the plot to the graph

   $graph->Add($lineplot);

   // Setup margin and titles

   $graph->img->SetMargin(40,40,50,60);

   $graph->title->SetMargin(10);

   $graph->title->Set("Distance in MIles");

   $graph->title->SetFont(FF_VERDANA,FS_BOLD,12);

   // set margin color

   $graph->SetMarginColor('#dcfade');

   // Use built in font

   $graph->title->SetFont(FF_ARIAL,FS_NORMAL,14);

   $graph->ygrid->SetFill(true,'#EFEFEF@xxx','#e5e5e5@xxx');

   $graph->xgrid->Show();

   $graph->SetBackgroundImageMix(15);

   $graph->legend->Pos(0.02,0.03,"right","top");

   $graph->legend->SetFont(FF_FONT1,FS_BOLD);

   $graph->xaxis->title->Set("Miles");

   $graph->yaxis->title->Set("MBusage");

   $graph->SetAlphaBlending();

   // Display the graph

   $graph->Stroke();

?>

Thank you,

Chris

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php