Login service in PHP and MySQL for Android Application

Generally service is one type of intermediate for the communication between multiple different technologies, so here we make one service which Is use to login valid user to android application.

Here process flow is Android app user enter its username and password to its application then press  login button , now on login button we call PHP service which is connect the My SQL database and check the  user table , and return response to the android application.

For creating the Service in PHP we have to make one page in PHP and also make table “tbl_User” for store user data in My SQL, so by using service we compare the user data come from android app with tbl_User and return result.  For create service follow below steps.

1.      Make Table in MySQL for storing the user. Give its name “tbl_User” this table contains UserName, Password etc…, for creating table run below script.

CREATE TABLE IF NOT EXISTS `tbl_user` (

  `ur_Id` int(11) NOT NULL AUTO_INCREMENT,

  `ur_username` varchar(50) NOT NULL,

  `ur_password` varchar(50) NOT NULL,

  `ur_status` int(11) NOT NULL,

  PRIMARY KEY (`ur_Id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

By running above script it will create table like below. here table contains Id, Username, Password, Status etc… columns

1.      Now insert some temporary data to this table, so for insert data in temporary table I run below SQL script.

INSERT INTO `tbl_user` (`ur_Id`, `ur_username`, `ur_password`, `ur_status`) VALUES

(1, 'nirav@gmail.com', 'nirav', 1),

(2, 'kapil@gmail.com', 'kapil', 1),

(3, 'arvind@gmail.com', 'arvind', 1);

After running below script you can show table something like below.

1.      Now we make PHP service, so create one PHP file and give its name “service_userlogin.php”

<?php

?>

-          Now we make MySQL server connection from the php file, so pass server name, user name, password, database name etc…

$conn = new mysqli('localhost', 'root', '');

mysqli_select_db($conn, 'EmployeeDB');

-          Here we pass server name as ‘localhost’, username as ‘root’ , password to be blank(’’), and we pass database name as ‘EmployeeDB’.

-          Now we get the parameter from the android application so you get the parameter from the URL by using “GET” method. And check is it contains any value or not.

if (isset($_GET[username]) && $_GET[username] != '' && isset($_GET['password']) && $_GET['password'] != '')

{

              $email = $_GET[username];

              $password = $_GET['password'];   

}

-          We check the username and password comes from the service URL and if its contains any data or not so first we store it in variable as show in above code.

-          Here we make my SQL query for checking the user is valid or not and run this query and check the output of query , if there is any  valid user is there then we pass its userid in response of service.

-          In service response we pass total 3 parameters 

o   Status

o   Message

o   UserId

-          If user is valid then we pass Status=”Ok”, Message =”Login successfully”, UserId=”whatever user id you find”.

-          If there is no any user exist in database with this userid and password then we pass response with following parameter like Status=”Not Ok” , Message=”Enter correct password” , UserId=”0”;

$getData = "SELECT `ur_Id`,`ur_username`,`ur_password` FROM `tbl_user` WHERE `ur_username`='" .$email."' and `ur_password`='".$password."'";       

              $result = mysqli_query($conn,$getData);

              $userId="";

              while(  $r = mysqli_fetch_row($result))

              {

                   $userId=$r[0];

              }

             

              if ($result->num_rows > 0 ){

                  

                   $resp["status"] = "1";

                   $resp["userid"] = $userId;

                   $resp["message"] = "Login successfully";

              }else{

                   $resp["status"] = "-2";

              $resp["message"] = "Enter correct username or password";

              }

-          Here finally our main logic is finish but now we have to make it set its “content-Type” parameter and pass it’s as JSON response.

header('content-type: application/json');

$response["response"]=$resp;

echo json_encode($response);

-          Now finally we close the MYSQL connection.

     @mysqli_close($conn);  

n  Complete Code For PHP file “service_userlogin.php”

<?php        

$conn = new mysqli('localhost', 'root', '');

mysqli_select_db($conn, 'EmployeeDB');

if (isset($_GET[username]) && $_GET[username] != '' && isset($_GET['password']) && $_GET['password'] != '')

{

               $email = $_GET[username];

              $password = $_GET['password'];   

                       

              $getData = "SELECT `ur_Id`,`ur_username`,`ur_password` FROM `tbl_user` WHERE `ur_username`='" .$email."'

and `ur_password`='".$password."'";

                            

              $result = mysqli_query($conn,$getData);

         

              $userId="";

              while(  $r = mysqli_fetch_row($result))

              {

                   $userId=$r[0];

              }

             

              if ($result->num_rows > 0 ){

                  

                   $resp["status"] = "1";

                   $resp["userid"] = $userId;

                   $resp["message"] = "Login successfully";

              }else{

                   $resp["status"] = "-2";

              $resp["message"] = "Enter correct username or password";

              }

         

 }else

 {

              $resp["status"] = "-2";

          $resp["message"] = "Enter Correct username.";

             

             

 }

header('content-type: application/json');

             

$response["response"]=$resp;

echo json_encode($response);

             

@mysqli_close($conn);

?>

-          Now we run the php file in WAMP/XAMP server and pass username, password as parameter in URL.

-          http://localhost:8081/service_userlogin.php?username=nirav@gmail.com&password=nirav

-          OUTPUT :

{"response":{"status":"1","userid":"1","message":"Login successfully"}}

Thanks for reading my article; if you have any question regarding this than you can ask me on comment section.