PHP Language - jpgraph??

Author

jpgraph??

Ron Eggler

2004-12-21, 3:55 am

Hallo,

kennt sich jemand mit der Diagramm-Library jpgraph aus?
Ich versuche Werte in ein Diagramm zu schreiben, welche ich aus einer
mysql-DB auslese im Diagramm auf http://www.rideon.ch/php/schnee.php (ein
Ort auswählen und "Zeigen" klicken) wird aber nur die eine Kurve mit den
fixen ($ydata2 = array(1,19,15,7,22,14,5,9,21,13);) Werten angezeigt,
wesshalb?
[Code Chart.php]
<?php
// Code that uses the jpgraph library
include ( '../jpgraph/src/jpgraph.php');
include ('../jpgraph/src/jpgraph_line.php');

/* Datenbankserver - In der Regel die IP */
$db_server = "localhost";
/* Datenbankname */
$db_name = "usr_web2_1 ";
/* Datenbankuser */
$db_user = "web2";
/* Datenbankpasswort */
$db_passwort = "5thelement";

/* Erstellt Connect zu Datenbank her */
$db = @MYSQL_CONNECT($db_server,$db_user,$db_p
asswort) or die ();
$db_check = @MYSQL_SELECT_DB($db_name);
if($db)
{
$sqlwhere="WHERE location=\"$location\"";
$result = mysql_query("SELECT * FROM schnee $sqlwhere ORDER BY location,
date DESC");
while ($row = mysql_fetch_array ($result))
{
$ydata[$i]=$row[snowheight];
$i++; //zählvariable inkrementieren
}
//********** DIGRAMM ************
//$ydata = array(11,3,8,12,5,1,9,13,5,50);
$ydata2 = array(1,19,15,7,22,14,5,9,21,13);

// Create the graph. These two calls are always required
$graph = new Graph(500,400,"auto");
$graph->SetScale("textlin");

// Create the linear plot
$lineplot=new LinePlot($ydata);

$lineplot2=new LinePlot($ydata2);

// Add the plot to the graph
$graph->Add($lineplot);
$graph->Add($lineplot2);

$graph->img->SetMargin(40,20,20,40);
$graph->title->Set("$location");
$graph->xaxis->title->Set("Datum [yyyy-mm-dd]");
$graph->yaxis->title->Set("Schneehöhe [cm]");

$graph->title->SetFont(FF_FONT1,FS_BOLD);
$graph->yaxis->title->SetFont(FF_FONT1,FS_BOLD);
$graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);

$lineplot->SetColor("blue");
$lineplot->SetWeight(2);

$lineplot2->SetColor("orange");
$lineplot2->SetWeight(2);

$graph->yaxis->SetColor("red");
$graph->yaxis->SetWeight(2);
$graph->SetShadow();

// Display the graph
$graph->Stroke();
}

?>
[/Code Chart.php]

Danke!

--
roN
www.rideon.ch

Ron Eggler @ Work

2004-12-21, 8:56 am

Ron Eggler wrote:
> Hallo,
>
> kennt sich jemand mit der Diagramm-Library jpgraph aus?
> Ich versuche Werte in ein Diagramm zu schreiben, welche ich aus einer
> mysql-DB auslese im Diagramm auf http://www.rideon.ch/php/schnee.php
> (ein Ort auswählen und "Zeigen" klicken) wird aber nur die eine Kurve
> mit den fixen ($ydata2 = array(1,19,15,7,22,14,5,9,21,13);) Werten
> angezeigt, wesshalb?
> [Code Chart.php]
> <?php
> // Code that uses the jpgraph library
> include ( '../jpgraph/src/jpgraph.php');
> include ('../jpgraph/src/jpgraph_line.php');
>
> /* Datenbankserver - In der Regel die IP */
> $db_server = "localhost";
> /* Datenbankname */
> $db_name = "usr_web2_1 ";
> /* Datenbankuser */
> $db_user = "web2";
> /* Datenbankpasswort */
> $db_passwort = "5thelement";
>
> /* Erstellt Connect zu Datenbank her */
> $db = @MYSQL_CONNECT($db_server,$db_user,$db_p
asswort) or die ();
> $db_check = @MYSQL_SELECT_DB($db_name);
> if($db)
> {
> $sqlwhere="WHERE location=\"$location\"";
> $result = mysql_query("SELECT * FROM schnee $sqlwhere ORDER BY
> location, date DESC");
> while ($row = mysql_fetch_array ($result))
> {
> $ydata[$i]=$row[snowheight];
> $i++; //zählvariable inkrementieren
> }
> //********** DIGRAMM ************
> //$ydata = array(11,3,8,12,5,1,9,13,5,50);
> $ydata2 = array(1,19,15,7,22,14,5,9,21,13);
>
> // Create the graph. These two calls are always required
> $graph = new Graph(500,400,"auto");
> $graph->SetScale("textlin");
>
> // Create the linear plot
> $lineplot=new LinePlot($ydata);
>
> $lineplot2=new LinePlot($ydata2);
>
> // Add the plot to the graph
> $graph->Add($lineplot);
> $graph->Add($lineplot2);
>
> $graph->img->SetMargin(40,20,20,40);
> $graph->title->Set("$location");
> $graph->xaxis->title->Set("Datum [yyyy-mm-dd]");
> $graph->yaxis->title->Set("Schneehöhe [cm]");
>
> $graph->title->SetFont(FF_FONT1,FS_BOLD);
> $graph->yaxis->title->SetFont(FF_FONT1,FS_BOLD);
> $graph->xaxis->title->SetFont(FF_FONT1,FS_BOLD);
>
> $lineplot->SetColor("blue");
> $lineplot->SetWeight(2);
>
> $lineplot2->SetColor("orange");
> $lineplot2->SetWeight(2);
>
> $graph->yaxis->SetColor("red");
> $graph->yaxis->SetWeight(2);
> $graph->SetShadow();
>
> // Display the graph
> $graph->Stroke();
> }
>
> [/Code Chart.php]
>
> Danke!

Okay, ich hab's... Danke trozdem! :)

Sponsored Links