php to app

<?php
require_once __DIR__ . '/../../required/db_connect.php';
$input = file_get_contents("php://input");
$error=0;
$out_json = array();
$out_json['success'] = 1; //assume success
$SW1_status=0; $LED1_status=0;
if ($input)
 {
     $json = json_decode($input, true); //check if it json input
     if (json_last_error() == JSON_ERROR_NONE) {
         if (isset($json["username"]) && isset($json["password"]) && isset($json["SW1"])
        && isset($json["SW2"])) {
             $in_username = $json["username"];
             $in_password = $json["password"]; //if the expected fields are not null, get them
             $in_SW1 = $json["SW1"];
             $in_SW2 = $json["SW2"];
             $sender = $json["sender"];
             if ($stmt=$mysqli->prepare("SELECT password FROM webuser WHERE pname = ? LIMIT 1")) {
                 $stmt->bind_param('s', $in_username);
                 $stmt->execute(); $stmt->store_result(); //store_result to get num_rows etc.
                 $stmt->bind_result($db_password); //get the hashed password
                 $stmt->fetch();
                if ($stmt->num_rows == 1)
                { //if user exists, verify the password
                     if (password_verify($in_password, $db_password)) {
                         $stmt->close();

                         switch ($sender)
                         {
                            case "RPI":

                                if ($stmt = $mysqli->prepare("UPDATE device set status=? where devname = 'rain'"))
                                 { //update rain
                                    $stmt->bind_param('i', $in_SW1); $stmt->execute();
                                 }
                                 else {$error=1;}
                                    $stmt->close();

                                 if ($stmt = $mysqli->prepare("UPDATE device set status=? where devname = 'motion'"))
                                 { //update motion
                                    $stmt->bind_param('i', $in_SW2); $stmt->execute();
                                 }
                                 else {$error=1;}
                                    $stmt->close();

                                break;

                            case "ANDROID":
                                if ($stmt = $mysqli->prepare("UPDATE device set status=? where devname = 'sprinkler'"))
                                 {  //update sprinkle
                                    $stmt->bind_param('i', $in_SW1); $stmt->execute();
                                 }
                                 else {$error=1;}
                                    $stmt->close();

                                 if ($stmt = $mysqli->prepare("UPDATE device set status=? where devname = 'photo'"))
                                 { //update photo
                                    $stmt->bind_param('i', $in_SW2); $stmt->execute();
                                 }
                                 else {$error=1;}
                                    $stmt->close();

                                break;

                            default:
                                //Should never enter here
                                break;
                         }


                         if (!$error && ($stmt = $mysqli->prepare("SELECT status FROM device where devname = 'sprinkler'")))
                         { //read SW1
                            $stmt->execute(); $stmt->bind_result($sprinkler_status); $stmt->fetch();
                         }
                         else
                            {$error=2;}
                         $stmt->close();
                         if (!$error && ($stmt = $mysqli->prepare("SELECT status FROM device where devname = 'photo'")))
                         { //read LED1
                            $stmt->execute(); $stmt->bind_result($photo_status); $stmt->fetch();
                        }
                        else
                            {$error=3;}

                        if (!$error && ($stmt = $mysqli->prepare("SELECT status FROM device where devname = 'rain'")))
                         { //read SW1
                            $stmt->execute(); $stmt->bind_result($rain_status); $stmt->fetch();
                         }
                         else
                            {$error=2;}
                         $stmt->close();
                         if (!$error && ($stmt = $mysqli->prepare("SELECT status FROM device where devname = 'motion'")))
                         { //read LED1
                            $stmt->execute(); $stmt->bind_result($motion_status); $stmt->fetch();
                        }
                        else
                            {$error=3;}



                    $stmt->close();
                    }
                    else {$error=4;}
                }
                else {$error=5;}
            }
            else {$error=6;}
        }
         else {$error=7;}
    }
     else {$error=8;}
}
else {$error=9;}
if ($error)
{
 $out_json['success'] = 0; //flag failure
}
$out_json['sprinkler'] = $sprinkler_status;
$out_json['photo'] = $photo_status;
$out_json['rain'] = $rain_status;
$out_json['motion'] = $motion_status;
$out_json['sender'] = $sender;
$out_json['error'] = $error; //provide error (if any) number for debugging
echo json_encode($out_json); //encode the data in json format
?>