Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. <?php
  2. require("config.php");
  3.  
  4. $que = mysql_query("SELECT Topics.ID
  5. FROM Topics
  6. WHERE ID = '". $_GET[i] ."'");
  7.  
  8. while($arr = mysql_fetch_array($que)){
  9. $totale = $arr['Risposte'] + 1;
  10. }
  11.  
  12. if (floor($totale / 6) == $totale / 6){
  13. $pag = $totale / 6;
  14. }
  15. else{
  16. $pag = floor($totale / 6) + 1;
  17. }
  18.  
  19. $LimInf += (6*($_GET[page]-1));
  20.  
  21. $query = @mysql_query("SELECT Topics.ID, Topics.NICK, Topics.DATA, Topics.ORA, Topics.TITOLO, Topics.TESTO
  22. FROM Topics
  23. ORDER BY Topics.Data DESC LIMIT'.$_GET[LimInf].','6'");
  24.  
  25. $ID = array();
  26. $Nick = array();
  27. $Data = array();
  28. $Ora = array();
  29. $Titolo = array();
  30. $Testo = array();
  31. while($row = mysql_fetch_array($query))
  32. {
  33. $ID[] = $row['ID'];
  34. $Nick[] = $row['NICK'];
  35. $Data[] = $row['DATA'];
  36. $Ora[] = $row['ORA'];
  37. $Titolo[] = $row['TITOLO'];
  38. $Testo[] = $row['TESTO'];
  39. }
  40.  
  41. echo "<div id=\"content\">";
  42. for($i = 0; $i <= sizeof($ID)-1; $i++)
  43. {
  44. echo "<div class=\"post\">";
  45. echo "<h1 class=\"title\"> $Titolo[$i] </h1>";
  46. echo "<p class=\"nick\"><i>Posted by</i> <b> $Nick[$i] </b> <img src=\"images/PostedBye.jpg\"></p>";
  47. echo "<p class=\"date\"> <i>On</i> </span> $Data[$i], &nbsp <i>At</i> $Ora[$i] </p>";
  48. echo "<p class=\"entry\"> $Testo[$i] </p>";
  49. echo "<p class=\"trt\"> <a href=#>Segnala post</a> </p>";
  50. echo "</div>";
  51. }
  52.  
  53. echo "</div>";
  54.  
  55. if ($_GET[p] != $pag){
  56. $prec = $_GET[page]-1;
  57. echo "<a href=\"post.php?i=$_GET[i]&page=$prec\">precedente</a>";
  58. }
  59.  
  60. if ($_GET[p] != 1){
  61. $succ = $_GET[page]+1;
  62. echo "<a href=\"post.php?i=$_GET[i]&page=$succ\">sucessiva</a>";
  63. }
  64. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement