qwerty Posted August 19, 2006 at 10:52 PM Report #45330 Posted August 19, 2006 at 10:52 PM já me fartei de dar voltas á cabeça e nao consigo arranjar uma maneira para resolver um problema de maneira k resolvi pedir ajuda aqui.. o problema é o seguinte: ora eu tenho uma base de dados chamada contador_visitas com os campos dia, mes e ano, e quero apresentar em texto as visitas feitas por dia do actual mês ou meses passados claro,do estilo: dia 1 - 2 visitas dia 2 - 4 visitas dia 3 - 3 visitas ... .. dia 30 - 2 visitas dia 31 - 3 visitas e k nos dias k nao tivesse visualizações aparecesse o valor 0. alguém sabe?? é k eu nao consigo lá chegar... :S
kingless Posted August 19, 2006 at 11:39 PM Report #45332 Posted August 19, 2006 at 11:39 PM Mostra o código PHP para ver como é que fizeste o query etc...
qwerty Posted August 20, 2006 at 12:14 AM Author Report #45340 Posted August 20, 2006 at 12:14 AM A query ainda nao a tenho feita pq nao sei como a fazer 😄 lool actualmente fiz uma alteração k o numero de visitas vai aparecer "gráficamente" atraves de uma imagem redimensionada em k o valor das visitas vai ser o height em k a conta terá k ser a seguinte: ((num_visitas_do_dia*100)/maximo_visitas_mes) <? $localhost = 'localhost'; $username = 'root'; $password= ''; $db_name = 'new_site'; $link = mysql_connect($localhost,$username,$password); $db = mysql_select_db($db_name,$link); echo' <table border="0" cellpadding="2" cellspacing="0" align="center"> <tr> <td colspan="32" background="images/fundo.jpg"><span class="style3">Estatisticas do mês de: '.$mes_do_ano.'</span></td> </tr> <tr> <td valign="top" bgcolor="#CCCCCC" class="style2"><div align="center">'.$max_de_visitantes.'</div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="50" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> </tr> <tr> <td valign="bottom" bgcolor="#CCCCCC" class="style2"><div align="center">0</div></td> </tr> <tr> <td bgcolor="#CCCCCC"> </td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">01</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">02</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">03</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">04</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">05</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">06</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">07</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">08</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">09</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">10</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">11</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">12</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">13</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">14</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">15</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">16</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">17</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">18</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">19</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">20</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">21</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">22</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">23</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">24</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">25</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">26</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">27</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">28</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">29</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">30</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">31</span></div></td> </tr> </table> '; ?>
Triton Posted August 20, 2006 at 12:19 AM Report #45341 Posted August 20, 2006 at 12:19 AM Já ouviste falar em CSS? ? <3 life
qwerty Posted August 20, 2006 at 12:22 AM Author Report #45344 Posted August 20, 2006 at 12:22 AM 😄 já mas ainda nao me apeteceu dar ao trabalho lool 😄
kingless Posted August 20, 2006 at 12:22 AM Report #45345 Posted August 20, 2006 at 12:22 AM Se não executaste o query como é que queres calcular o dia e as visitas... Quando tiveres o código mais completo avisa-me, assim não te posso ajudar.
qwerty Posted August 20, 2006 at 12:34 AM Author Report #45350 Posted August 20, 2006 at 12:34 AM eu sei k nao consigo calcular as visitas, mas tb nao sei mt bem como calcular :S já vejo disso...
qwerty Posted August 20, 2006 at 01:43 AM Author Report #45368 Posted August 20, 2006 at 01:43 AM Aqui tá o consegui fazer... :S a partir daqui nao sei mais como fazer :S nao sei como é k vou arranjar o numero de visitas por cada dia do mês :S <? $mes_actual = DATE('n'); include("includes/meses.php"); //este include serve apenas para definir o nome do mês actual á variavel $mes $localhost = 'localhost'; $username = 'root'; $password= ''; $db_name = 'new_site'; $link = mysql_connect($localhost,$username,$password); $db = mysql_select_db($db_name,$link); $consulta = "SELECT id, dia FROM contador_visitas WHERE mes = '$mes_actual'"; $resultado = mysql_query($consulta); $max = mysql_num_rows($resultado); while ($linha = mysql_fetch_row($resultado)) { //tem k se por aqui qq coisa para se chegar ao numero de visitas por cada dia, mas o k é k já nao sei } echo' <table border="0" cellpadding="2" cellspacing="0" align="center"> <tr> <td colspan="32" background="images/fundo.jpg"><span class="style3">Estatisticas do mês de: '.$mes.'</span></td> </tr> <tr> <td valign="top" bgcolor="#CCCCCC" class="style2"><div align="center">'.$max.'</div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="50" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> <td rowspan="2" bgcolor="#CCCCCC" valign="bottom"><div align="center"><img src="images/fundo_estatisticas.jpg" width="10" height="100" align="bottom" /></div></td> </tr> <tr> <td valign="bottom" bgcolor="#CCCCCC" class="style2"><div align="center">0</div></td> </tr> <tr> <td bgcolor="#CCCCCC"> </td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">01</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">02</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">03</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">04</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">05</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">06</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">07</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">08</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">09</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">10</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">11</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">12</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">13</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">14</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">15</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">16</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">17</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">18</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">19</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">20</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">21</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">22</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">23</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">24</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">25</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">26</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">27</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">28</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">29</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">30</span></div></td> <td bgcolor="#CCCCCC"><div align="center"><span class="style2">31</span></div></td> </tr> </table> '; ?>
qwerty Posted August 20, 2006 at 02:19 PM Author Report #45436 Posted August 20, 2006 at 02:19 PM $consulta = "SELECT dia FROM contador_visitas WHERE mes = '$mes_actual' ORDER BY dia ASC"; $resultado = mysql_query($consulta); $max = mysql_num_rows($resultado); while ($linha = mysql_fetch_row($resultado)) { $num = $linha[0]; $dias = array($num => $dias[$num]++); echo 'linha = '.$num.' - array ='.$dias[$num].'<br>'; } Já experimentei isto, mas a unica coisa k me aparece é: linha = 14 - array = linha = 15 - array = linha = 15 - array = linha = 16 - array = ou seja nao tá a meter nada no array :?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now