LOGIN SCRIPT

<?php


    $db_host = "";

    $db_username = "";

    $db_pass = "";

    $db_name = "";

    $con = mysqli_connect($db_host, $db_username, $db_pass, $db_name);

 if($_SERVER['REQUEST_METHOD'] == 'POST') {

     $userid = $_POST['login_id'];
     $userpass = $_POST['login_pass'];

     $sql = "SELECT * FROM USERINFO WHERE user_id = '$userid' AND user_pass = '$userpass'";

     if ($result=mysqli_query($con,$sql)){

        $count = mysqli_num_rows($result);
        // Fetch one and one row
        $row=mysqli_fetch_array($result,MYSQLI_ASSOC);

         if($count == 1){
             $row = json_encode($row);

             echo "{
                    \"usersinfo\" : [
                        $row
                        ]
                   }";
         }else{
             echo "failure";
         }
        // Free result set
        mysqli_free_result($result);
        mysqli_close($con);
    }
 }
?>