Berikut coding untuk menampilkan data Ganda/ Double pada website:
Coding untuk mencari jumlah data ganda:
//koneksi
<?php include "../kalakay/resto_conn.php";
$query=mysqli_query($koneksi, "SELECT nipd, COUNT(*) nipd FROM mhs GROUP BY nipd HAVING COUNT(nipd) > 1");
$tampilDataGanda=mysqli_fetch_array($query); ?>
<?php echo $tampilDataGanda["nipd"]; ?>
//koneksi data base
<?php include "../kalakay/resto_conn.php";
$query=mysqli_query($koneksi,"SELECT nipd FROM mhs WHERE nipd IN (SELECT nipd FROM mhs GROUP BY nipd HAVING COUNT(*) > 1)");
$tampilDataGandaa=mysqli_fetch_array($query); ?>
<?php echo $tampilDataGandaa["nipd"]; ?>