<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>