jpgraph and mysql passing array

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux