Untitled

<?php
    /* Process data submitted by login form */
    if (isset($_POST['login'])) {
        $loggedIn = FALSE;
        $loginError = FALSE;

        $username = $_POST['username'];
        $password = $_POST['password'];

        if ($username != null || $password != null) {
            $users_file_name = "db/users.txt";
            $usernames_list = file($users_file_name);

            for ($i = 0; $i < sizeof($usernames_list); $i++) {

                $users_list = array_map('trim', explode(',', $usernames_list[$i]));

                if (($username === $users_list[0]) && ($password === $users_list[2])) {
                    $loggedIn = TRUE;
                    $loginError = FALSE;
                    break;
                } else {
                    $loggedIn = FALSE;
                    $loginError = TRUE;
                }
            }
        }
    }

    /* Process data submitted by report issues form */
    if (isset($_POST['reportIssues'])) {
        $preferred_name = test_form_input($_POST['preferredname']);
        $email = test_form_input($_POST['email']);
        $issueID = test_form_input($_POST['issues']);
        $issue_reported = "";
        $message = test_form_input($_POST['message']);

        $dateTimeObject = new DateTime("now", new DateTimeZone("America/Halifax"));
        $dateTimeObject->setTimestamp(time()); //adjust the object to correct timestamp
        $message_date = $dateTimeObject->format('d.m.Y,');
        $message_time = $dateTimeObject->format('H:i:sa');

        switch ($issueID) {
            case '1':
                $issue_reported = "Link Not Working";
                break;

            case '2':
                $issue_reported = "Page Not Found";
                break;

            case '3':
                $issue_reported = "Incorrect Script";
                break;

            default:
                $issue_reported = "Issue Not Selected";
                break;
        }

        $issue_report = "";
        $issue_report .= "Issue Alert!";
        $issue_report .= "\r\n";
        $issue_report .= "Type of Issue: " . $issue_reported;
        $issue_report .= "\r\n";
        $issue_report .= "\r\n";
        $issue_report .= "Submitted by: " . $preferred_name;
        $issue_report .= "\r\n";
        $issue_report .= "Email ID: " . $email;
        $issue_report .= "\r\n";
        $issue_report .= "Submitted At: " . $message_time . " - on - " . $message_date;
        $issue_report .= "\r\n";
        $issue_report .= "\r\n";
        $issue_report .= "Details: " . $message;

        $issue_file_name = "misc/message_" . time() . ".txt";
        $issue_file_handle = fopen($issue_file_name, "w") or die("Sorry! Unable to open file!");

        fwrite($issue_file_handle, $issue_report);

        fclose($issue_file_handle);

        $current_page = basename($_SERVER['PHP_SELF']);

        header("Location: " . $current_page . "?issue_reported=1");
    }
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <title></title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <link href="css/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<header>
  <nav class="col-sm-3 sidenav">
    <h2>Nic Mingo's Blog</h2>
    <ul class="nav nav-pills nav-stacked">
      <?php
        if(basename($_SERVER['PHP_SELF']) == "index.php"){
          echo "<li class=\"active\"><a href=\"index.php\">Homepage</a></li>"; //active
          echo "<li><a href=\"post.php\">Posts</a></li>";
          echo "<li><a href=\"report.php\">Report Issues</a></li>";
                    echo "<li><a href=\"categories.php\">Category</a></li>";
                    echo "<li><a href=\"add_post.php\">New Post</a></li>";
        } elseif(basename($_SERVER['PHP_SELF']) == "post.php"){
          echo "<li><a href=\"index.php\">Homepage</a></li>";
          echo "<li class=\"active\"><a href=\"post.php\">Posts</a></li>"; //active
          echo "<li><a href=\"report.php\">Report Issues</a></li>";
                    echo "<li><a href=\"categories.php\">Category</a></li>";
                    echo "<li><a href=\"add_post.php\">New Post</a></li>";
        } elseif(basename($_SERVER['PHP_SELF']) == "report.php") {
          echo "<li><a href=\"index.php\">Homepage</a></li>";
          echo "<li><a href=\"post.php\">Posts</a></li>";
          echo "<li class=\"active\"><a href=\"report.php\">Report Issues</a></li>"; //active
                    echo "<li><a href=\"categories.php\">Category</a></li>";
                    echo "<li><a href=\"add_post.php\">New Post</a></li>";
        } elseif(basename($_SERVER['PHP_SELF']) == "categories.php") {
          echo "<li><a href=\"index.php\">Homepage</a></li>";
          echo "<li><a href=\"post.php\">Posts</a></li>";
          echo "<li><a href=\"report.php\">Report Issues</a></li>";
                    echo "<li class=\"active\"><a href=\"categories.php\">Category</a></li>"; //active
                    echo "<li><a href=\"add_post.php\">New Post</a></li>";
        } elseif(basename($_SERVER['PHP_SELF']) == "add_post.php") {
          echo "<li><a href=\"index.php\">Homepage</a></li>";
          echo "<li><a href=\"post.php\">Posts</a></li>";
          echo "<li><a href=\"report.php\">Report Issues</a></li>";
                    echo "<li><a href=\"categories.php\">Category</a></li>";
                    echo "<li class=\"active\"><a href=\"add_post.php\">New Post</a></li>"; //active
        } else {
          echo "<li><a href=\"index.php\">Homepage</a></li>";
          echo "<li><a href=\"post.php\">Posts</a></li>";
            echo "<li><a href=\"report.php\">Report Issues</a></li>";
                    echo "<li><a href=\"categories.php\">Category</a></li>";
                    echo "<li><a href=\"add_post.php\">New Post</a></li>";
        }
      ?>
    </ul>

        <?php
        $server = "localhost";
        $username = "root";
        $password = "root";
        $dbname = "cms";
        $conn = new mysqli($server, $username, $password, $dbname);
        if ($conn->connect_error){
            die("Connection failed: " . $conn->connect_error . " please refresh the page.");
        }else {

            $sql = "SELECT * FROM category";
            $result = $conn->query($sql);

            if($result->num_rows > 0){
                echo "<div class=\"dropdown\">";
            echo "<button class=\"btn btn-primary dropdown-toggle\" type=\"button\" data-toggle=\"dropdown\">Category Posts";
            echo "<span class=\"caret\"></span></button>";
            echo "<ul class=\"dropdown-menu\">";
                while($row = $result->fetch_assoc()) {
                echo "<li><a href=\"category_posts.php?category=" . $row["cat_id"] . "\">" . $row["cat_title"] . "</a></li>";
                }
                echo "</ul>";
                echo "</div>";
                echo "<br>";
            }
        }

        $conn->close();
        ?>

    <div class="input-group">
      <input type="text" class="form-control" placeholder="Search Blog..">
      <span class="input-group-btn">
        <button class="btn btn-default" type="button">
          <span class="glyphicon glyphicon-search"></span>
        </button>
      </span>
    </div>
  </nav>
</header>