- <?php
- $customCSS = array(
- '<link href="../assets/plugins/DataTables/datatables.min.css" rel="stylesheet">',
- '<link href="../assets/plugins/DataTables/style.css" rel="stylesheet">'
- );
- $customJAVA = array(
- '<script src="../assets/plugins/DataTables/datatables.min.js"></script>',
- '<script src="../assets/plugins/printer/main.js"></script>',
- '<script src="../assets/js/pages/datatables.js"></script>'
- );
- include('inc/header_main.php');
- include('inc/header_sidebar.php');
- include('inc/header_native.php');
- ?>
- <!--<div class="page-content">-->
- <!--BAŞLANGIC-->
- <style>
- body{
- background-image: url("https://images-ext-2.discordapp.net/external/kQnF9Sfl4ujwpQa9ODb4Ng6ygO0TVZq46vaG3hIKiho/https/p4.wallpaperbetter.com/wallpaper/510/711/710/ramadan-purple-evening-4k-8k-wallpaper-preview.jpg");
- -webkit-background-size: cover;
- -moz-background-size: cover;
- -o-background-size: cover;
- background-size: cover;
- }
- </style>
- <div class="arama">
- <form method="post">
- <div class="card">
- <div class="card-body">
- <h4 class="card-title mb-4">Soyağacı Sorgu</h4>
- <p class="mb-1">
- <p>
- Soyağacını görüntüleyeceğiniz kişinin KİMLİK NUMARAsını giriniz.</br>
- </p>
- </p>
- <div class="block-content tab-content">
- <div class="tab-pane active" id="tc" role="tabpanel">
- <input class="form-control" type="text" name="ad" placeholder="TC"><br
- </div>
- <center class="nw">
- <button onclick="checkNumber()" id="sorgula" name="ara" class="btn waves-effect waves-light btn-rounded btn-primary" style="width: 180px; height: 45px; outline: none; margin-left: 5px;"><i class="fas fa-search"></i> Sorgula <span id="sorgulanumber"></span></button>
- <button onclick="clearAll()" id="durdurButon" type="button" class="btn waves-effect waves-light btn-rounded btn-danger" style="width: 180px; height: 45px; outline: none; margin-left: 5px;"><i class="fas fa-trash-alt"></i> Sıfırla </button>
- </form>
- </div>
- <table id="zero-conf" class="table table-hover" style="width:100%">
- <thead>
- <tr>
- <th>Yakınlık</th>
- <th>TCKN</th>
- <th>Adı</th>
- <th>Soyadı</th>
- <th>Doğum Günü</th>
- <th>Anne Adı</th>
- <th>Anne TCKN</th>
- <th>Baba Adı</th>
- <th>Baba TCKN</th>
- <th>İkametgah İl</th>
- <th>İkametgah İlçe</th>
- <th>Uyruk</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $baglanti = new mysqli('localhost', 'root', '', '101m');
- if (isset($_POST["ara"])) {
- $str = $_POST["ad"];
- $sth = $baglanti->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 "<tr>
- <td> KENDİSİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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 "<tr>
- <td> ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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 "<tr>
- <td> TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlkendikendikendicocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultkendikendikendicocugu = $baglanti->query($sqlkendikendikendicocugu);
- while($row = $resultkendikendikendicocugu->fetch_assoc()) {
- echo "<tr>
- <td> TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- while($row = $resultkardesi->fetch_assoc()) {
- echo "<tr>
- <td> KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlkardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultkardescocugu = $baglanti->query($sqlkardescocugu);
- while($row = $resultkardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlkardeskardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultkardeskardescocugu = $baglanti->query($sqlkardeskardescocugu);
- while($row = $resultkardeskardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlkardeskardeskardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultkardeskardeskardescocugu = $baglanti->query($sqlkardeskardeskardescocugu);
- while($row = $resultkardeskardeskardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultbabasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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 = $resultbabakardesi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabakardescocugu = $baglanti->query($sqlbabakardescocugu);
- while($row = $resultbabakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabakardesbabakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabakardesbabakardescocugu = $baglanti->query($sqlbabakardesbabakardescocugu);
- while($row = $resultbabakardesbabakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabakardesbabakardesbabakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabakardesbabakardesbabakardescocugu = $baglanti->query($sqlbabakardesbabakardesbabakardescocugu);
- while($row = $resultbabakardesbabakardesbabakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultbabababasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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 = $resultbabakardesi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASININ KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabababakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabababakardescocugu = $baglanti->query($sqlbabababakardescocugu);
- while($row = $resultbabababakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASININ KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabababakardesbabababakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabababakardesbabababakardescocugu = $baglanti->query($sqlbabababakardesbabababakardescocugu);
- while($row = $resultbabababakardesbabababakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASININ KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabababakardesbabababakardesbabababakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabababakardesbabababakardesbabababakardescocugu = $baglanti->query($sqlbabababakardesbabababakardesbabababakardescocugu);
- while($row = $resultbabababakardesbabababakardesbabababakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASININ KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultbabababasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASININ BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- while($row = $resultbabaanasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ BABASININ ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- while($row = $resultbabaanasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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 = $resultbabakardesi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANNESİNİN KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabaannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabaannekardescocugu = $baglanti->query($sqlbabaannekardescocugu);
- while($row = $resultbabaannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANNESİNİN KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabaannekardesbabaannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabaannekardesbabaannekardescocugu = $baglanti->query($sqlbabaannekardesbabaannekardescocugu);
- while($row = $resultbabaannekardesbabaannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANNESİNİN KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlbabaannekardesbabaannekardesbabaannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultbabaannekardesbabaannekardesbabaannekardescocugu = $baglanti->query($sqlbabaannekardesbabaannekardesbabaannekardescocugu);
- while($row = $resultbabaannekardesbabaannekardesbabaannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANNESİNİN KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultbabababasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANNESİNİN BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- while($row = $resultbabaanasi->fetch_assoc()) {
- echo "<tr>
- <td> BABASININ ANNESİNİN ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultanasi->fetch_assoc()) {
- echo "<tr>
- <td> ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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);
- while($row = $resultannekardesi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlannekardescocugu = "SELECT * FROM `101m` WHERE `BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ";
- $resultannekardescocugu = $baglanti->query($sqlannekardescocugu);
- while($row = $resultannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlannekardesannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultannekardesannekardescocugu = $baglanti->query($sqlannekardesannekardescocugu);
- while($row = $resultannekardesannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlannekardesannekardesannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultannekardesannekardesannekardescocugu = $baglanti->query($sqlannekardesannekardesannekardescocugu);
- while($row = $resultannekardesannekardesannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultannebabasi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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 = $resultbabakardesi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASININ KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlannebabakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultannebabakardescocugu = $baglanti->query($sqlannebabakardescocugu);
- while($row = $resultannebabakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASININ KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlannebabakardesannebabakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultannebabakardesannebabakardescocugu = $baglanti->query($sqlannebabakardesannebabakardescocugu);
- while($row = $resultannebabakardesannebabakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASININ KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlannebabakardesannebabakardesannebabakardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultannebabakardesannebabakardesannebabakardescocugu = $baglanti->query($sqlannebabakardesannebabakardesannebabakardescocugu);
- while($row = $resultannebabakardesannebabakardesannebabakardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASININ KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultbabababasi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASININ BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- while($row = $resultbabaanasi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN BABASININ ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- while($row = $resultanneanasi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $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);
- while($row = $resultannekardesi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN KARDEŞİ </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlanneannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultanneannekardescocugu = $baglanti->query($sqlanneannekardescocugu);
- while($row = $resultanneannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN KARDEŞİNİN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlanneannekardesanneannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultanneannekardesanneannekardescocugu = $baglanti->query($sqlanneannekardesanneannekardescocugu);
- while($row = $resultanneannekardesanneannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN KARDEŞİNİN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlanneannekardesanneannekardesanneannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultanneannekardesanneannekardesanneannekardescocugu = $baglanti->query($sqlanneannekardesanneannekardesanneannekardescocugu);
- while($row = $resultanneannekardesanneannekardesanneannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN KARDEŞİNİN TORUNUNUN ÇOCUĞU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- $sqlanneannekardesanneannekardesanneannekardesanneannekardescocugu = "SELECT * FROM `101m` WHERE NOT `TC` = '". $row["TC"] ."' AND (`BABATC` = '" . $row["TC"] ."' OR `ANNETC` = '" . $row["TC"] ."' ) ";
- $resultanneannekardesanneannekardesanneannekardesanneannekardescocugu = $baglanti->query($sqlanneannekardesanneannekardesanneannekardesanneannekardescocugu);
- while($row = $resultanneannekardesanneannekardesanneannekardesanneannekardescocugu->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN KARDEŞİNİN TORUNUNUN TORUNU </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- while($row = $resultannebabasi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN BABASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- while($row = $resultanneanasi->fetch_assoc()) {
- echo "<tr>
- <td> ANNESİNİN ANNESİNİN ANASI </td>
- <td>" . $row["TC"] . "</td>
- <td>" . $row["ADI"] . "</td>
- <td>" . $row["SOYADI"] . "</td>
- <td>" . $row["DOGUMTARIHI"] . "</td>
- <td>" . $row["ANNEADI"] . "</td>
- <td>" . $row["ANNETC"] . "</td>
- <td>" . $row["BABAADI"] . "</td>
- <td>" . $row["BABATC"] . "</td>
- <td>" . $row["NUFUSIL"] . "</td>
- <td>" . $row["NUFUSILCE"] . "</td>
- <td>" . $row["UYRUK"] . "</td>
- </tr>";
- }
- }
- }
- }
- }
- ?>
- </tbody>
- </table>
- <?php
- include('inc/footer_native.php');
- include('inc/footer_main.php');
- ?>