prepare("SELECT * FROM `101m`");
// read all row from database table
$sql = "SELECT * FROM `101m` WHERE `TC` = '$str'";
$result = $baglanti->query($sql);
// read data of each row
while($row = $result->fetch_assoc()) {
echo "
| KENDİSİ |
" . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
$sqlcocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
$resultcocugu = $baglanti->query($sqlcocugu);
$sqlkardesi = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["BABATC"] ."' OR `ANNETC` = '" . $row["ANNETC"] ."' ) ";
$resultkardesi = $baglanti->query($sqlkardesi);
$sqlbabasi = "SELECT * FROM `101m` WHERE `TC` = '" . $row["BABATC"] ."' ";
$resultbabasi = $baglanti->query($sqlbabasi);
$sqlanasi = "SELECT * FROM `101m` WHERE `TC` = '" . $row["ANNETC"] ."' ";
$resultanasi = $baglanti->query($sqlanasi);
$sqlkendicocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
$resultkendicocugu = $baglanti->query($sqlkendicocugu);
while($row = $resultkendicocugu->fetch_assoc()) {
echo "
| ÇOCUĞU |
" . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
$sqlkendikendicocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
$resultkendikendicocugu = $baglanti->query($sqlkendikendicocugu);
while($row = $resultkendikendicocugu->fetch_assoc()) {
echo "
| TORUNU |
" . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
while($row = $resultkardesi->fetch_assoc()) {
echo "
| KARDEŞİ |
" . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
while($row = $resultanasi->fetch_assoc()) {
echo "
| ANNESİ>
| " . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
}
}
}
while($row = $resultbabasi->fetch_assoc()) {
echo "
| BABASI |
" . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
$sqlbabakardesi = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["BABATC"] ."' OR `ANNETC` = '" . $row["ANNETC"] ."' ) ";
$resultbabakardesi = $baglanti->query($sqlbabakardesi);
$sqlbabababasi = "SELECT * FROM `101m` WHERE `TC` = '" . $row["BABATC"] ."' ";
$resultbabababasi = $baglanti->query($sqlbabababasi);
$sqlbabaanasi = "SELECT * FROM `101m` WHERE `TC` = '" . $row["ANNETC"] ."' ";
$resultbabaanasi = $baglanti->query($sqlbabaanasi);
}
while($row = $resultanasi->fetch_assoc()) {
echo "
| Annesi |
" . $row["TC"] . " |
" . $row["ADI"] . " |
" . $row["SOYADI"] . " |
" . $row["DOGUMTARIHI"] . " |
" . $row["ANNEADI"] . " |
" . $row["ANNETC"] . " |
" . $row["BABAADI"] . " |
" . $row["BABATC"] . " |
" . $row["NUFUSIL"] . " |
" . $row["NUFUSILCE"] . " |
" . $row["UYRUK"] . " |
";
$sqlannekardesi = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["BABATC"] ."' OR `ANNETC` = '" . $row["ANNETC"] ."' ) ";
$resultannekardesi = $baglanti->query($sqlannekardesi);
$sqlannebabasi = "SELECT * FROM `101m` WHERE `TC` = '" . $row["BABATC"] ."' ";
$resultannebabasi = $baglanti->query($sqlannebabasi);
$sqlanneanasi = "SELECT * FROM `101m` WHERE `TC` = '" . $row["ANNETC"] ."' ";
$resultanneanasi = $baglanti->query($sqlanneanasi);
}
}
}
}
?>