| Server IP : 91.108.119.234 / Your IP : 216.73.217.80 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 "koneksi.php";
?>
<?php
header("Content-type: application/vnd-ms-excel");
header("Content-Disposition: attachment; filename=Data Anggota Mail WA kosong.xls");
?>
<center><span class="style2">REGISTRASI ULANG ANGGOTA IDI BANDUNG</span></center>
<br>
<div align="center"><span class="style2">ANGGOTA AKTIF: Email dan Telp kosong</span></center>
<br/>
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th width="10px">ID</th>
<th>Tgl </th>
<th>Nama</th>
<th>Alamat</th>
<th>Status Ang</th>
<th>email</th>
<th>Telp</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<?php
//$npm = $_GET['npm'];
// $sql = mysqli_query($konek, "SELECT * FROM h_anggota2 where active ='1' and trim(telp) = '' and trim(email) = '' and status ='aktif' order by email ");
$sql = mysqli_query($konek, "SELECT * FROM h_anggota2 where trim(telp) ='' and trim(email) = '' and status ='aktif' order by nmlead ");
$no=1;
$total =0;
$hariini = date('Y-m-d');
while($d=mysqli_fetch_array($sql)){
$idtag=$d['id_tagihan'];
?>
<tr>
<td data-header='ID'><?php echo $d['id_tagihan']; ?></td>
<td data-header='Tanggal'><?php echo $hariini ?></td>
<td data-header='Nama'><?php echo $d['nmlead']; ?></td>
<td data-header='Alamat'><?php echo $d['alamat']; ?></td>
<td data-header='Alamat'><?php echo $d['status']; ?></td>
<td data-header='Email'><?php echo $d['email']; ?></td>
<td data-header='Telp'><?php echo $d['telp']; ?></td>
<?php
IF($d['active'] == '1'){
?>
<td data-header='Status'><?php echo 'Belum Terkirim' ?></td>
<?php
}else{
?>
<td data-header='Status'><?php echo 'Sudah Terkirim' ?></td>
<?php
}
?>
<td><a class='btn btn-danger btn-sm' href='excpesan.php?id=<?php echo $d['id_tagihan']; ?>'>Kirim mail </a> </td>
<?php
}
?>
</td>
</tr>
<?php $no++; ?>
<br>
<div><caption class="title"> <span class="merah"> Tabel Hasil Import belum di Blast </caption></div>
</table>
</FORM>
<br>
<center><a href="#" class="no-print" onclick="window.print();">Cetak/Print</a></center>
<!-- <center><a class="btn btn-danger" href="./validasi-ijazah">Kembali</a></center> -->
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>