<?php
include 'config.php';


$board_id = $_REQUEST['id'];

$getData = "SELECT for_class, link, state_id, remark, status, entity_text, display_order, board from sp_board_exam where id='$board_id'";
$stmt = $db->prepare($getData);
$stmt->execute();
$row = $stmt->fetch();

?>
<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">
                <input type="hidden" value="<?php echo $board_id; ?>" name="e_board_id">
                <select class="js-select2 form-control" name="e_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 if ($row['state_id'] == $row1['state_id']) {   
                            echo "selected";
                            } ?>>
                        <?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="e_for_class" placeholder="For Class !!" value="<?php echo $row['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="e_board" placeholder="Enter Board !!" value="<?php echo $row['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="e_entity_text" placeholder="Entity Text !!" value="<?php echo $row['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="e_link" placeholder="Add Link !!" value="<?php echo $row['link']; ?>">
            </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="e_display_order" placeholder="Add Display Order !!" value="<?php echo $row['display_order']; ?>">
            </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="e_remark" placeholder="Add remark !!" value="<?php echo $row['remark']; ?>">
            </div>
        </div>
        <div class="form-group">
            <div class="col-md-10 col-md-offset-2">
                <select class="js-select2 form-control" id="type2" name="e_status" style="width: 100%;">
                    <option value="0" <?php if ($row['status'] == '0') {
                                            echo "selected";
                                        } ?>>De-active</option>
                    <option value="1" <?php if ($row['status'] == '1') {
                                            echo "selected";
                                        } ?>>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="update">Submit</button>
            </div>
        </div>
    </form>
</div>