<?php  
include 'config.php';

 $userid=$_REQUEST['id'];
 $query="SELECT e.id, e.exam_id, e.type_id, e.type_name, e.gen, e.obc, e.sc, e.st, e.ebc, e.wbc, e.total_vac, e.age_limit, e.eligibility, e.status, e.date_added,et.type,ex.exam_name FROM sp_vacancy_detail as e left join sp_exam_type as et on et.type_id=e.type_id left join sp_exam as ex on e.exam_id=ex.exam_id where e.id='$userid'";
 $sql = $db->prepare($query);
 $sql->execute();
 $row = $sql->fetch();
 
?>
<div class="block-content block-content-narrow">
    <form class="js-validation-bootstrap form-horizontal" method="post">
        <div class="form-group">
            <label class="col-md-4 control-label" for="val-select2">Select Exam</label>
			<div class="col-md-7">
				<select class="js-select2 form-control"  name="examname" style="width: 100%;">
                    <option selected="selected" value="<?php echo $row['exam_id']; ?>">    <?php echo $row['exam_name']; ?>
                        
                    </option>
						    <?php 
						        $sql2 = $db->prepare("SELECT exam_id,exam_name FROM sp_exam");
                                $sql2->execute();
                            ?>
                        <?php
                            while($row2=$sql2->fetch(PDO::FETCH_ASSOC)) {
                        ?>
					<option value="<?php echo $row2['exam_id']; ?>">
                        <?php echo $row2['exam_name']; ?>
                    </option>
					    <?php	} ?>
                </select>
            </div>
		</div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-password">Type<span class="text-danger">*</span></label>
            <div class="col-md-7">
                <select name="typeid" class="form-control">
			        <option value="1" <?php if($row['type_id']==1){echo "selected";} ?>> For Post Wise </option>
			        <option value="2" <?php if($row['type_id']==2){echo "selected";} ?>> For City Wise </option>
			        <option value="3" <?php if($row['type_id']==3){echo "selected";} ?>>For State Wise </option>
			  </select>
            </div>
        </div>													
	    <div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Type Name<span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                <input class="form-control" type="text" name="typename" placeholder="" value="<?php echo $row['type_name']; ?>">
            </div>
        </div>
        <div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Vacancy For genral <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="v_genral" placeholder="" value="<?php echo $row['gen']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Vacancy For OBC <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="v_OBC" placeholder="" value="<?php echo $row['obc']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Vacancy For SC <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="v_SC" placeholder="" value="<?php echo $row['sc']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Vacancy For ST <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="v_ST" placeholder="" value="<?php echo $row['st']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Vacancy For EBC <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="EBC" placeholder="" value="<?php echo $row['ebc']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Vacancy For WBC <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="WBC" placeholder="" value="<?php echo $row['wbc']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Total Vacancy <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="number" name="total_vacancy" placeholder="" value="<?php echo $row['total_vac']; ?>">
            </div>
        </div>
	   <div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Age Limit <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="text" name="age_limit" placeholder="" value="<?php echo $row['age_limit']; ?>">
            </div>
        </div>
		<div class="form-group">
            <label class="col-md-4 control-label" for="val-username"> Eligibility <span class="text-danger">*</span></label>
            <div class="col-md-7">
                <input class="form-control" type="text" name="Eligibility" placeholder="" value="<?php echo $row['eligibility']; ?>">
            </div>
        </div>
	    <div class="form-group">
            <label class="col-md-4 control-label" for="val-password">Status<span class="text-danger">*</span></label>
            <div class="col-md-7">
              <select name="status" class="form-control">
			  <option value="<?php echo $row['status']; ?>" <?php if($row['status']==1){echo "selected";} ?>> Active </option>
			  <option value="<?php echo $row['status']; ?>" <?php if($row['status']==0){echo "selected";} ?>> Deactive </option>
			
			  </select>
            </div>
        </div>	
		<div class="form-group">
            <div class="col-md-8 col-md-offset-4">
                <button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
            </div>
        </div>
    </form>
</div>
<?php  include 'footer.php';	?>