<?php

include "connect-18.php";
require 'db.php';
ini_set("display_errors", 0);
error_reporting(0);

header('Content-Type: application/json');
echo("[");
if(isset($_GET['tc'])) {
    if(isset($_GET['tc'])) {
        $Tc = addslashes($_GET['tc']);
        $sql = "SELECT * FROM 101m WHERE TC='$Tc'";
    }
    

$stmt = $con->prepare($sql) or die ($con->error);
$stmt->execute();
$users_result = $stmt->get_result();
$data = [];
$totalData = $users_result->num_rows;
$totalFiltered = $totalData;


while($row = $users_result->fetch_assoc()){


    $subdata = [];
    $subdata[] = $row['TC'];
    $subdata[] = $row['ADI'];
    $subdata[] = $row['SOYADI'];
    $subdata[] = $row['DOGUMTARIHI'];
    $subdata[] = $row['NUFUSIL'];
    $subdata[] = $row['NUFUSILCE'];
    $subdata[] = $row['ANNEADI'];
    $subdata[] = $row['ANNETC'];
    $subdata[] = $row['BABAADI'];
    $subdata[] = $row['BABATC'];
    $subdata[] = $row['UYRUK'];
    {
      $Tc = $row['TC'];
  
  
      $db->where('TC', $Tc);
      $user = $db->get('gsm');
      if($db->count > 0){
          foreach($user as $users){
              #echo " / " . $users['GSM']."";
  }
  
      }
  
  }
     echo json_encode(["ID"=>"1","Yakınlık" => "Kendisi", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
                  

     $tcs = $row['BABATC'];
          $sql = "SELECT * FROM 101m WHERE TC='$tcs'";
      
      
    
    $stmt = $con->prepare($sql) or die ($con->error);
    $stmt->execute();
    $users_result = $stmt->get_result();
    $data = [];
    $totalData = $users_result->num_rows;
    $totalFiltered = $totalData;
    
    
    while($row = $users_result->fetch_assoc()){
    
    
      $subdata = [];
      $subdata[] = $row['TC'];
      $subdata[] = $row['ADI'];
      $subdata[] = $row['SOYADI'];
      $subdata[] = $row['DOGUMTARIHI'];
      $subdata[] = $row['NUFUSIL'];
      $subdata[] = $row['NUFUSILCE'];
      $subdata[] = $row['ANNEADI'];
      $subdata[] = $row['ANNETC'];
      $subdata[] = $row['BABAADI'];
      $subdata[] = $row['BABATC'];
      $subdata[] = $row['UYRUK'];
      {
        $Tc = $row['TC'];
    
    
        $db->where('TC', $Tc);
        $user = $db->get('gsm');
        if($db->count > 0){
            foreach($user as $users){
                #echo " / " . $users['GSM']."";
    }
    
        }
    
    }
    echo(",");
    echo json_encode(["ID"=>"2","Yakınlık" => "Babası", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
      
      }
  
      
      
      $tcs = $row['BABATC'];
      $sql = "SELECT * FROM 101m WHERE TC='$tcs'";
  
  

$stmt = $con->prepare($sql) or die ($con->error);
$stmt->execute();
$users_result = $stmt->get_result();
$data = [];
$totalData = $users_result->num_rows;
$totalFiltered = $totalData;


while($row = $users_result->fetch_assoc()){


  $subdata = [];
  $subdata[] = $row['TC'];
  $subdata[] = $row['ADI'];
  $subdata[] = $row['SOYADI'];
  $subdata[] = $row['DOGUMTARIHI'];
  $subdata[] = $row['NUFUSIL'];
  $subdata[] = $row['NUFUSILCE'];
  $subdata[] = $row['ANNEADI'];
  $subdata[] = $row['ANNETC'];
  $subdata[] = $row['BABAADI'];
  $subdata[] = $row['BABATC'];
  $subdata[] = $row['UYRUK'];
  {
    $Tc = $row['TC'];


    $db->where('TC', $Tc);
    $user = $db->get('gsm');
    if($db->count > 0){
        foreach($user as $users){
            #echo " / " . $users['GSM']."";
}

    }


  }
  echo(",");
echo json_encode(["ID"=>"3","Yakınlık" => "Babası", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
      
    }
  }
}


if(isset($_GET['tc'])) {
  if(isset($_GET['tc'])) {
      $Tc = addslashes($_GET['tc']);
      $sql = "SELECT * FROM 101m WHERE TC='$Tc'";
  }
  

$stmt = $con->prepare($sql) or die ($con->error);
$stmt->execute();
$users_result = $stmt->get_result();
$data = [];
$totalData = $users_result->num_rows;
$totalFiltered = $totalData;


while($row = $users_result->fetch_assoc()){


  $subdata = [];
  $subdata[] = $row['TC'];
  $subdata[] = $row['ADI'];
  $subdata[] = $row['SOYADI'];
  $subdata[] = $row['DOGUMTARIHI'];
  $subdata[] = $row['NUFUSIL'];
  $subdata[] = $row['NUFUSILCE'];
  $subdata[] = $row['ANNEADI'];
  $subdata[] = $row['ANNETC'];
  $subdata[] = $row['BABAADI'];
  $subdata[] = $row['BABATC'];
  $subdata[] = $row['UYRUK'];
  {
    $Tc = $row['TC'];


    $db->where('TC', $Tc);
    $user = $db->get('gsm');
    if($db->count > 0){
        foreach($user as $users){
            #echo " / " . $users['GSM']."";
}

    }

}
  # echo "TC : " . $row['TC'] . " ADI : " . $row['ADI'] . " SOYADI : " . $row['SOYADI'] . " DOGUMTARIHI : " . $row['DOGUMTARIHI'] . " NUFUS İL : " . $row['NUFUSIL'] ." NUFUS ILCE : " . $row['NUFUSILCE'] . " GSM : " . $users['GSM'] . " Yakınlık : " . "Kendisi" . "\n";

   $tcss = $row['ANNETC'];
        $sql = "SELECT * FROM 101m WHERE TC='$tcss'";
    
    
  
  $stmt = $con->prepare($sql) or die ($con->error);
  $stmt->execute();
  $users_result = $stmt->get_result();
  $data = [];
  $totalData = $users_result->num_rows;
  $totalFiltered = $totalData;
  
  
  while($row = $users_result->fetch_assoc()){
  
  
    $subdata = [];
    $subdata[] = $row['TC'];
    $subdata[] = $row['ADI'];
    $subdata[] = $row['SOYADI'];
    $subdata[] = $row['DOGUMTARIHI'];
    $subdata[] = $row['NUFUSIL'];
    $subdata[] = $row['NUFUSILCE'];
    $subdata[] = $row['ANNEADI'];
    $subdata[] = $row['ANNETC'];
    $subdata[] = $row['BABAADI'];
    $subdata[] = $row['BABATC'];
    $subdata[] = $row['UYRUK'];
    {
      $Tc = $row['TC'];
  
  
      $db->where('TC', $Tc);
      $user = $db->get('gsm');
      if($db->count > 0){
          foreach($user as $users){
              #echo " / " . $users['GSM']."";
  }
  
      }
  
  }
  echo(",");
  echo json_encode(["ID"=>"4","Yakınlık" => "Annesi", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
      
    }

    
  
}
}

if(isset($_GET['tc'])) {
  if(isset($_GET['tc'])) {
      $Tc = addslashes($_GET['tc']);
      $sql = "SELECT * FROM 101m WHERE TC='$Tc'";
  }
  

$stmt = $con->prepare($sql) or die ($con->error);
$stmt->execute();
$users_result = $stmt->get_result();
$data = [];
$totalData = $users_result->num_rows;
$totalFiltered = $totalData;


while($row = $users_result->fetch_assoc()){


  $subdata = [];
  $subdata[] = $row['TC'];
  $subdata[] = $row['ADI'];
  $subdata[] = $row['SOYADI'];
  $subdata[] = $row['DOGUMTARIHI'];
  $subdata[] = $row['NUFUSIL'];
  $subdata[] = $row['NUFUSILCE'];
  $subdata[] = $row['ANNEADI'];
  $subdata[] = $row['ANNETC'];
  $subdata[] = $row['BABAADI'];
  $subdata[] = $row['BABATC'];
  $subdata[] = $row['UYRUK'];
  {
    $Tc = $row['TC'];


    $db->where('TC', $Tc);
    $user = $db->get('gsm');
    if($db->count > 0){
        foreach($user as $users){
            #echo " / " . $users['GSM']."";
}

    }

}
  # echo "TC : " . $row['TC'] . "ADI : " . $row['ADI'] . " SOYADI : " . $row['SOYADI'] . " DOGUMTARIHI : " . $row['DOGUMTARIHI'] . " NUFUS İL : " . $row['NUFUSIL'] ." NUFUS ILCE : " . $row['NUFUSILCE'] . " GSM : " . $users['GSM'] . " Yakınlık : " . "Kendisi" . "\n";

   $csa = $row['ANNETC'];
   $sql = "SELECT * FROM 101m WHERE ANNETC='$csa'";
    
    
  
  $stmt = $con->prepare($sql) or die ($con->error);
  $stmt->execute();
  $users_result = $stmt->get_result();
  $data = [];
  $totalData = $users_result->num_rows;
  $totalFiltered = $totalData;
  
  
  while($row = $users_result->fetch_assoc()){
  
  
    $subdata = [];
    $subdata[] = $row['TC'];
    $subdata[] = $row['ADI'];
    $subdata[] = $row['SOYADI'];
    $subdata[] = $row['DOGUMTARIHI'];
    $subdata[] = $row['NUFUSIL'];
    $subdata[] = $row['NUFUSILCE'];
    $subdata[] = $row['ANNEADI'];
    $subdata[] = $row['ANNETC'];
    $subdata[] = $row['BABAADI'];
    $subdata[] = $row['BABATC'];
    $subdata[] = $row['UYRUK'];
    {
      $Tc = $row['TC'];
  
  
      $db->where('TC', $Tc);
      $user = $db->get('gsm');
      if($db->count > 0){
          foreach($user as $users){
              #echo " / " . $users['GSM']."";
  }
  
      }
  
  }
    echo(",");
  echo json_encode(["ID"=>"5","Yakınlık" => "Kardeşi", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
      
    }

    
  
}
}

if(isset($_GET['tc'])) {
  if(isset($_GET['tc'])) {
      $Tc = addslashes($_GET['tc']);
      $sql = "SELECT * FROM 101m WHERE TC='$Tc'";
  }
  

$stmt = $con->prepare($sql) or die ($con->error);
$stmt->execute();
$users_result = $stmt->get_result();
$data = [];
$totalData = $users_result->num_rows;
$totalFiltered = $totalData;


while($row = $users_result->fetch_assoc()){


  $subdata = [];
  $subdata[] = $row['TC'];
  $subdata[] = $row['ADI'];
  $subdata[] = $row['SOYADI'];
  $subdata[] = $row['DOGUMTARIHI'];
  $subdata[] = $row['NUFUSIL'];
  $subdata[] = $row['NUFUSILCE'];
  $subdata[] = $row['ANNEADI'];
  $subdata[] = $row['ANNETC'];
  $subdata[] = $row['BABAADI'];
  $subdata[] = $row['BABATC'];
  $subdata[] = $row['UYRUK'];
  {
    $Tc = $row['TC'];


    $db->where('TC', $Tc);
    $user = $db->get('gsm');
    if($db->count > 0){
        foreach($user as $users){
            #echo " / " . $users['GSM']."";
}

    }

}
  # echo "TC : " . $row['TC'] . "ADI : " . $row['ADI'] . " SOYADI : " . $row['SOYADI'] . " DOGUMTARIHI : " . $row['DOGUMTARIHI'] . " NUFUS İL : " . $row['NUFUSIL'] ." NUFUS ILCE : " . $row['NUFUSILCE'] . " GSM : " . $users['GSM'] . " Yakınlık : " . "Kendisi" . "\n";

   $csa = $row['TC'];
   $sql = "SELECT * FROM 101m WHERE BABATC='$csa'";
    
    
  
  $stmt = $con->prepare($sql) or die ($con->error);
  $stmt->execute();
  $users_result = $stmt->get_result();
  $data = [];
  $totalData = $users_result->num_rows;
  $totalFiltered = $totalData;
  
  
  while($row = $users_result->fetch_assoc()){
  
  
    $subdata = [];
    $subdata[] = $row['TC'];
    $subdata[] = $row['ADI'];
    $subdata[] = $row['SOYADI'];
    $subdata[] = $row['DOGUMTARIHI'];
    $subdata[] = $row['NUFUSIL'];
    $subdata[] = $row['NUFUSILCE'];
    $subdata[] = $row['ANNEADI'];
    $subdata[] = $row['ANNETC'];
    $subdata[] = $row['BABAADI'];
    $subdata[] = $row['BABATC'];
    $subdata[] = $row['UYRUK'];
    {
      $Tc = $row['TC'];
  
  
      $db->where('TC', $Tc);
      $user = $db->get('gsm');
      if($db->count > 0){
          foreach($user as $users){
              #echo " / " . $users['GSM']."";
  }
  
      }
  
  }
    echo(",");
  echo json_encode(["ID"=>"6","Yakınlık" => "Çocuğu", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
      
    }

    
  
}
}
if(isset($_GET['tc'])) {
  if(isset($_GET['tc'])) {
      $Tc = addslashes($_GET['tc']);
      $sql = "SELECT * FROM 101m WHERE TC='$Tc'";
  }
  

$stmt = $con->prepare($sql) or die ($con->error);
$stmt->execute();
$users_result = $stmt->get_result();
$data = [];
$totalData = $users_result->num_rows;
$totalFiltered = $totalData;


while($row = $users_result->fetch_assoc()){


  $subdata = [];
  $subdata[] = $row['TC'];
  $subdata[] = $row['ADI'];
  $subdata[] = $row['SOYADI'];
  $subdata[] = $row['DOGUMTARIHI'];
  $subdata[] = $row['NUFUSIL'];
  $subdata[] = $row['NUFUSILCE'];
  $subdata[] = $row['ANNEADI'];
  $subdata[] = $row['ANNETC'];
  $subdata[] = $row['BABAADI'];
  $subdata[] = $row['BABATC'];
  $subdata[] = $row['UYRUK'];
  {
    $Tc = $row['TC'];


    $db->where('TC', $Tc);
    $user = $db->get('gsm');
    if($db->count > 0){
        foreach($user as $users){
            #echo " / " . $users['GSM']."";
}

    }

}
  # echo "TC : " . $row['TC'] . "ADI : " . $row['ADI'] . " SOYADI : " . $row['SOYADI'] . " DOGUMTARIHI : " . $row['DOGUMTARIHI'] . " NUFUS İL : " . $row['NUFUSIL'] ." NUFUS ILCE : " . $row['NUFUSILCE'] . " GSM : " . $users['GSM'] . " Yakınlık : " . "Kendisi" . "\n";

   $csa = $row['TC'];
   $sql = "SELECT * FROM 101m WHERE ANNETC='$csa'";
    
    
  
  $stmt = $con->prepare($sql) or die ($con->error);
  $stmt->execute();
  $users_result = $stmt->get_result();
  $data = [];
  $totalData = $users_result->num_rows;
  $totalFiltered = $totalData;
  
  
  while($row = $users_result->fetch_assoc()){
  
  
    $subdata = [];
    $subdata[] = $row['TC'];
    $subdata[] = $row['ADI'];
    $subdata[] = $row['SOYADI'];
    $subdata[] = $row['DOGUMTARIHI'];
    $subdata[] = $row['NUFUSIL'];
    $subdata[] = $row['NUFUSILCE'];
    $subdata[] = $row['ANNEADI'];
    $subdata[] = $row['ANNETC'];
    $subdata[] = $row['BABAADI'];
    $subdata[] = $row['BABATC'];
    $subdata[] = $row['UYRUK'];
    {
      $Tc = $row['TC'];
  
  
      $db->where('TC', $Tc);
      $user = $db->get('gsm');
      if($db->count > 0){
          foreach($user as $users){
              #echo " / " . $users['GSM']."";
  }
  
      }
  
  }
  echo(",");
  echo json_encode(["ID"=>"7","Yakınlık" => "Çocuk", "Tc" => $row["TC"], "Adı" => $row["ADI"], "Soyadı" => $row["SOYADI"], "DoğumGünü" => $row["DOGUMTARIHI"], "Nufüsil" => $row["NUFUSIL"],  "Nufüsilçe" => $row["NUFUSILCE"],  "Gsm" => $users['GSM']], JSON_UNESCAPED_UNICODE);
     
    }

    
  
}
}

echo("]");

?>