Untitled

 <?php include 'database.php';?>
<?php
$sql="SELECT id, name FROM employee WHERE idrole = 1"; //index details
$query = mysqli_query($connect, $sql);
$query2 = mysqli_query($connect, $sql); //add another query
if (!$query) {
    die ('SQL Error: ' . mysqli_error($connect));
}
if (!$query2) {
    die ('SQL Error: ' . mysqli_error($connect));
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<title>Installation Services</title>
</head>

<body>
<?php include 'header.php';?>
<div class="container">
  <h3><center>Installation Form</h3></center>
  <br />
  <form class="form-horiontal" action="processservice.php" method="post">

  <div class="dropdown">
    <label class="control-label col-lg-2" for="team">Team :</label>
  <div class="col-lg-4">
    <select class="form-control" name="team">
    <option value="1">1</option>
    <option value="2">2</option>
    <option value="3">3</option>
    <option value="4">4</option>
    <option value="5">5</option>
    <option value="6">6</option>
    <option value="7">7</option>
    <option value="8">8</option>
    <option value="0">9</option>
    <option value="10">10</option>
    </select>
  </div>

  <label class="control-label col-lg-2" for="salesDate">Date :</label>
    <div class="col-lg-2">
        <input class="form-control" type="date" id="salesDate" name="salesDdate">
    </div>
  <br />
  </div>

  <br />

  <div class="dropdown">
  <label class="control-label col-lg-2" for="idemployee1">Technician Name 1 :</label>

  <div class="col-lg-4">
    <select class="form-control" id="idemployee1" name="idemployee1">
    <?php while ($row = mysqli_fetch_array($query)){?>
    <option value="<?=$row['id']?>"><?=$row['name']?></option>"; //sebab kau kene hantar id . bukan hantar name.
    <?php }
    ?>
    </select>

<label class="control-label col-lg-2" for="idemployee2">Technician Name 2 :</label>

  <div class="col-lg-4">
    <select class="form-control" id="idemployee2" name="idemployee2">
    <?php while ($row2 = mysqli_fetch_array($query2)){?> //change here too
    <option value="<?=$row2['id']?>"><?=$row2['name']?></option>"; //sebab kau kene hantar id . bukan hantar name.
    <?php } ?>
    </select>
  </div>
  <br />
  </div>

  <br />
  <br />
  <legend>Type of Orders/Works</legend>
  <fieldset>

    <div class="form-group">

            <label class="control-label col-lg-2" for="del">DEL :</label>
    <div class="col-lg-2">
        <input class="form-control" id="del" type="text" name="del">
    </div>

            <label class="control-label col-lg-2" for="streamyx">STREAMYX :</label>
    <div class="col-lg-2">
        <input class="form-control" id="streamyx" type="text" name="streamyx">
    </div><br />
    </div>


    <div class="form-group">
            <label class="control-label col-lg-2" for="combo">COMBO :</label>
    <div class="col-lg-2">
        <input class="form-control" id="combo" type="text" name="combo">
    </div>

            <label class="control-label col-lg-2" for="cdma">CDMA :</label>
    <div class="col-lg-2">
        <input class="form-control" id="cdma" type="text" name="cdma">
    </div><br />
    </div>


    <div class="form-group">
            <label class="control-label col-lg-2" for="fixedip">FIXED IP :</label>
    <div class="col-lg-2">
        <input class="form-control" id="fixedip" type="text" name="fixedip">
    </div>

            <label class="control-label col-lg-2" for="combotvos">COMBO + TVOS :</label>
    <div class="col-lg-2">
        <input class="form-control" id="combotvos" type="text" name="combotvos">
    </div><br />
    </div>


    <div class="form-group">
            <label class="control-label col-lg-2" for="streamyxtvos">STREAMYX + TVOS :</label>
    <div class="col-lg-2">
        <input class="form-control" id="streamyxtvos" type="text" name="streamyxtvos">
    </div>

            <label class="control-label col-lg-2" for="tvosonly">TVOS ONLY :</label>
    <div class="col-lg-2">
        <input class="form-control" id="tvosonly" type="text" name="tvosonly">
    </div><br />
    </div>


    <div class="form-group">
            <label class="control-label col-lg-2" for="streamyxjumper">STREAMYX JUMPER :</label>
    <div class="col-lg-2">
        <input class="form-control" id="streamyxjumper" type="text" name="streamyxjumper">
    </div>

            <label class="control-label col-lg-2" for="other">OTHERS :</label>
    <div class="col-lg-2">
        <input class="form-control" id="other" type="text" name="other">
    </div>
    </div>

  </fieldset>

    <br />
    <div align="center">
    <input type="submit" class="btn btn-info" value="Submit">
    </div>

  </form>
</div>
</body>
</html>