<?php
include('header.php');
//ambil data get
$id_ahli=$_GET['id_ahli'];
//panggiDB
include('connection.php');
//pilih data dari jadual ahli
$sqlpilih=mysqli_query ($panggilDB, "SELECT* from ahlikelab,kelas,jawatan where
ahlikelab.id_kelas=kelas.id_kelas AND
ahlikelab.id_jawatan=jawatan.id_jawatan AND
ahlikelab.id_ahli='".$id_ahli."'");

//ambil data
$data = mysqli_fetch_array($sqlpilih);

//mula2 bina form
echo"
<form name='daftarahlibaru' action= 'kemaskiniahli.php?id_ahli=".$id_ahli."' method='post'  target='_self'>
<h1> Data Ahli Kelab </h1>
<table border='3' align=center>
<tr>
<td align ='center' bgcolor='gray'>Nama  : </td>
<td><input type='text' name='nama_ahli' value='".$data['nama_ahli']."'required>
</td>
 </tr>

<tr>
<td bgcolor='gray'> No. Kad Pengenalan : </td>
<td><input type='text' name='nokp_ahli'
value='".$data['nokp_ahli']."'
placeholder= Tanpa'-'
minlength=12
maxlength=12
required>
</td>
 </tr>

<tr>
<td bgcolor=gray> Kelas:</td>
<td>
 <select name='id_kelas'>
<option disabled selected >PILIH KELAS</option>";
//panggilDB
 include('connection.php');

//laksana arahan aql
$sqlkelas=mysqli_query($panggilDB,"SELECT* from kelas");
while($data=mysqli_fetch_array($sqlkelas)){
    echo"<option value='".$data['id_kelas']."'>
    ".$data['nama_kelas']."</option>";
    }
    echo"</select>
    </td>
</tr>

<tr>
<td bgcolor=gray> Jawatan:</td>
<td>
<select name='id_jawatan'>
<option disabled selected >PILIH JAWATAN</option>";
//panggilDB
include('connection.php');

//laksana arahan aql
$sqljawatan=mysqli_query($panggilDB,"SELECT* from jawatan");
while($data=mysqli_fetch_array($sqljawatan)){
    echo"<option value='".$data['id_jawatan']."'>
    ".$data['nama_jawatan']."</option>";
    }
    echo"</select>
    </td>
</tr>

<tr>
<td></td>
<td><input type='submit' value='KEMASKINI'>
</tr>

</table>

</form>
";
//L2: POST
if(!empty($_POST)){

//L3: ambik data yang dipost
$nama_ahli=$_POST['nama_ahli'];
$nokp_ahli=$_POST['nokp_ahli'];
$kelas =$_POST['id_kelas'];
$jawatan =$_POST['id_jawatan'];

//L4: Nak Panggil connection
include('connection.php');

//L5:proses penilaian
if(mysqli_query($panggilDB, "update ahlikelab set
nama_ahli='".$nama_ahli."',
nokp_ahli='".$nokp_ahli."',
id_kelas='".$kelas."'
id_jawatan='".$jawatan."'
where
   id_ahli='".$_GET['id_ahli']."'
   ")){

     //L6:Data telah dimasukkan
    echo"
    <script>
    alert('Kemaskini berjaya ');
    window.location.href='senaraiahli.php';
    </script> ";
}else{
    //L7:Data tidak dimasukkan
    echo"
    <script>
    alert(' Kemaskini Tidak Berjaya dibuat' );

    </script>";

    echo"error".mysqli_error($panggilDB);
    }
}
  include('footer.php')
   ?>