Hola,
Tengo un archivo que muestra un mapa horizontal simple en base a unos valores fijos (
$data[0]['value']). Quisiera generar esos valores de forma automática y consultar cómo podría introducir la variable $COUNT sustituyendo los valores fijos. He probado
Código PHP:
$data[0]['value']=$COUNT;
y no funciona.
Código PHP:
<?php
require_once('chart.php');
include('ddbb_conection.php');
$link = conectar();
$res11 = mysql_query("SELECT COUNT(URL) FROM PLD_LINK WHERE STATUS=2") or die (mysql_error());
$data = array();
$tableSize = 300;
/**************** F I L L D A T A A R R A Y *******************************/
$data[0]['title'] = 'PR10';
$data[0]['value'] = 1;
$data[1]['title'] = 'PR9';
$data[1]['value'] = 2;
$data[2]['title'] = 'PR8';
$data[2]['value'] = 6;
$data[3]['title'] = 'PR7';
$data[3]['value'] = 8;
$data[4]['title'] = 'PR6';
$data[4]['value'] = 14;
$data[5]['title'] = 'PR5';
$data[5]['value'] = 59;
$data[6]['title'] = 'PR4';
$data[6]['value'] = 111;
$data[7]['title'] = 'PR3';
$data[7]['value'] = 194;
$data[8]['title'] = 'PR2';
$data[8]['value'] = 203;
$data[9]['title'] = 'PR1';
$data[9]['value'] = 113;
$data[10]['title'] = 'PR0';
$data[10]['value'] = 576;
/******************************************************************************/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Micro Bar Chart</title>
<link href="style/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="main">
<div id="result">
<?php drawChart($data); ?>
</div>
<div id="result">
<?if (mysql_num_rows($res11) > 0) {//si hay resultados.
while(list($COUNT) = mysql_fetch_array($res11)){?>
<tr><td>Total URLs:</td><td><? echo $COUNT;?></td></tr>
<?}//fin del while
}else{
//no hay resultados?>
<tr><td colspan="3" align="left">No hay datos</td></tr>
<?}//fin del if/else de resultados
?>
</div>
</div>
</body>