Leoxz Posted May 27, 2007 Report Share Posted May 27, 2007 (edited) primero ahi que crear la conexion a la base de datos del foro <?php $host = "localhost"; // host de la bdd $userx = "root"; // usuario $passx = "pass"; // password $bdd = "mysql"; // base de datos /* A partir de aquí es recomendable que no toques nada */ $conecta = mysql_connect($host,$userx,$passx); mysql_select_db($bdd,$conecta); /* Conectado con exito a la bdd y sesion iniciada */ ?> lo guardamos como conexion.php ahora el codigo para los 10 ultimos post <? require('conexion.php'); include("lacarpetadelforo/conf_global.php"); ?> <table><td> <table bgcolor="#333333" width="550" cellspacing="1" cellpadding="6"><td bgcolor="#dddddd"> <b><font face="verdana" size="1" color="#000000">10 Ultimos mensajes en el Foro </td></table> <table bgcolor="#333333" width="550" cellspacing="1" cellpadding="6"> <tr> <td width="350" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">Tema</b></td> <td width="100" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">Escrito por</b></td> <td width="100" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">Empezado por</b></td> <td width="25" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">RE:</b></td> <td width="25" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">Visitas</b></td> </tr> <? $resp = mysql_query("select * from ibf_topics order by last_post DESC limit 10"); while($row = mysql_fetch_array($resp)){ ?> <? $msg = $row['title']; ?> <tr> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><a href="index.php?showtopic=<?=$row['tid']?>" target="_blank"><?=$msg?></a></td> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><?=$row['last_poster_name']?></td> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><?=$row['starter_name']?></td> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><?=$row['posts']?></td> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><?=$row['views']?></td> </tr> <? } ?> </table> </td></table> <br><br><br> <table><td> <table bgcolor="#333333" width="300" cellspacing="1" cellpadding="6"><td bgcolor="#dddddd"> <b><font face="verdana" size="1" color="#000000">5 mejores posteadores </td></table> <table bgcolor="#333333" width="300" cellspacing="1" cellpadding="6"> <tr> <td width="200" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">Usuario</b></td> <td width="100" bgcolor="#eeeeee"><b><font face="verdana" size="1" color="#000000">Nº de Mensajes</b></td> </tr> <? $resp2 = mysql_query("select * from ibf_members order by posts DESC limit 5"); while($row2 = mysql_fetch_array($resp2)){ ?> <? $msg = $row['title']; ?> <tr> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><a href="index.php?showuser=<?=$row2['id']?>" target="_blank"><?=$row2['name']?></a></td> <td bgcolor="#ffffff"><font face="verdana" size="1" color="#333333"><?=$row2['posts']?></td> </tr> <? } ?> </table> </td></table> lo guardan como ultimospost.php y ahora para ponerlo en el index hacen un include <?php include('ultimospost.php'); ?> y listo cualquier problemas posteenlo aqui saluos Edited May 27, 2007 by Leoxz Link to comment Share on other sites More sharing options...
construccid Posted June 2, 2008 Report Share Posted June 2, 2008 Gracias por tu aporte... pero tengo unos problemas.. te envie un mp... vale!! Link to comment Share on other sites More sharing options...
zenit_and Posted June 5, 2008 Report Share Posted June 5, 2008 y el segundo codigo se puede colocar o agregarlo a un sitio html?? onda como un shoutbox pero con los avisos del foro...se puede? o hay que generar una pagina en php y colocar eso? Link to comment Share on other sites More sharing options...
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