<?php
            if((isset($_REQUEST["ID"]))&&(isset($_REQUEST["Status"]))){
            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "arduino_test";

            $jsonarray= array('Status' => false,'Message'=>"Empty" );
            // Create connection
            $conn = new mysqli($servername, $username, $password, $dbname);
            // Check connection
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
                $jsonarray= array('Status' => false,'Message'=>"Database Not Connected" );
                echo json_encode($jsonarray);

            }
            else{
                $jsonarray= array('Status'=>false,'Message'=>"Database connected" );

                $sql = "SELECT * FROM `lights` WHERE ID=".$_REQUEST["ID"]."";
                //$result = $conn->query($sql);
                $result = $conn->query($sql);
                echo $result;
                $jsonarray= array('Status'=>false,'Message'=> $result );



                if (($result = $conn->query($sql)) !== FALSE)
            {
                echo "query success";

                while($row = $result->fetch_assoc())
                {
                    echo "ID: " . $row["ID"]. " ";
                }
            }
            else
            {
                echo "query failure";
                echo "Error: " . $sql . "<br>" . $conn->error;
            }

                // output data of each row
                //while($row = $result->fetch_assoc()) {
                      //$jsonarray[] = $row;


            //}
                echo json_encode($jsonarray);


            }

            }



            ?>