addJudges.php

<?php
require_once 'header.php';
if (!verifySession()) {
    header("Location: index.php");
}

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $judge = clean($_POST['judge']);
    $con = clean($_POST['contest']);
    $j="j";
    $res=mysqli_query($connection,"INSERT INTO `result` ( `id`, `contest_id`, `j_p`) VALUES ('$judge','$con','$j')")or die(mysqli_error($connection));
    $success = "Judge successfully added";
}
$contests= mysqli_query($connection,"SELECT * FROM `contests`");
$judge=mysqli_query($connection,"SELECT * FROM `users` where `j_p`='J'");
?>
<div class="container-fluid">
    <div class="row">
        <nav class="col-md-2 d-none d-md-block sidebar">
            <?php require_once 'sidebar.php';?>
        </nav>
        <div class="col-md-10 mt-3">
            <div class="row">
                <label style='color:black; font-size:24px; font-family: Verdana, Geneva, Tahoma, sans-serif;'>Add Judge</label>
                <br/><br/>
                <br/>
                <div>
                </div>
            </div>
            <div class="row mt-4">
                <div style='color:black; font-size:17px; font-family: Verdana, Geneva, Tahoma, sans-serif;'class="col-md-9">
                    <?php if(!empty($success)){?>
                    <div class="alert alert-success alert-dismissible fade in" role="alert">
                        <?php echo $success;?>
                    </div>
                    <?php } ?>
                    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
                    <div class="form-group">
                            <label style='color:black; font-size:18px; font-family: Verdana, Geneva, Tahoma, sans-serif;'>Judge Mail ID</label>
                            <select name="judge" class="form-control">
                                <?php while ($j = mysqli_fetch_assoc($judge)) {?>
                                <option style='color:black; font-family: Verdana, Geneva, Tahoma, sans-serif;' value="<?php echo $j['id'] ?>"><?php echo $j['email'] ?></option>
                                <?php }?>
                            </select>
                        </div><br/>
                        <div class="form-group">
                            <label style='color:black; font-size:18px; font-family: Verdana, Geneva, Tahoma, sans-serif;'>Contest</label>
                            <select name="contest" class="form-control">
                                <?php while ($c = mysqli_fetch_assoc($contests)) {?>
                                <option style='color:black;font-family: Verdana, Geneva, Tahoma, sans-serif;' value="<?php echo $c['contest_id'] ?>"><?php echo $c['c_name'] ?></option>
                                <?php }?>
                            </select>
                        </div><br/>
                        <div>
                            <button style='color:white;font-size:18px; background-color:black;padding:15px;font-family: Verdana, Geneva, Tahoma, sans-serif;' type="submit" class="btn" style="width: 220px;">Add</button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

</div>
</div>
</div>
</body>
</html>