Pengambilan data yang tidak sesuai dengan id data.

mohon bantuannya para mastah saya memiliki relasi tabel seperti ini

dan tampilan program saya seperti ini

ketika bukti pembayaran diupload, data tersebut di simpan di tabel pembayaran dan otomatis juga tersimpan di tabel detail_pembayaran.

permasalahannya, saya mencoba untuk mengupload bukti pembayaran pada sebuah akun yang memiliki 2 data booking. saya mencoba mengupload bukti pembayaran untuk bookingan nomor 2 dengan kode detail 31, tapi yang di proses malah bookingan nomor 1 dengan kode detail 30

dan kenapa tampilan data booking yang kedua tidak rapi seperti bookingan yang pertama?

kodingnya seperti ini

<table class="table table-striped table-dark">
   <thead class="thead-dark">
      <tr>
	<th class="col-md-1">No</th>
	<th class="col-md-1">Kode Detail</th>
	<th class="col-md-2">Nama Desa</th>
	<th class="col-md-2">Nama Paket</th>
	<th class="col-md-2">Tanggal Wisata</th>
	<th class="col-md-2">Aksi</th>
      </tr>
   </thead>
   <?php
    include 'config/connection.php';
        $kd_detail = isset($_POST['kd_detail']) ? $_POST['kd_detail'] : '';
        $kd_booking = isset($_POST['kd_booking']) ? $_POST['kd_booking'] : '';
	$id_user = isset($_POST['id_user']) ? $_POST['id_user'] : '';
	$no = 1;
	$sql = "SELECT desa.nama_desa,paket.nama_paket,booking.tgl_wisata,user.id_user,detail_booking.kd_detail FROM desa INNER JOIN paket ON desa.kd_desa=paket.kd_desa INNER JOIN booking ON paket.kd_paket=booking.kd_paket INNER JOIN user ON user.id_user=booking.id_user INNER JOIN detail_booking ON booking.kd_booking=detail_booking.kd_booking WHERE uname='$_SESSION[uname]'";
	$query = mysqli_query($conn,$sql);
	while ($data = mysqli_fetch_array($query)) {
	?>
	  <tr>
		<td><?php echo $no++ ?></td>
		<td><?php print_r($data['kd_detail']) ?></td>
		<td><?php echo $data['nama_desa']; ?></td>
		<td><?php echo $data['nama_paket']; ?></td>
		<td><?php echo $data['tgl_wisata']; ?></td>
		<td>
		<a href="#mymodal" data-toggle="modal" id="kd_detail<?php echo $data['kd_detail']; ?>" class="btn btn-warning ">Upload Bukti</a>

		</td>
	  </tr>
	</table>
</div>
<div id="mymodal" class="modal fade">
   <div class="modal-dialog">
      <div class="modal-content">
         <div class="modal-header">
	   <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
	   <h4 class="modal-title">Upload Bukti Pembayaran</h4>
	 </div>
	 <div class="modal-body">
	     <form action="proses/pembayaran.php" method="POST" enctype="multipart/form-data">
		<input name="kd_detail" type="hidden" class="form-control" value="<?php echo $data['kd_detail'] ?>" readonly/>
		<label>Upload Bukti</label>
		<input type="file" name="bukti">
		<div class="modal-footer">
		   <button type="button" class="btn btn-default" data-dismiss="modal">Batal</button>
		   <input type="submit" name="submit" class="btn btn-primary" value="Simpan">
	        </div>
	     </form>
	</div>
       </div>
   </div>
</div>
<?php }?>

pada pembayaran.php

<?php
include '../config/connection.php';

if (isset($_POST["submit"])) {
	$kd_bayar = $_POST['kd_bayar'];
	$bukti = $_FILES['bukti']['name'];
	$kd_detail = $_POST['kd_detail'];


	$target = "../img/".basename($_FILES['bukti']['name']);

	$sql = "INSERT INTO pembayaran (kd_bayar,kd_detail,bukti) VALUES ('$kd_bayar','$kd_detail','$bukti')";
	$query = mysqli_query($conn,$sql);

	if ($query) {

		$sql2 = mysqli_query($conn,"SELECT kd_bayar FROM pembayaran WHERE kd_detail='$kd_detail'");
		$data = mysqli_fetch_array($sql2);

		$kd_bayar = $data['kd_bayar'];

		$detail = "INSERT INTO detail_pembayaran (kd_bayar,status_bayar) VALUES ('$kd_bayar','lunas')";
		$ok = mysqli_query($conn,$detail);
		header('location:../mybooking.php');
	}else{
		header('location:../mybooking.php?status=error');
	}
}
?>

Terima kasih