<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<a href="#menu-toggle" class="btn btn-default" id="menu-toggle">Menu Bar</a>
<h1 align="center">List of Designation</h1>
<?php
@($cat = $_GET['cat']);
// Use this line or below line if register_global is off
if (strlen($cat) > 0 and !is_numeric($cat)) {
// to check if $cat is numeric data or not.
echo "Data Error";
exit;
}
///////// Getting the data from Mysql table for first list box//////////
$objEmployee = new Designation();
$dptResult = $objEmployee->getAllDpt();
///////////// End of query for first list box////////////
/////// for second drop down list we will check if category is selected else we will display all the subcategory/////
if (isset($cat) and strlen($cat) > 0) {
$objEmployee = new Designation();
$singleResult = $objEmployee->getSingleEmpDptInfo($cat);
} else {
$objDesignation = new Designation();
$singleResult = $objDesignation->getAllDesi();
}
////////////////// This will end the second drop down list ///////////
?>
<form role="form" action="" method="" >
<div class="col-lg-6 col-md-offset-6 form-group">
<div id="page-content-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<a href="#menu-toggle" class="btn btn-default" id="menu-toggle">Menu Bar</a>
<h1 align="center">Designation</h1>
<form role="form" action="../controller/AddDesignationController.php" method="post" >
<div class="form-group">
<label for="dptName">Department Name: </label>
<select class="form-control" name="dptName" id="dptName">
<?php
$objDesignation = new Designation();
$Asc = "ASC";
$result = $objDesignation->getAllDpt($Asc);
while ($row = mysqli_fetch_array($result)) {
?>
<option value="<?php
echo $row['dptId'];
?>
"><?php
echo $row['dptName'];
?>
</option>
<?php
}
?>
</select>
</div>
