Untitled

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="">
        <meta name="author" content="">
        <title><?php echo htmlspecialchars($_GET["name"]);?>@<?php echo htmlspecialchars($_GET["channel"]);?> - OtterLogs</title>
        <!-- Bootstrap core CSS -->
        <link rel="stylesheet" type="text/css" href="/bootstrap/css/bootstrap2.css"">
        <!-- Custom styles for this template -->
        <link href="/starter-template.css" rel="stylesheet" type="text/css">
        <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
        <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
      <script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
    <![endif]-->
    </head>
    <body>
        <div class="navbar navbar-inverse navbar-fixed-top" role="navigation">
            <div class="container">
                <div class="navbar-header">
                    <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                        <span class="sr-only">Toggle navigation</span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                        <span class="icon-bar"></span>
                    </button>
                    <a class="navbar-brand" href="#">OtterLogs</a>
                </div>
                <div class="collapse navbar-collapse">
                    <ul class="nav navbar-nav">
                        <li class="active">
                            <a href="#">Logs</a>
                        </li>
                        <li style="display: block;">
						</li>
                        <li style="display: block;">
						</li>
                    </ul>
                </div>
                <!--/.nav-collapse -->
            </div>
        </div>
        <div class="container">
            <div class="starter-template">

                <?php

			error_reporting(-1); // reports all errors
			ini_set("display_errors", "1"); // shows all errors
			ini_set("log_errors", 1);
			ini_set("error_log", "/tmp/php-error.log");

			$user = "XXXXX";
			$password = "XXXXX";

			$db = mysqli_connect('XXXXX', $user, $password, 'XXXXX');
			if($db->connect_errno > 0){
				die('Unable to connect to database [' . $db->connect_error . ']');
			}

            $statement = $db->prepare("SELECT Time, Message FROM Messages WHERE Sender=? AND Channel=? ORDER BY Time DESC");
			$name = htmlspecialchars($_GET["name"]);
			$channel = htmlspecialchars($_GET["channel"]);
			$statement->bind_param('ss', $name, $channel);

			$statement->execute();

			$statement->bind_result($returned_time, $returned_message);

			if(is_null($statement->fetch()))
			{
				?><h1>No records found for user <?php echo htmlspecialchars($_GET["name"]);?> on channel <?php echo htmlspecialchars($_GET["channel"]);?></h1><?php
				die();
			}
			else
			{
				?>
				<h1>Latest messages from user <?php echo htmlspecialchars($_GET["name"]);?> on channel <?php echo htmlspecialchars($_GET["channel"]);?></h1>
				<br><table border="1" align="center" style="width: 80%;">
				<p class="lead">
				<thead>
					<tr>
						<th height="25" style="text-align: center;">Time</th>
						<th height="25" style="text-align: center;">Message</th>
					</tr>
				</thead>
				<tbody>

				<?php
				while($statement->fetch()){
					?>
					<tr>
						<td height="25"><?php echo $returned_time?></td>
						<td height="25"><?php echo $returned_message?></td>
					</tr>
				<?php
				}
				?>
				</tbody>
				</table>
				<?php
				}
				$statement->free_result();
				?></p>
            </div>
        </div>
        <!-- /.container -->
        <!-- Bootstrap core JavaScript
    ================================================== -->
        <!-- Placed at the end of the document so the pages load faster -->
        <script src="assets/js/jquery.min.js"></script>
        <script src="bootstrap/js/bootstrap.min.js"></script>
        <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
        <script src="assets/js/ie10-viewport-bug-workaround.js"></script>
    </body>
</html>