STAT help me

kheikhei 0 Newbie Poster
16 Years Ago
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
php
stat.php (12.06 KB)
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
51 Views
Be the first to reply
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.