<?php

// GET request
if (isset($_GET['data'])){
    $data = $_GET['data'];
}
else{
    echo "Data not received";
}


$servername = "mysql.hostinger.web.tr";
$username = "u880793433_admin";
$password = "huloog";
$dbname = "u880793433_test";
$fname = "";
$lname = "";
$num = "";
$in_time = date('Y-m-d H:i:s');
$out_time;

$mysqli = new mysqli($servername, $username, $password, $dbname);

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

if ($result = $mysqli->query("SELECT * FROM ogr_List WHERE ID = '".$data."'")) {

    while ($row = $result->fetch_row()) {
        $num = row[1];
        $fname = row[2];
        $lname = row[3];
    }

    //$sql_INSERT= "INSERT INTO log (NUM, FNAME, LNAME) VALUES ( '".$num."' , '".$fname."' , '".$lname."' , '".$in_time."' ) WHERE  ID = '".$data."'";

    $mysqli->query("INSERT INTO log (NUM, FNAME, LNAME, IN) VALUES ( '".$num."' , '".$fname."', '".$lname."' , '".$in_time."' )");
    $return_Result = $mysqli->query("SELECT ID FROM log WHERE IN = '".$in_time."'" );

    if ($return_Result != NULL)
    {
        while($return_Row = $return_Result->fetch_assoc())
        {
            echo "<". $return_Row["ID"].">";
        }
    }

    else {
        echo "0 results";
    }

$mysqli->close();
}

?>