add-games.php

    <link rel="styleSheet" href="css/sidebar.css" />
    <link rel="styleSheet" href="css/add-games.css" />
    <link rel="styleSheet" href="css/messagebox.css" />
    <?php 
      $title = 'Add Games';
      include 'header.php'; 
      include_once ('./includes/admin-config.inc.php');
    ?>

    <div id="cbox" class="c-box">
      <span onclick="document.getElementById('cbox').style.display='none'" class="close" title="Close">×</span>
      <div class="c-box-content">
        <div class="content-container">
          <h2>Reset Form</h2>
          <p>Are you sure you want to reset?</p>
          <p>existing data will be lost!</p>
        
          <div class="c-buttons">
            <button onclick="document.getElementById('cbox').style.display='none'" class="cbtn">Cancel</button>
            <button onclick="resetForm()" class="dbtn">Reset</button>
          </div>
        </div>
      </div>
    </div>

    <div id="cbox2" class="c-box">
      <span onclick="document.getElementById('cbox2').style.display='none'" class="close" title="Close">×</span>
      <div class="c-box-content">
        <div class="content-container">
          <h2>Add Game</h2>
          <p>Are you sure you want to add this game?</p>
          <p>double check!</p>
        
          <div class="c-buttons">
            <button onclick="document.getElementById('cbox2').style.display='none'" class="cbtn">Cancel</button>
            <button onclick="submitForm()" class="dbtn">Add game</button>
          </div>
        </div>
      </div>
    </div>

    <div class="a-container">
      <?php include 'admin-sidebar.php'; ?>
      <div class="ag-container">
      <div id="msgbox-area" class="msgbox-area"></div>
        <h2>- Add a game -</h2>

        <form action="includes/addgame.inc.php" method="post" id="addgame" name="addgame" enctype="multipart/form-data" >
          <div class="form-item">
            <label for="name">Game Name:</label>
            <input type="text" name="gamename" id="name" required />
          </div>

          <div class="form-item">
            <label for="desc">Description:</label>
            <textarea
              name="description"
              id="desc"
              rows="5"
              cols="50"
            ></textarea>
          </div>

          <div class="form-item">
            <label for="inst">Instructions:</label>
            <textarea
              name="instructions"
              id="inst"
              rows="5"
              cols="50"
            ></textarea>
          </div>

          
          <?php
              require 'includes/database.inc.php';

              $sql = "SELECT gradeName FROM Grade";
              $result = mysqli_query($conn, $sql);

              if (mysqli_num_rows($result) > 0) {
                echo '<div class="form-item">';
                echo '<label for="grades">Grade:</label>';
                echo '<select name="grade" id="grades" required>';
                echo '<option disabled selected value> -- Select Grade -- </option>';
                while($row = mysqli_fetch_assoc($result)) {
                  echo '<option value="'.$row['gradeName'].'" >'.$row["gradeName"].'</option>';  
                }
                echo '</select>';
                echo '</div>';
              } else {
                echo "O Grades Found!";
              }

              $sql = "SELECT categoryName FROM Category";
              $result = mysqli_query($conn, $sql);

              if (mysqli_num_rows($result) > 0) {
                echo '<div class="form-item">';
                echo '<label for="categories">Category:</label>';
                echo '<select name="category" id="categories" required>';
                echo '<option disabled selected value> -- Select Category -- </option>';
                while($row = mysqli_fetch_assoc($result)) {
                  echo '<option value="'.$row['categoryName'].'" >'.$row["categoryName"].'</option>';
                }
                echo '</select>';
                echo '</div>';
              } else {
                echo "O Categories Found!";
              }

              $sql = "SELECT subjectName FROM Subject";
              $result = mysqli_query($conn, $sql);

              if (mysqli_num_rows($result) > 0) {
                echo '<div class="form-item">';
                echo '<label for="subjects">Subject:</label>';
                echo '<select name="subject" id="subjects" required>';
                echo '<option disabled selected value> -- Select Subject -- </option>';
                while($row = mysqli_fetch_assoc($result)) {
                  echo '<option value="'.$row['subjectName'].'" >'.$row["subjectName"].'</option>';
                }
                echo '</select>';
                echo '</div>';
              } else {
                echo "O Subjects Found!";
              }

              $sql = "SELECT devID FROM Developer";
              $result = mysqli_query($conn, $sql);

              if (mysqli_num_rows($result) > 0) {
                echo '<div class="form-item">';
                echo '<label for="developers">Developer ID:</label>';
                echo '<select name="developer" id="developers" required>';
                echo '<option disabled selected value> -- Select Developer -- </option>';
                while($row = mysqli_fetch_assoc($result)) {
                  echo '<option value="'.$row['devID'].'" >'.$row["devID"].'</option>';
                }
                echo '</select>';
                echo '</div>';
              } else {
                echo "O Developers Found!";
              }

              mysqli_close($conn); 
          ?>

          <div class="form-item">
            <label for="gaccess">Access Level:</label>'
            <select name="access" id="gaccess" required>
                <option disabled selected value> -- Select Access Level -- </option>
                <option value="Free">Free</option>
                <option value="Premium">Premium</option>
            </select>
          </div>

          <div class="form-item">
            <label for="gfile">Game File:</label>
            <input type="file" name="gamefile" id="gfile" required/>
          </div>

          <div class="form-item">
            <label for="gthumbnail">Thumbnail:</label>
            <input type="file" name="thumbnail" id="gthumbnail" />
          </div>

          <div class="ag-buttons">
            <button class="reset-btn" type="button" onclick="resetConfirm()">Reset</button>
            <button class="addgame-btn" type= "button" onclick="submitConfirm()">Add Game</button>
            <button class="submit-btn" id="submit" name="sumbit" type="submit">Add Game</button>
          </div>
        </form>
      </div>
    </div>

<script>
  function resetForm() {
    document.getElementById("addgame").reset();
    document.getElementById('cbox').style.display='none'
  }
  function resetConfirm() {
    document.getElementById('cbox').style.display='block'
  }
  function submitConfirm() {
    document.getElementById('cbox2').style.display='block'
  }
  function submitForm() {
    document.getElementById('cbox2').style.display='none'
    document.getElementById("submit").click();
  }
</script>

<script src="./js/messagebox.js"></script>
<?php
          if (isset($_GET["error"])) {
            if ($_GET["error"] == "none") {
              echo '<script>
                      msgboxbox.show(
                      "Successfully Added!"
                    );
                    </script>';
            }
            if ($_GET["error"] == "1") {
              echo '<script>
                      msgboxbox.show(
                      "You can not upload a game file of this type!. only js,php are allowd"
                    );
                    </script>';
            }
            if ($_GET["error"] == "2") {
              echo '<script>
                      msgboxbox.show(
                      "There was an error uplaoding game file!"
                    );
                    </script>';
            }
            if ($_GET["error"] == "3") {
              echo '<script>
                      msgboxbox.show(
                      "Game file is too big!"
                    );
                    </script>';
            }
            if ($_GET["error"] == "4") {
              echo '<script>
                      msgboxbox.show(
                      "You can not upload a thumbnail of this type!. only jpg,jpeg and png are allowd"
                    );
                    </script>';
            }
            if ($_GET["error"] == "5") {
              echo '<script>
                      msgboxbox.show(
                      "here was an error uplaoding thumbnail!"
                    );
                    </script>';
            }
            if ($_GET["error"] == "6") {
              echo '<script>
                      msgboxbox.show(
                      "Thumbnail is too big!"
                    );
                    </script>';
            }
          }
          ?>
<?php include('./footer.php'); ?>