<?php
include "connect-18.php";
require 'db.php';
ini_set("display_errors", 0);
error_reporting(0);

header('Content-Type: application/json');
$response = [];

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();
    $totalData = $users_result->num_rows;

    while($row = $users_result->fetch_assoc()){
        $data = [
            "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"]
        ];

        $Tc = $row['TC'];
        $db->where('TC', $Tc);
        $user = $db->get('gsm');
        
        if($db->count > 0){
            foreach($user as $users){
                $data["Gsm"] = $users['GSM'];
            }
        }

        $response[] = $data;
    }
}

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();
    $totalData = $users_result->num_rows;

    while($row = $users_result->fetch_assoc()){
        $data = [
            "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"]
        ];

        $Tc = $row['TC'];
        $db->where('TC', $Tc);
        $user = $db->get('gsm');
        
        if($db->count > 0){
            foreach($user as $users){
                $data["Gsm"] = $users['GSM'];
            }
        }

        $response[] = $data;
    }
}

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();
    $totalData = $users_result->num_rows;

    while($row = $users_result->fetch_assoc()){
        $data = [
            "ID" => "3",
            "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"]
        ];

        $Tc = $row['TC'];
        $db->where('TC', $Tc);
        $user = $db->get('gsm');
        
        if($db->count > 0){
            foreach($user as $users){
                $data["Gsm"] = $users['GSM'];
            }
        }

        $response[] = $data;
    }
}

echo json_encode($response);
?>