connect_error) { die(""); } // Ambil keyword pencarian $keyword = isset($_GET['keyword']) ? $conn->real_escape_string($_GET['keyword']) : ''; // Eksekusi query // Query dasar $sql = "SELECT a.id, a.identity_number AS no_ktp, a.nip AS nip, a.name AS nama_nasabah, a.date_of_birth AS tgl_lahir, a.address AS alamat_nasabah, a.phone AS hp, a.gender AS jenis_kelamin, b.zip_code AS kodepos, b.merital_status AS status_perkawinan, b.religion AS agama, b.mothers_name AS ibu_kandung, b.institution AS instansi, b.source_of_income AS sumber_penghasilan, b.degree AS pendidikan, b.mothly_income AS penghasilan_per_bulan, b.job_title AS pekerjaan, b.institution_name AS nama_instansi, b.institution_address AS alamat_instansi, b.beneficiary AS ahli_waris, b.beneficiary_status AS status_ahli_waris, b.beneficiary_address AS alamat_ahli_waris, b.created_at FROM customers a INNER JOIN customer_details b ON a.id = b.customer_id WHERE a.id > 594"; // Tambahkan pencarian jika ada keyword if ($keyword != '') { $sql .= " AND ( a.name LIKE '%$keyword%' OR a.identity_number LIKE '%$keyword%' OR a.nip LIKE '%$keyword%' OR a.phone LIKE '%$keyword%' OR a.address LIKE '%$keyword%' )"; } $sql .= " ORDER BY a.id"; // Eksekusi query $result = $conn->query($sql); $total_orang = $result ? $result->num_rows : 0; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo ""; } } else { echo ""; } $conn->close(); ?>

ID	No KTP	NIP	Nama Nasabah	Tanggal Lahir	Alamat	No HP	Jenis Kelamin	Kode Pos	Status Perkawinan	Agama	Ibu Kandung	Instansi	Sumber Penghasilan	Pendidikan	Penghasilan/Bulan	Pekerjaan	Nama Instansi	Alamat Instansi	Ahli Waris	Status Ahli Waris	Alamat Ahli Waris	Tanggal Input
Koneksi gagal: " . $conn->connect_error . "
{$row['id']}	{$row['no_ktp']}	{$row['nip']}	{$row['nama_nasabah']}	{$row['tgl_lahir']}	{$row['alamat_nasabah']}	{$row['hp']}	{$row['jenis_kelamin']}	{$row['kodepos']}	{$row['status_perkawinan']}	{$row['agama']}	{$row['ibu_kandung']}	{$row['instansi']}	{$row['sumber_penghasilan']}	{$row['pendidikan']}	{$row['penghasilan_per_bulan']}	{$row['pekerjaan']}	{$row['nama_instansi']}	{$row['alamat_instansi']}	{$row['ahli_waris']}	{$row['status_ahli_waris']}	{$row['alamat_ahli_waris']}	{$row['created_at']}
Tidak ada data ditemukan