im doing a stat here is the code,how can I make it day by day output?the only output of this code is for only on the day I selected the date on the select tool bar ...thanks
kheikhei
0
Newbie Poster
The attachment preview is chopped off after the first 10 KB. Please download the entire file.
<?php
$buscar = chop($_GET["buscar"]);
$buscar_donde = chop($_GET["buscar_donde"]);
$d1 = chop($_GET["d1"]);
$d2 = chop($_GET["d2"]);
$m1 = chop($_GET["m1"]);
$m2 = chop($_GET["m2"]);
$a1 = chop($_GET["a1"]);
$a2 = chop($_GET["a2"]);
$fecha_aux = explode("-",date("Y-m-d"));
if ($d1 == '')
{
$d1 = '01';
}
if ($m1 == '')
{
$m1 = $fecha_aux[1];
}
if ($a1 == '')
{
$a1 = $fecha_aux[0];
}
if ($d2 == '')
{
$d2 = $fecha_aux[2];
}
if ($m2 == '')
{
$m2 = $fecha_aux[1];
}
if ($a2 == '')
{
$a2 = $fecha_aux[0];
}
$hora_1 = " 00:00:00";
$hora_2 = " 23:59:59";
$fecha_1 = $a1."/".$m1."/".$d1.$hora_1;
$fecha_2 = $a2."/".$m2."/".$d2.$hora_2;
$fecha_1_inv = $d1."/".$m1."/".$a1.$hora_1;
$fecha_2_inv = $d2."/".$m2."/".$a2.$hora_2;
$timestamp1 = mktime(0,0,0,$m1,$d1,$a1);
$timestamp2 = mktime(4,12,0,$m2,$d2,$a2);
$segundos_diferencia = $timestamp1 - $timestamp2;
$dias_diferencia = $segundos_diferencia / (60 * 60 * 24);
$dias_diferencia = abs($dias_diferencia);
$partes_dias=explode(".",$dias_diferencia);
if ($partes_dias[1]!==0)
{$mas = 1;}
else
{$mas = 0;}
$dias_diferencia = floor($dias_diferencia) + $mas;
$diaInicio=$d1;
$mesInicio=$m1;
$aoInicio=$a1;
$fechaInicial = strftime ("%j",mktime(0,0,0,$mesInicio,$diaInicio,$aoInicio));
$diaFinal=$d2;
$mesFinal=$m2;
$aoFinal=$a2;
$fechaFinal = strftime("%j",mktime(0,0,0,$mesFinal,$diaFinal,$aoFinal));
for($i=0;$i<=$fechaFinal-$fechaInicial;$i++)
{
$fecha_prueba[$i] = strftime("%d-%m-%Y",mktime(0,0,0,$mesInicio,$diaInicio+$i,$aoInicio));
$fecha_prueba_inv[$i] = strftime("%Y-%m-%d",mktime(0,0,0,$mesInicio,$diaInicio+$i,$aoInicio));
}
$BBDD = ConectarAbbdd($cbd); //conection to the data base
?>
<?php boxtitulo_titulo("<a class=\"navegacionVertical\" href=\"\" onClick=\"blocking('nx_1'); return false\" >Wap Site Stats</a>"); ?>
<?php boxtitulo_centroIzq(); ?>
<div align="center">
<form action="index.php">
<table border="0" align="center">
<tr>
<td colspan="4" align="center"><font color="<? echo COLOR_texto_TABLA; ?>"><b>Select your dates:</b></font></td>
</tr>
<tr>
<td>Start date:</td>
<td><select name="d1" title="d1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
</td>
<td><select name="m1" title="m1">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
</td>
<td><select name="a1" title="a1">
<option value="2008" selected="selected">2008</option>
<option value="2009" >2009</option>
</select>
</td>
</tr>
<tr>
<td height="30">End date:</td>
<td>
<select name="d2" title="d2">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
</td>
<td>
<select name="m2" title="m2">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
</td>
<td>
<select name="a2" title="a2">
<option value="2008" selected="selected">2008</option>
<option value="2009">2009</option>
</select>
</td>
</tr>
<tr align="center">
<td colspan="4" align="center">
<input type="submit" value="Send" />
<input type="hidden" value="<? echo $buscar_donde;?>" name="buscar_donde"/>
<input type="hidden" value="<? echo $buscar;?>" name="buscar"/>
</td>
</tr>
</table>
</form>
</div>
<?php box_centroDer(); ?>
<?php box_footer(); ?>
<?php boxtitulo_titulo("WAP Stats"); ?>
<?php boxtitulo_centroIzq(); ?>
<div align="center">
<table width="833" border="2" align="center" cellpadding="0" cellspacing="0" frame="1" >
<tr bgcolor="#1E90FF">
<th width="77" align="center">Date</th>
<th width="59" align="center">Hits</th>
<th width="63" align="center">PolyTones</th>
<th width="71" align="center">True Tones</th>
<th width="71" align="center">Images</th>
<th width="76" align="center">Games</th>
<th width="77" align="center">Videos</th>
<th width="83" align="center">Game Rentals</th>
<th width="117" align="center">Conversion Rate(%)</th>
<th width="115" align="center">Total Downloads</th>
</tr>
<?php
//Access information
$sql_datos_accesos = "SELECT count(id) AS numAccesos FROM estadisticas WHERE fecha BETWEEN '".$fecha_1."' AND '".$fecha_2."' AND tipoEstadistica_id = '1' and siteEstadistica_id = '1'";
$rs_datos_accesos = mysql_query($sql_datos_accesos, $BBDD);
if (mysql_num_rows($rs_datos_accesos)!==0)
{
$consulta_accesos = mysql_fetch_array($rs_datos_accesos);
$num_accesos = $consulta_accesos["numAccesos"];
}
else
{
$num_accesos = 0;
}
//download information
$sql_datos_descargas1 = "SELECT count( id ) AS numDescargas1, `tipoEstadistica_id`FROM `estadisticas`WHERE `fecha`BETWEEN '".$fecha_1."' AND '".$fecha_2."'AND `tipoEstadistica_id` =2 GROUP BY tipoEstadistica_id";
$rs_datos_descargas1 = mysql_query($sql_datos_descargas1, $BBDD);
if (mysql_num_rows($rs_datos_descargas1)!==0)
{
while ($consulta_descargas1 = mysql_fetch_array($rs_datos_descargas1))
{
$tipoEstadistica1 = $consulta_descargas1["tipoEstadistica_id"];
$num_descargas1 = $consulta_descargas1["numDescargas1"];
}
}
$sql_datos_descargas2 = "SELECT count( id ) AS numDescargas2, `tipoEstadistica_id`FROM `estadisticas`WHERE `fecha`BETWEEN '".$fecha_1."' AND '".$fecha_2."'AND `tipoEstadistica_id` =3 GROUP BY tipoEstadistica_id";
$rs_datos_descargas2 = mysql_query($sql_datos_descargas2, $BBDD);
if (mysql_num_rows($rs_datos_descargas2)!==0)
{
while ($consulta_descargas2 = mysql_fetch_array($rs_datos_descargas2))
{
$tipoEstadistica2 = $consulta_descargas2["tipoEstadistica_id"];
$num_descargas2 = $consulta_descargas2["numDescargas2"];
}
}
$sql_datos_descargas3 = "SELECT count( id ) AS numDescargas3, `tipoEstadistica_id`FROM `estadisticas`WHERE `fecha`BETWEEN '".$fecha_1."' AND '".$fecha_2."'AND `tipoEstadistica_id` =5 GROUP BY tipoEstadistica_id";
$rs_datos_descargas3 = mysql_query($sql_datos_descargas3, $BBDD);
if (mysql_num_rows($rs_datos_descargas3)!==0)
{
while ($consulta_descargas3 = mysql_fetch_array($rs_datos_descargas3))
{
$tipoEstadistica3 = $consulta_descargas3["tipoEstadistica_id"];
$num_descargas3 = $consulta_descargas3["numDescargas3"];
}
}
$sql_datos_descargas4 = "SELECT count( id ) AS numDescargas4, `tipoEstadistica_id`FROM `estadisticas`WHERE `fecha`BETWEEN '".$fecha_1."' AND '".$fecha_2."'AND `tipoEstadistica_id` =8 GROUP BY tipoEstadistica_id";
$rs_datos_descargas4 = mysql_query($sql_datos_descargas4, $BBDD);
if (mysql_num_rows($rs_datos_descargas4)!==0)
{
while ($consulta_descargas4 = mysql_fetch_array($rs_datos_descargas4))
{
$tipoEstadistica4 = $consulta_descargas4["tipoEstadistica_id"];
$num_descargas4 = $consulta_descargas4["numDescargas4"];
}
}
$sql_datos_descargas5 = "SELECT count( id ) AS numDescargas5, `tipoEstadistica- 1 Contributor
- 0 Replies
- 49 Views
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.