Advertisement
Guest User

gfgfh

a guest
Aug 17th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.53 KB | None | 0 0
  1.  
  2. <!DOCTYPE html>
  3. <html lang="en">
  4. <head>
  5. <title>News Site</title>
  6. <meta charset="UTF-8">
  7. <meta name="viewport" content="width=device-width, initial-scale=1">
  8. <link href="css/bootstrap.min.css" rel="stylesheet">
  9. <link href="css/bootstrap.css" rel="stylesheet">
  10.  
  11. <link rel="stylesheet" type="text/css" href="leftmenu.CSS">
  12.  
  13. <script src="js/jquery.js"></script>
  14. <script src="js/bootstrap.js"></script>
  15. <script src="js/bootstrap.min.js"></script>
  16. </head>
  17. <body>
  18.  
  19.  
  20. <nav class="navbar navbar-default">
  21. <div class="container-fluid">
  22. <div class="navbar-header">
  23. <a class="navbar-brand" href="index.php">New Site</a>
  24. </div>
  25. <ul class="nav navbar-nav">
  26. <li><a href="login.php">Insert Data</a></li>
  27. <li class="active"><a href="viewdata.php">View data</a></li>
  28. <li><a href="listdata.php">List Data</a></li>
  29. <li><a href="login.php">Login</a></li>
  30. <li><a href="registration.php">Registration</a></li>
  31. </ul>
  32.  
  33. </div>
  34.  
  35. </nav>
  36. <div class="vertical">
  37. <div class="leftmenu">
  38. <ul>
  39. <li><a href="login.php">Insert Data</a></li></br>
  40. <li class="active"><a href="viewdata.php">View data</a></li></br>
  41. <li><a href="listdata.php">List Data</a></li></br>
  42. <li><a href="login.php">Login</a></li></br>
  43. <li><a href="viewdata.php">Registration</a></li></br>
  44. </ul>
  45. </div>
  46. </div>
  47.  
  48.  
  49. <div class="container">
  50. <?php
  51. require 'config.php';
  52.  
  53. $l=$_SESSION['b'][0];
  54. $statement="select * from test order by id DESC LIMIT $l";
  55. $result = mysqli_query($conn, $statement);
  56.  
  57. if (mysqli_num_rows($result) > 0)
  58. {
  59. while($row = mysqli_fetch_assoc($result))
  60. {
  61.  
  62. $_SESSION['b'][0]=$_SESSION['b'][0]+2;
  63. echo "<div class='col-md-4'><div class='panel-group'><div class='panel panel-info'><div class='panel-heading' style=' overflow:hidden;'><b>"."<a href=\"singleview.php?id=$row[id]\" class='text-warning'>".$row['heading']."</a></b> -By Admin at " .$row['datetime']."</div><div class='panel-body' style='height:30px; overflow:hidden;'>".$row['summertext'] ."</div></div></div></div>";
  64.  
  65. }
  66. }
  67. else
  68. {
  69. echo "Nothing found in db";
  70. }
  71. mysqli_close($conn);
  72. ?>
  73. <a href="viewdata.php"><button>LOAD MORE</button></a>
  74. </div>
  75.  
  76. </body>
  77. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement