Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement