<?php include 'header.php';

// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
$curDate = date('Y-m-d H:i:s', strtotime('+5 hour +30 minutes'));
if (isset($_REQUEST['submit'])) 
{
    $state_id = $_REQUEST['state_id'];
    $for_class = $_REQUEST['for_class'];
    $link = $_REQUEST['link'];
    $board = $_REQUEST['board'];
    $remark = $_REQUEST['remark'];
    $status = $_REQUEST['status'];
    $entity_text = $_REQUEST['entity_text'];
    $display_order = $_REQUEST['display_order'];

    $add_boardQuery = "Insert into sp_board_exam set for_class='$for_class', state_id='$state_id', link='$link', remark='$remark', add_by='$user_id', add_date='$curDate', status='$status',entity_text='$entity_text',display_order='$display_order',board='$board'";
    $sql = $db->prepare($add_boardQuery);
    if ($sql->execute()) 
    {
        $message = '<h3 style="color:#000000;">Added successfully</h3>';
    }
}

?>

<main id="main-container">
    <div class="content content-narrow">
        <div class="row">
            <div class="col-lg-12">
                <h2 class="content-heading">Add Details</h2>
                <div class="block">
                    <div class="block-header">
                        <ul class="block-options">
                            <li>
                                <button type="button"><i class="si si-settings"></i></button>
                            </li>
                        </ul>
                        <h3 class="block-title"></h3>
                    </div>
                    <div>
                        <h2><?php echo $message; ?></h2>
                    </div>
                    <div class="block-content block-content-narrow">
                        <form class="js-validation-bootstrap form-horizontal" method="post" name="myForm" id="form">
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">State :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <select class="js-select2 form-control" id="type2" name="state_id" style="width: 100%;">
                                            <?php
                                            $sql = $db->prepare("SELECT state_id,state_name FROM sp_states order by state_name asc");
                                            $sql->execute();
                                            ?>
                                        <option selected="selected">--Select State--</option>
                                            <?php
                                                while ($row1 = $sql->fetch(PDO::FETCH_ASSOC)) {  
                                            ?>
                                        <option value="<?php echo $row1['state_id']; ?>"><?php echo $row1['state_name']; ?></option>
                                            <?php  } ?>
                                    </select>
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">For Class :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="for_class" placeholder="For Class !!">
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">Board :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="board" placeholder="Enter Board !!">
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">Entity Text :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="entity_text" placeholder="Entity text!!">
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">Link :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="link" placeholder="Add Link !!">
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">Add Remark :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="remark" placeholder="Add remark !!">
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-select2">Display Order :<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="number" name="display_order" placeholder="Add Display Order !!">
                                </div>
                            </div>
                            <div class="form-group">
                                <div class="col-md-10 col-md-offset-2">
                                    <select class="js-select2 form-control" id="type2" name="status" style="width: 100%;">
                                        <option value="0">De-active</option>
                                        <option value="1">Active</option>
                                    </select>    
                                </div>
                            </div>
                            <div class="form-group">
                                <div class="col-md-10 col-md-offset-2">
                                    <button class="btn btn-lg btn-primary" type="submit" name="submit">Submit</button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
<?php include 'footer.php'; ?>