Advertisement
Guest User

Untitled

a guest
May 28th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.11 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <?php
  3. session_start();
  4. ?>
  5. <html>
  6. <head>
  7. <title>Simple Map</title>
  8. <meta name="viewport" content="initial-scale=1.0">
  9. <meta charset="utf-8">
  10. <link rel='stylesheet' type ='text/css' href='../css/Bootstrap.css'>
  11. <link rel ='stylesheet' type='text/css' href='../css/style01.css'>
  12. <link href="//netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css" rel="stylesheet">
  13. <script type="text/javascript" src="../script/jquery.js"></script>
  14. <script type="text/javascript" src="../script/jquerytablesorter.js"></script>
  15. <script type="text/javascript" src="../script/jquery.tablesorter.min.js"></script>
  16. </head>
  17.  
  18.  
  19.  
  20. <body>
  21.  
  22. <!--/begin navbar -->
  23. <nav class="navbar navbar-default">
  24. <div class="navbar navbar-default navbar-fixed-top" role="navigation">
  25. <div class="container">
  26. <div class="navbar-collapse collapse">
  27. <ul class="nav navbar-nav navbar-left">
  28. <li><a href="../index.php">Home</a></li>
  29. <li class='active'><a href="view.php">View all concerts </a></li>
  30. <li><a href=<?php if( isset($_SESSION['authenticated']) && $_SESSION['authenticated'] == 'true') { echo "saved.php";}
  31. else {echo "login.php";}?>> View saved concerts </a></li>
  32. <li><a href="login.php">Login</a></li>
  33. <li> <a href = 'logout.php'>Log out </a> </li>
  34. </ul>
  35. </div>
  36. </div>
  37. </div>
  38. </nav>
  39. <!-- end navbar -->
  40. <br><br><br><br>
  41.  
  42. <div>
  43. <table id="myTable" class="tablesorter">
  44. <thead>
  45. <tr><th class="header">Artist</th><th class="">Genre</th><th>Venue</th><th>Address</th><th>Date</th></tr>
  46.  
  47. </thead>
  48. <tbody>
  49. <?php
  50. $servername = "localhost";
  51. $username = "patrickr";
  52. $password = "iNd<escrib";
  53. $db = "patrickr";
  54. // Create connection
  55. $con = mysqli_connect($servername, $username, $password, $db);
  56.  
  57. $sql="SELECT Artist, Genre, Venue, Address, Date FROM FinalConcertTable";
  58. $blah = mysqli_query($con, $sql);
  59.  
  60. if (mysqli_num_rows($blah) > 0){
  61. while($row = mysqli_fetch_assoc($blah)) {
  62. echo "<tr>"
  63. . "<td>". $row["Artist"] ."</td>";
  64. echo "<td>". $row["Genre"] ."</td>";
  65. echo "<td>". $row["Venue"] ."</td>";
  66. echo "<td>". $row["Address"] ."</td>";
  67. echo "<td>". $row["Date"] ."</td></tr>";
  68. }
  69. }
  70. ?>
  71. </tbody>
  72. </table>
  73. <script type="text/javascript">
  74. $(function(){
  75. $('#myTable').tablesorter();
  76. });
  77. </script>
  78. </div>
  79. <!-- footer -->
  80. <div class="container">
  81. <div class ='navbar navbar-fixed-bottom'>
  82. <footer class='panel-footer'>
  83. <p class='small'> This website was created by Patrick Ryan and Harrison Kuzbyt. Please report bugs to Patrick.Ryan@du.edu</p>
  84. </footer>
  85. </div>
  86. </div>
  87. </body>
  88. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement