<?php
// Initialize the session
error_reporting(E_ERROR | E_PARSE);
$response = array();
$ff;
// Check if the user is already logged in, if yes then redirect him to welcome page

// Include config file
require_once "config.php";
 
// Define variables and initialize with empty values

 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "GET"){
   // Check if username is empty
    if(empty(trim($_GET["IMEI"]))){
        $response["loggedin"] = 0;
        $response["ERORR"] = "Please enter IMEI.";
       //IN  $biketype=trim($_GET["biketype"]);
        
        
    } 
    else{
        $IMEI = trim($_GET["IMEI"]);
         $ICCID = trim($_GET["ICCID"]);
         $VERSION = trim($_GET["VERSION"]);
         //VERSION
    if(($IMEI) && ($ICCID) )
    {
        
        
        
        
        
        // Prepare a select statement
            $sql = "SELECT * FROM devices WHERE imei=$IMEI"; //SELECT `datajson` 
            
            $result = $link->query($sql);
            if(mysqli_num_rows($result) > 0)
            {
              // output data of each row
              while($row = $result->fetch_assoc()) 
              {
              //$response[] =  ($row); 
              //$response1["imei"]=$row['imei'] ;
              $response1["port"]=$row['port'] ;
              $response1["server"]=$row['server'] ;
              //$response1["imsi"]=$row['imsi'] ;
              $ICCID_PR=$row['ICCID'] ;
              $response1["status"]=$row['status'] ;
              //$response1["change"]=$row['change'] ;
                 $response1["ssid"]=$row['ssid'] ;
              //$response1["imsi"]=$row['imsi'] ;
              $ICCID_PR=$row['ICCID'] ;
              $response1["password"]=$row['password'] ;
              
              $response["loggedin"] = 1;
              
              $te_ver=((float)  $VERSION);
              $te_ota=((float)  $row['VERSION']);
               if($te_ver >= $te_ota)
               {
                $response1["ota"] = 0;
               }
               else
               {
                   
                      $response1["ota"] = 1 ;
                     //UPDATE `devices` SET `device_version`= 1.23 WHERE `imei`= "862430056367770" ; 
            //  $sql = "UPDATE `devices` SET  `device_version`= $VERSION WHERE imei= $IMEI"; //SELECT `datajson` 
            
         $sql3 =   "UPDATE `devices` SET `device_version`=$VERSION WHERE `imei`=$IMEI" ;
         $response1["sql"] = $sql3;
        //  $result = $link->query($sql3);
         
               }
              
              }
              if(($ICCID_PR==$ICCID) )
              {
                 $response=$response1; 
                 
                   $response["loggedin"] = 1;
                  
              }
                    else
            {
                    
                $response["loggedin"] = 2;
                $response["ERORR"] = "Please try again wrong1.";
                    
            }
              
              
              
            }
            else
            {
                    
                $response["loggedin"] = 3;
                $response["ERORR"] = "Please try again wrong.";
                    
            }

    }
    
    else
    {
        $response["loggedin"] = 4        ;
        $response["ERORR"] = "Oops! Something went wrong. Please try again later.";
    }
    }
    

   //($username) && ($password)
   
    // Close connection
    mysqli_close($link);
}

echo ('[');
 echo json_encode($response);
 echo (']');
?>