| Server IP : 88.222.222.29 / Your IP : 216.73.217.31 Web Server : LiteSpeed System : Linux id-dci-web1986.main-hosting.eu 5.14.0-611.26.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Jan 29 05:24:47 EST 2026 x86_64 User : u686484674 ( 686484674) PHP Version : 8.0.30 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/u686484674/domains/idikotabandung.com/public_html/IDI/superadmin/ |
Upload File : |
<?php include "header.php";
// cek apakah yang mengakses halaman ini sudah login
if($_SESSION['status']<>"login"){
header("location:location:../login.php");
}
?>
<html>
<head>
<title>Mencari dan Menampilkan Data Duplikat di MySQL</title>
</head>
<body>
<center><h3>Mencari dan Menampilkan Data Duplikat</h3>
<p><b>Data NIK Anggota Ganda:</b></p></center>
<br><br>
<p>
<table class="demo-table responsive" >
<tr bgcolor="#e5e5e5">
<td>No</td>
<td>ID</td>
<td>NIK</td>
<td>NPA</td>
<td>Registrasi</td>
<td>Anggota_Baru</td>
<td>Nama</td>
<td>alamat</td>
<td>gambar</td>
<td>BaArcode</td>
<td>Action</td>
</tr>
<?php
include "koneksi.php";
$no=0;
$query =mysqli_query($konek, "SELECT npm, COUNT(*) duplikat FROM h_anggota GROUP BY npm HAVING COUNT(duplikat) > 1 order by id_tagihan");
while($result =mysqli_fetch_array($query)){
$vData =mysqli_query($konek, "SELECT * FROM h_anggota WHERE npm='$result[npm]' order by id_tagihan");
while($vdat =mysqli_fetch_array($vData)){
$no++
?>
<tr>
<td><?php echo $no?></td>
<td><?php echo $vdat['id_tagihan']?></td>
<td><?php echo $vdat['npm']?></td>
<td><?php echo $vdat['npa']?></td>
<td><?php echo $vdat['registrasi']?></td>
<td><?php echo $vdat['ab']?></td>
<td><?php echo $vdat['nmlead']?></td>
<td><?php echo $vdat['alamat']?></td>
<td><?php echo $vdat['gambar']?></td>
<td><?php echo $vdat['barcode']?></td>
<td><a class='btn btn-success btn-sm' href='del_doble.php?id=<?php echo $vdat['id_tagihan']; ?>'>hapus</a></td>
</tr>
<?php
}
}
?>
</table>
</p>
</body>
</html>