<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "tempahperalatan";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if(isset($_POST['submit']))
{

    $noID = $_GET['noID'];
    $pemohon = $_POST['pemohon'];
    $trkhMula = $_POST['trkhMula'];
    $trkhAkhir = $_POST['trkhAkhir'];
    $n_program = $_POST['n_program'];
    $lokasi = $_POST['lokasi'];
    $n_anjuran = $_POST['n_anjuran'];
    $catatan = $_POST['catatan'];


    $sql = "UPDATE daftartempah SET pemohon = '".$pemohon."', trkhMula = '".$trkhMula."', trkhAkhir = '".$trkhAkhir."', n_program = '".$n_program."', lokasi = '".$lokasi."', n_anjuran = '".$n_anjuran."'  WHERE noID = '$noID'";



    if ($conn->query($sql) === TRUE) {
        echo "Record updated successfully";
    } else {
        echo "Error updating record: " . $conn->error;
    }
}
$conn->close();
?>

<form action="page9.php" method="POST">

<ul class="errorMessages"></ul>

        <div class="form-group row text-left">
          <label for="example-text-input" class="col-3 col-form-label">Nama Pemohon: </label>
          <div class="col-8">
            <input class="form-control" type="text" name="pemohon" id="pemohon" value="<?=$row['pemohon'];?>" required>
          </div>
        </div>

        <div class="form-group row text-left">
          <label for="example-date-input" class="col-3 col-form-label">Tarikh Mula: </label>
          <div class="col-8">
            <input class="form-control" type="date" value="0000-00-00" name="trkhMula" id="tmula" value="<?=$row['trkhMula'];?>" required>
          </div>
        </div>

        <div class="form-group row text-left">
          <label for="example-date-input" class="col-3 col-form-label">Tarikh Akhir: </label>
          <div class="col-8">
            <input class="form-control" type="date" value="0000-00-00" name="trkhAkhir" id="takhir" value="<?=$row['trkhAkhir'];?>" required>
          </div>
        </div>

        <div class="form-group row text-left">
          <label for="example-text-input" class="col-3 col-form-label">Nama Program: </label>
          <div class="col-8">
            <input class="form-control" type="text" name="n_program" id="namaProgram" value="<?=$row['n_program'];?>" required>
          </div>
        </div>

        <div class="form-group row text-left">
          <label for="example-text-input" class="col-3 col-form-label">Lokasi: </label>
          <div class="col-8">
            <input class="form-control" type="text" name="lokasi" id="lokasi" value="<?=$row['lokasi'];?>" required>
          </div>
        </div>



        <div class="form-group row text-left">
          <label for="example-text-input" class="col-3 col-form-label">Dept/Kelab/Anjuran: </label>
          <div class="col-8">
            <select class="form-control" name="n_anjuran" id="namaAnjuran" value="<?=$row['n_anjuran'];?>" required>
            <option name="" value=""></option>
              <option name="K1" value="B. Kewangan">BK - B. Kewangan</option>
              <option name="K2" value="B. Pentadbiran">BP - B. Pentadbiran</option>
              <option name="K3" value="B. Perancangan Hal Ehwal Korporat">BPK - B. Perancangan Hal Ehwal Korporat</option>
              <option name="K4" value="B. Pemb. Penilaian Projek">BPPP - B. Pemb. Penilaian Projek</option>
              <option name="K5" value="B. Pemb. Projek Sosial">BPPS - B. Pemb. Projek Sosial</option>
              <option name="K6" value="Unit Audit Dalaman">UAD - Unit Audit Dalaman</option>
              <option name="K7" value="Pej. wilayah Temerloh">PWT - Pej. wilayah Temerloh</option>
              <option name="K8" value="Pej. Wilayah Barat">PWB - Pej. Wilayah Barat</option>
              <option name="K9" value="Koperasi LKPP">KOOP - Koperasi LKPP</option>
              <option name="K10" value="KSK LKPP Negeri Pahang">KSKLKPP - KSK LKPP Negeri Pahang</option>
              <option name="K11" value="KSK LKPP Cawangan Ibu Pejabat">KSKCIP - KSK LKPP Cawangan Ibu Pejabat</option>
              <option name="K12" value="IBU PEJABAT">IBUPEJ - IBU PEJABAT</option>
              <option name="K13" value="KESATUAN SEKERJA">KESATUAN - KESATUAN SEKERJA</option>
            </select>
          </div>
        </div>

        <div class="form-group row text-left">
        <label for="exampleTextarea" class="col-3 col-form-label">Catatan: </label>
            <div class="col-8">
            <textarea class="form-control" id="exampleTextarea" rows="3" name="catatan" id="catatan" value="<?=$row['catatan'];?>" required></textarea>
            </div>
        </div>

        <div class="form-group">
            <textarea class="form-control sr-only"  name="id" id="txtbox2" rows="3" ><?php echo $row['id'];?></textarea>
        </div>

        <center><button type="submit" name="submit" class="btn btn-info">Submit</button></center>

</form>