Android Login From Php

Creating MySQL Database

• Go to your phpmyadmin database (I am using my localhost from wamp server).
• Create a simple table named users of 3 columns (userid, username and password). userid will be the primary key and make it auto increment.

Creating PHP Script

• Create a php script. Our script will get two post values username and password from our android app.
• Then we will check that the given username or password exist or not?
• If exist we will echo a message success
• Else we will echo a message failure

login.php 

<?php

define('HOST','localhost');

define('USER','root');

define('PASS','');

define('DB','user');

$con = mysqli_connect(HOST,USER,PASS,DB);

$username = $_POST['username'];

$password = $_POST['password'];

$sql = "select * from users where username='$username' and password='$password'";

$res = mysqli_query($con,$sql);

$check = mysqli_fetch_array($res);

if(isset($check)){

echo 'success';

}else{

echo 'failure';

}

mysqli_close($con);

?>

<?php define('HOST','mysql.hostinger.in'); define('USER','u813815354_user'); define('PASS','bhaq2010'); define('DB','u813815354_db');   $con = mysqli_connect(HOST,USER,PASS,DB);   $username = $_POST['username']; $password = $_POST['password'];   $sql = "select * from users where username='$username' and password='$password'";   $res = mysqli_query($con,$sql);   $check = mysqli_fetch_array($res);   if(isset($check)){ echo 'success'; }else{ echo 'failure'; }   mysqli_close($con); ?>

My activity_main file

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

     android:layout_width="match_parent"

    android:layout_height="match_parent" 

    android:orientation="vertical"

   tools:context=".MainActivity">

    <TextView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="User Name"

        android:id="@+id/textView" />

    <EditText

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:id="@+id/editTextUserName" />

    <TextView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="Password"

        android:id="@+id/textView2" />

    <EditText

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:inputType="textPassword"

        android:ems="10"

        android:id="@+id/editTextPassword" />

    <Button

        android:layout_width="fill_parent"

        android:layout_height="wrap_content"

        android:text="Login"

        android:onClick="invokeLogin"

        android:id="@+id/button" />

</LinearLayout>

My welcome.xml file

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

     android:layout_width="match_parent"

    android:layout_height="match_parent"

    tools:context="net.simplifiedcoding.androidloginapp.UserProfile">

    <TextView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:textAppearance="?android:attr/textAppearanceLarge"

        android:text="Large Text"

        android:id="@+id/textView3"

        android:layout_alignParentTop="true"

        android:layout_alignParentLeft="true"

        android:layout_alignParentStart="true" />

</RelativeLayout>

My MainActivity file

import android.app.Activity;

import android.app.Dialog;

import android.app.ProgressDialog;

import android.content.Intent;

import android.os.AsyncTask;

import android.os.Bundle;

import android.view.Menu;

import android.view.MenuItem;

import android.view.View;

import android.widget.EditText;

import android.widget.Toast;

import org.apache.http.HttpEntity;

import org.apache.http.HttpResponse;

import org.apache.http.NameValuePair;

import org.apache.http.client.ClientProtocolException;

import org.apache.http.client.HttpClient;

import org.apache.http.client.entity.UrlEncodedFormEntity;

import org.apache.http.client.methods.HttpPost;

import org.apache.http.impl.client.DefaultHttpClient;

import org.apache.http.message.BasicNameValuePair;

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.io.UnsupportedEncodingException;

import java.util.ArrayList;

import java.util.List;

public class MainActivity extends Activity {

    private EditText editTextUserName;

    private EditText editTextPassword;

    public static final String USER_NAME = "USERNAME";

    String username;

    String password;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        editTextUserName = (EditText) findViewById(R.id.editTextUserName);

        editTextPassword = (EditText) findViewById(R.id.editTextPassword);

    }

    public void invokeLogin(View view){

        username = editTextUserName.getText().toString();

        password = editTextPassword.getText().toString();

        login(username,password);

    }

    private void login(final String username, String password) {

        class LoginAsync extends AsyncTask<String, Void, String>{

            private Dialog loadingDialog;

            @Override

            protected void onPreExecute() {

                super.onPreExecute();

                loadingDialog = ProgressDialog.show(MainActivity.this, "Please wait", "Loading...");

            }

            @Override

            protected String doInBackground(String... params) {

                String uname = params[0];

                String pass = params[1];

                InputStream is = null;

                List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

                nameValuePairs.add(new BasicNameValuePair("username", uname));

                nameValuePairs.add(new BasicNameValuePair("password", pass));

                String result = null;

                try{

                    HttpClient httpClient = new DefaultHttpClient();

                    HttpPost httpPost = new HttpPost("http://10.0.2.2:1234/Andrid/login.php");

                    httpPost.setEntity(new UrlEncodedFormEntity(nameValuePairs));

                    HttpResponse response = httpClient.execute(httpPost);

                    HttpEntity entity = response.getEntity();

                    is = entity.getContent();

                    BufferedReader reader = new BufferedReader(new InputStreamReader(is, "UTF-8"), 8);

                    StringBuilder sb = new StringBuilder();

                    String line = null;

                    while ((line = reader.readLine()) != null)

                    {

                        sb.append(line + "\n");

                    }

                    result = sb.toString();

                } catch (ClientProtocolException e) {

                    e.printStackTrace();

                } catch (UnsupportedEncodingException e) {

                    e.printStackTrace();

                } catch (IOException e) {

                    e.printStackTrace();

                }

                return result;

            }

            @Override

            protected void onPostExecute(String result){

                String s = result.trim();

                loadingDialog.dismiss();

                if(s.equalsIgnoreCase("success")){

                    Intent intent = new Intent(MainActivity.this, UserProfile.class);

                    intent.putExtra(USER_NAME, username);

                    finish();

                    startActivity(intent);

                }else {

                    Toast.makeText(getApplicationContext(), "Invalid User Name or Password", Toast.LENGTH_LONG).show();

                }

            }

        }

        LoginAsync la = new LoginAsync();

        la.execute(username, password);

    }

    @Override

    public boolean onCreateOptionsMenu(Menu menu) {

        // Inflate the menu; this adds items to the action bar if it is present.

        getMenuInflater().inflate(R.menu.activity_main, menu);

        return true;

    }

    @Override

    public boolean onOptionsItemSelected(MenuItem item) {

        // Handle action bar item clicks here. The action bar will

        // automatically handle clicks on the Home/Up button, so long

        // as you specify a parent activity in AndroidManifest.xml.

        int id = item.getItemId();

        //noinspection SimplifiableIfStatement

        if (id == R.id.action_settings) {

            return true;

        }

        return super.onOptionsItemSelected(item);

    }

}

My userprofile.java file

package com.example.android_php;

import android.app.Activity;
import android.content.Intent;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.TextView;


public class UserProfile extends Activity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.welcome);

        Intent intent = getIntent();
        String username = intent.getStringExtra(MainActivity.USER_NAME);

        TextView textView = (TextView) findViewById(R.id.textView3);

        textView.setText("Welcome "+username);
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.activity_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}

                                                       Now you can test your application.

Total Page View

Stats For Free