Untitled

<?php
require '../imports/database.php';
error_reporting(E_ALL);
date_default_timezone_set('America/Chicago');
?>
<!DOCTYPE html>
<html lang="en" dir="ltr">
  <head>
    <meta charset="utf-8">
    <title>Admin Panel</title>
    <link rel="stylesheet" href="../css/master.css">
    <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.6.3/css/all.css" integrity="sha384-UHRtZLI+pbxtHCWp1t77Bi1L4ZtiqrqD80Kn4Z8NTSRyMA2Fd33n5dQ8lWUE00s/" crossorigin="anonymous">
	  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/tag-editor/1.0.20/jquery.tag-editor.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/tag-editor/1.0.20/jquery.tag-editor.css">
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jodit/3.2.34/jodit.min.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/izitoast/1.4.0/css/iziToast.css">
    <script src="http://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/tag-editor/1.0.20/jquery.tag-editor.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jodit/3.2.34/jodit.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/izitoast/1.4.0/js/iziToast.min.js"></script>
  </head>
  <body>
    <div class="admin">
      <div class="a-padding"><li class="isni"><a href="#"><i class="fas fa-pen"></i> Write Posts</a></li></div>
      <div class="a-padding"><li class="isni"><a href="#"><i class="fas fa-file-alt"></i> View Posts</a></li></div>
      <div class="a-padding"><li class="isni"><a href="#"><i class="fas fa-bookmark"></i> Viewers</a></li></div>
      <div class="a-padding"><li class="isni"><a href="#"><i class="fas fa-plus"></i> Widget</a></li></div>
    </div>
    <div class="main-body">
      <h1>Start Writing</h1>
      <form method="post">
        <input type="text" name="title" placeholder="Title" class="form" required>
        <div class="form-padding"><input type="text" name="author" placeholder="Author" class="form" required></div>
        <div class="form-padding"><input type="text" name="imgurl" placeholder="IMG URL..." class="form"></div>
        <div class="form-padding"><input type="text" name="tags" required></div>
        <div class="form-padding"><input type="text" name="htags" required></div>
        <div class="form-padding"><textarea id="body" name="bodydata" required></textarea></div>
        <div class="spacer"><input type="checkbox" name="hpbox"> Make Highlight</div>
        <input type="submit" name="post" class="form">
      </form>
      <?php
        if (isset($_POST["post"])) {
          if (isset($_POST["hpbox"])) {
            $title = $_POST["title"];
            $author = $_POST["author"];
            $imgurl = $_POST["imgurl"];
            $tags = $_POST["tags"];
            $htags = $_POST["htags"];
            $bd = $_POST["bodydata"];
            $date = date("D M d, Y");
            $time = date("h:i A");
            $p = "true";
            $harch_date = date("M Y");

            $pinsql = "UPDATE `posts` SET `hp`='false' WHERE `hp`='true'";

            if ($con->query($pinsql) === TRUE) {
              echo
              '
              <script type="text/javascript">
                iziToast.show({
                  title: "Success!",
                  message: "Queried highlight",
                  backgroundColor: "#37c2dd"
                });
              </script>
              ';
            } else {
                echo "Error updating record: " . $con->error;
            }

            $stmt = $con->prepare("INSERT INTO `posts` (`title`, `author`, `image`, `bodydata`, `tags`, `htags`, `date`, `time`, `hp`, `arch_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
            $stmt->bind_param("ssssssssss", $title, $author, $imgurl, $bd, $tags, $htags, $date, $time, $p, $harch_dat);

            $stmt->execute();
            $stmt->close();


            echo
            '
            <script type="text/javascript">
            iziToast.show({
              title: "Success!",
              message: "Post inserted",
              backgroundColor: "#37c2dd"
            });
            </script>
            ';
          }else {

          $title = $_POST["title"];
          $author = $_POST["author"];
          $imgurl = $_POST["imgurl"];
          $tags = $_POST["tags"];
          $htags = $_POST["htags"];
          $bd = $_POST["bodydata"];
          $date = date("D M d, Y");
          $time = date("h:i A");
          $arch_date = date("M Y");
          $p = "false";

          $stmt = $con->prepare("INSERT INTO `posts` (`title`, `author`, `image`, `bodydata`, `tags`, `htags`, `date`, `time`, `hp`, `arch_id`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
          $stmt->bind_param("ssssssssss", $title, $author, $imgurl, $bd, $tags, $htags, $date, $time, $p, $arch_date);

          $stmt->execute();
          $stmt->close();
          $con->close();

          echo
          '
          <script type="text/javascript">
          iziToast.show({
            title: "Success!",
            message: "Post inserted",
            backgroundColor: "#37c2dd"
          });
          </script>
          ';
        }
      }
	?>
    </div>

    <script>
      $(document).ready(function() {
        var editor = new Jodit("#body", {
          "uploader": {
            "insertImageAsBase64URI": true
          }
        });

      });

      $('input[name="tags"]').tagEditor({
        placeholder: "Meta Tags",
        animateDelete: 100
      });

      $('input[name="htags"]').tagEditor({
        placeholder: "Hidden Meta Tags",
        animateDelete: 100
      });
    </script>
  </body>
</html>