<?
php
// Menyiapkan koneksi database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "nama_database";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Query SQL dengan INNER JOIN
$sql = "SELECT tabel_jamaah.nama, tabel_cabang.nama_cabang, tabel_ranting.nama_ranting,
tabel_koja.alamat
FROM tabel_jamaah
INNER JOIN tabel_cabang ON tabel_jamaah.id_cabang = tabel_cabang.id_cabang
INNER JOIN tabel_ranting ON tabel_jamaah.id_ranting = tabel_ranting.id_ranting
INNER JOIN tabel_koja ON tabel_jamaah.id_koja = tabel_koja.id_koja";
$result = mysqli_query($conn, $sql);
// Mengambil hasil query
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "Nama: " . $row["nama"]. " - Cabang: " . $row["nama_cabang"]. " - Ranting: " .
$row["nama_ranting"]. " - Alamat: " . $row["alamat"]. "<br>";
} else {
echo "0 results";
}
// Menutup koneksi database
mysqli_close($conn);
?>
<?php
// Menyiapkan koneksi database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "nama_database";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Query SQL dengan INNER JOIN
$sql = "SELECT tabel_jamaah.nama, tabel_cabang.nama_cabang,
tabel_ranting.nama_ranting, tabel_koja.alamat
FROM tabel_jamaah
INNER JOIN tabel_cabang ON tabel_jamaah.id_cabang =
tabel_cabang.id_cabang
INNER JOIN tabel_ranting ON tabel_jamaah.id_ranting =
tabel_ranting.id_ranting
INNER JOIN tabel_koja ON tabel_jamaah.id_koja =
tabel_koja.id_koja";
$result = mysqli_query($conn, $sql);
// Mengecek apakah query berhasil atau tidak
if (!$result) {
die("Query failed: " . mysqli_error($conn));
}
// Mengecek jumlah baris hasil query
if (mysqli_num_rows($result) > 0) {
// Membuat tabel untuk menampilkan data jamaah
echo "<table><tr><th>Nama</th><th>Cabang</th><th>Ranting</th><th>Alamat
Koja</th></tr>";
// Loop untuk menampilkan setiap baris hasil query
while($row = mysqli_fetch_assoc($result)) {
echo "<tr><td>" . $row["nama"]. "</td><td>" . $row["nama_cabang"].
"</td><td>" . $row["nama_ranting"]. "</td><td>" . $row["alamat"].
"</td></tr>";
}
// Menutup tabel
echo "</table>";
} else {
// Jika tidak ada baris hasil query
echo "Tidak ada data jamaah yang ditemukan.";
}
// Menutup koneksi database
mysqli_close($conn);
?>\\
\\\\\\
Kode jamaah
<!DOCTYPE html>
<html>
<head>
<title>Formulir Penggabungan Data Jamaah</title>
</head>
<body>
<h2>Formulir Penggabungan Data Jamaah</h2>
<form action="gabung_data_jamaah.php" method="post">
<label for="nama">Nama Jamaah:</label>
<input type="text" name="nama" required><br><br>
<label for="cabang">Cabang:</label>
<select name="cabang" required>
<option value="">Pilih Cabang</option>
<?php
//koneksi ke database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "db_name";
$conn = mysqli_connect($servername, $username, $password,
$dbname);
//mengecek koneksi
if (!$conn) {
die("Koneksi gagal: " . mysqli_connect_error());
//mengambil data cabang dari tabel cabang
$sql = "SELECT * FROM cabang";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "<option value='" . $row['id_cabang'] . "'>" .
$row['nama_cabang'] . "</option>";
} else {
echo "<option value=''>Tidak ada data cabang</option>";
mysqli_close($conn);
?>
</select><br><br>
<label for="ranting">Ranting:</label>
<select name="ranting" required>
<option value="">Pilih Ranting</option>
<?php
//koneksi ke database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "db_name";
$conn = mysqli_connect($servername, $username, $password,
$dbname);
//mengecek koneksi
if (!$conn) {
die("Koneksi gagal: " . mysqli_connect_error());
//mengambil data ranting dari tabel ranting
$sql = "SELECT * FROM ranting";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "<option value='" . $row['id_ranting'] . "'>" .
$row['nama_ranting'] . "</option>";
} else {
echo "<option value=''>Tidak ada data ranting</option>";
mysqli_close($conn);
?>
</select><br><br>
<label for="koja">Koja:</label>
<select name="koja" required>
<option value="">Pilih Koja</option>
<?php
//koneksi ke database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "db_name";
$conn = mysqli_connect($
//mengecek koneksi
if (!$conn) {
die("Koneksi gagal: " . mysqli_connect_error());
//mengambil data koja dari tabel koja
$sql = "SELECT * FROM koja";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "<option value='" . $row['id_koja'] . "'>" . $row['nama_koja'] .
"</option>";
} else {
echo "<option value=''>Tidak ada data koja</option>";
mysqli_close($conn);
?>
</select><br><br>
<input type="submit" name="submit" value="Gabungkan Data Jamaah">
</form>
</body>
</html>