Hola amigooos! Tengo un problema, me instale la aplicación JPGraphic pero tengo 1 problema.
1 - No sé como simplificar esto:
Código PHP:
<?
$db_link = mysql_connect("localhost", "root", "admin");
mysql_select_db("meteolot", $db_link);
$data = 20081009;
//DADA1
$txt = 'taula'.$data.' where id=1';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada1 = $imprimir[temp];
}
//DADA2
$txt = 'taula'.$data.' where id=2';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada2 = $imprimir[temp];
}
//DADA3
$txt = 'taula'.$data.' where id=3';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada3 = $imprimir[temp];
}
//DADA4
$txt = 'taula'.$data.' where id=4';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada4 = $imprimir[temp];
}
//DADA5
$txt = 'taula'.$data.' where id=5';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada5 = $imprimir[temp];
}
//DADA6
$txt = 'taula'.$data.' where id=6';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada6 = $imprimir[temp];
}
//DADA7
$txt = 'taula'.$data.' where id=7';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada7 = $imprimir[temp];
}
//DADA8
$txt = 'taula'.$data.' where id=8';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada8 = $imprimir[temp];
}
...
//DADA77
$txt = 'taula'.$data.' where id=77';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada77 = $imprimir[temp];
}
//DADA78
$txt = 'taula'.$data.' where id=78';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada78 = $imprimir[temp];
}
//DADA79
$txt = 'taula'.$data.' where id=79';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada79 = $imprimir[temp];
}
//DADA80
$txt = 'taula'.$data.' where id=80';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada80 = $imprimir[temp];
}
//DADA81
$txt = 'taula'.$data.' where id=81';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada81 = $imprimir[temp];
}
//DADA82
$txt = 'taula'.$data.' where id=82';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada82 = $imprimir[temp];
}
//DADA83
$txt = 'taula'.$data.' where id=83';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada83 = $imprimir[temp];
}
//DADA84
$txt = 'taula'.$data.' where id=84';
$query = mysql_query("SELECT temp FROM $txt", $db_link) or die(mysql_error);
while($imprimir = mysql_fetch_array($query)){
$dada84= $imprimir[temp];
}
// Incluimos los archivos necesarios
include("src/jpgraph.php");
include("src/jpgraph_line.php");
// Creamos el array de datos
$ydata = array($dada84, $dada83, $dada82, $dada81, $dada80, $dada79, $dada78, $dada77, $dada76, $dada75,
$dada74, $dada73, $dada72, $dada71, $dada70, $dada69, $dada68, $dada67, $dada66, $dada65, $dada64, $dada63,
$dada62, $dada61, $dada60, $dada59, $dada58, $dada57, $dada56, $dada55, $dada54,
$dada53, $dada52, $dada51, $dada50, $dada49, $dada48, $dada47, $dada46, $dada45, $dada44, $dada43, $dada42, $dada41, $dada40, $dada39, $dada38, $dada37, $dada36, $dada35, $dada34, $dada33,
$dada32, $dada31, $dada30, $dada29, $dada28, $dada27, $dada26, $dada25, $dada24, $dada23, $dada22, $dada21, $dada20, $dada19, $dada18, $dada17, $dada16, $dada15, $dada14, $dada13, $dada12,
$dada11, $dada10, $dada9, $dada8, $dada7, $dada6, $dada5, $dada4, $dada3, $dada2, $dada1);
// Creamos un nuevo grafico de 350x250
$graph = new Graph(350, 250, "auto");
$graph->SetScale( "textlin");
// Creamos el grafico basado en el array
$a = $gDateLocale-> GetShortMonth();
$graph->xaxis-> SetTickLabels( $a);
$lineplot = new LinePlot($ydata);
$lineplot->SetColor("blue");
// Agregamos el grafico a la imagen
$graph->Add( $lineplot);
// Mostramos la imagen
$graph->Stroke();
?>