Untitled

<?php
session_start();

include_once('../includes/connection.php');
include_once('article.php');
include_once('../includes/user.php');

$article = new Article;
$articles = $article->fetch_all();


if (isset($_SESSION['logged_in'])) { ?>

      <html>
      <head>
        <title>CMS Admin</title>
        <link rel="stylesheet" type="text/css" href="asdfg.css">
        <meta charset="UTF-8">
      </head>
      <body>
        <table border="0" width="100%" height="100%">
          <tr height="3%"><td colspan="5"></td></tr>
          <tr height="11%"><td class="jedna"></td><th colspan="3" class="titulek">Administrace</th><td class="jedna"></td></tr>
          <tr><td class="jedna"></td><td  rowspan="5" class="menu">
            <h2>MENU</h2><br>
            <?php echo $user['user_permision']; ?>
            <a href="add.php"><h4>Přidat příspěvek</h4></a><br>
            <a href="delete.php"><h4>Odebrat příspěvek</h4></a><br>
            <a href="index.php"><h4>Seznam příspěvků</h4></a><br>
            <hr height=100%><br>
            <b><a href="aseznam.php">Seznam moderátorů</a></b><br>
            <hr height=100%><br>
            <a href="logout.php"><h4>Odhlásit se</h4></a><br>
          </td><td class="jedna"></td><td rowspan="5" style="background-color:#1a1a1a">
            <h4>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Seznam příspěvků</h4>
            <ul>
              <?php foreach ($articles as $article) { ?>

              <li><a class="odkaz" href="../article.php?id=<?php echo $article['article_id']; ?> "><?php echo $article['article_title'];?></a>
                 - <small>
                      zveřejněno <?php echo date('j. m. Y', $article['article_timestamp'])?>
                   </small></li>
                   <br>
              <?php } ?>
              <br><br>
            </ul>
          </td><td></td></tr>
          <tr><td class="jedna"></td><td></td><td></td></tr>
          <tr height="1%"><td></td><td></td></tr>
          <tr><td class="jedna"></td><td></td><td rowspan="2"></td></tr>
          <tr><td></td><td></td></tr>
          <tr height="5%"><td></td><td colspan="3"><center><small>Copyright &copy;2017, Aleš Marek</small></center></td><td></td></tr>
        </table>
      </body>
      </html>
      <?php
      } else {
          if (isset($_POST['username'], $_POST['password'])) {
            $username = $_POST['username'];
            $password = md5($_POST['password']);

            if (empty($username) or empty($password)) {
                echo '<script type="text/javascript">alert("Zadejte prosím jméno a heslo!");</script>';
                } else {
                    $query = $pdo->prepare("SELECT * FROM users WHERE user_name = ? AND user_password = ?");

                    $query->bindValue(1, $username);
                    $query->bindValue(2, $password);

                    $query->execute();

                    $num = $query->rowCount();

                    if ($num == 1) {
                      $_SESSION['logged_in'] = true;
                      header('Location: index.php');
                      exit();
                    } else {

                      echo '<script type="text/javascript">alert("Špatné jméno nebo heslo!");</script>';
                    }

                }
            }
            ?>
                <html>
                <head>
                  <title>CMS Admin</title>
                  <link rel="stylesheet" type="text/css" href="post.css">
                  <meta charset="UTF-8">
                </head>
                <body>
                  <table border="0" width="100%" height="100%">
                    <tr height="3%"><td colspan="5"></td></tr>
                    <tr height="11%"><td class="jedna"></td><th colspan="3" class="titulek">Administrace</th><td class="jedna"></td></tr>
                    <tr><td class="jedna"></td><td  rowspan="5" class="menu">
                      <h2>MENU</h2><br>
                      <a href="http://cms.dapler.eu/"><h4>Domů</h4></a><br>
                      <a href="#"><h4>Odkaz</h4></a><br>
                      <a href="#"><h4>Odkaz</h4></a><br>
                      <a href="#"><h4>Odkaz</h4></a><br>
                    </td><td class="jedna"></td><td rowspan="5" style="background-color:#1a1a1a"><center>
                      <?php if (isset($error)) { ?>
                        <span style="color:#ff0000;"><?php echo $error; ?></span>

                        <br /><br />

                        <?php } ?>

                          <form action="index.php" method="post" autocomplete="off">
                                <input type="text" name="username" placeholder="Username"><br><br>
                                <input type="password" name="password" placeholder="Password"><br><br>
                                <input type="submit" value="Login"><br>
                          </form></center>
                        </td><td></td></tr>
                    <tr><td class="jedna"></td><td></td><td></td></tr>
                    <tr height="1%"><td></td><td></td></tr>
                    <tr><td class="jedna"></td><td></td><td rowspan="2"></td></tr>
                    <tr><td></td><td></td></tr>
                    <tr height="5%"><td></td><td colspan="3"><center><small>Copyright &copy;2017, Aleš Marek</small></center></td><td></td></tr>
                  </table>
                </body>
                </html>
            <?php }