Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <?php
- session_start();
- ?>
- <html>
- <head>
- <title>Simple Map</title>
- <meta name="viewport" content="initial-scale=1.0">
- <meta charset="utf-8">
- <link rel='stylesheet' type ='text/css' href='../css/Bootstrap.css'>
- <link rel ='stylesheet' type='text/css' href='../css/style01.css'>
- <link href="//netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css" rel="stylesheet">
- <script type="text/javascript" src="../script/jquery.js"></script>
- <script type="text/javascript" src="../script/jquerytablesorter.js"></script>
- <script type="text/javascript" src="../script/jquery.tablesorter.min.js"></script>
- </head>
- <body>
- <!--/begin navbar -->
- <nav class="navbar navbar-default">
- <div class="navbar navbar-default navbar-fixed-top" role="navigation">
- <div class="container">
- <div class="navbar-collapse collapse">
- <ul class="nav navbar-nav navbar-left">
- <li><a href="../index.php">Home</a></li>
- <li class='active'><a href="view.php">View all concerts </a></li>
- <li><a href=<?php if( isset($_SESSION['authenticated']) && $_SESSION['authenticated'] == 'true') { echo "saved.php";}
- else {echo "login.php";}?>> View saved concerts </a></li>
- <li><a href="login.php">Login</a></li>
- <li> <a href = 'logout.php'>Log out </a> </li>
- </ul>
- </div>
- </div>
- </div>
- </nav>
- <!-- end navbar -->
- <br><br><br><br>
- <div>
- <table id="myTable" class="tablesorter">
- <thead>
- <tr><th class="header">Artist</th><th class="">Genre</th><th>Venue</th><th>Address</th><th>Date</th></tr>
- </thead>
- <tbody>
- <?php
- $servername = "localhost";
- $username = "patrickr";
- $password = "iNd<escrib";
- $db = "patrickr";
- // Create connection
- $con = mysqli_connect($servername, $username, $password, $db);
- $sql="SELECT Artist, Genre, Venue, Address, Date FROM FinalConcertTable";
- $blah = mysqli_query($con, $sql);
- if (mysqli_num_rows($blah) > 0){
- while($row = mysqli_fetch_assoc($blah)) {
- echo "<tr>"
- . "<td>". $row["Artist"] ."</td>";
- echo "<td>". $row["Genre"] ."</td>";
- echo "<td>". $row["Venue"] ."</td>";
- echo "<td>". $row["Address"] ."</td>";
- echo "<td>". $row["Date"] ."</td></tr>";
- }
- }
- ?>
- </tbody>
- </table>
- <script type="text/javascript">
- $(function(){
- $('#myTable').tablesorter();
- });
- </script>
- </div>
- <!-- footer -->
- <div class="container">
- <div class ='navbar navbar-fixed-bottom'>
- <footer class='panel-footer'>
- <p class='small'> This website was created by Patrick Ryan and Harrison Kuzbyt. Please report bugs to Patrick.Ryan@du.edu</p>
- </footer>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement