How to Send Employee Information to the Local Server in Android

Introduction

 

This article explains how to send employee information to the local server in Android.

 

This application will show you how to send information to the server in Android. First you need a local server; I used WampServer. You can use Wamp or Xamp, whatever you like to use. I have posted an article on how to set up a WampServer on your Desktop.

 

Here I will show you how to create a database in WampServer.

 

Step 1

 

Open Wampserver on your browser by writing localhost or localhost:8080. In your browser, a page will be displayed.

 

 

Step 2

 

Click on "PhPmyadmin" on the left side.

 

 

Step 3

 

Click the Databases on the top of the page.

 

 

Step 4

 

Click on the SQL on the right side of Databases.

 

 

Step 5

 

Here you will create the database by writing a SQL query and click on the "Go" button. Your database will be created and you can see your database name on the left side of the page.

 

 

Step 6

 

Now click on your database name; another page will be shown. Now again click SQL and write a query to create a table in your database.

 

 

Now for the coding part.

 

Step 7

 

Create PHP files to connect with the server.

 

db_connect.php

 <?php
/**
 * A class file to connect to database
 */
class DB_CONNECT
{
    // constructor
    function __construct()
    {
        // connecting to database
        $this->connect();
    }
    // destructor
    function __destruct()
    {
        // closing db connection
        $this->close();
    }
    /**
     * Function to connect with database
     */
    function connect()
    {
        // import database connection variables
        require_once __DIR__ . '/db_config.php';
        // Connecting to mysql database
        $con = mysql_connect(DB_SERVER, DB_USER, DB_WORD) or die(mysql_error());
        // Selecing database
        $db = mysql_select_db(DB_DATABASE) or die(mysql_error()) or die(mysql_error());
        // returing connection cursor
        return $con;
    }
    /**
     * Function to close db connection
     */
    function close()
    {
        // closing db connection
        mysql_close();
    }
}
?>

db_config.php

<?php

/*
 * All database connection variables
 */

define('DB_USER', "root"); // db user
define('DB_WORD', ""); // db word (mention your db word here)
define('DB_DATABASE', "employee"); // database name
define('DB_SERVER', "localhost"); // db server
?>

Create a PHP file to store information on the server.

 <?php

/*
 * Following code will create a new product row
 * All product details are read from HTTP Post Request
 */

// array for JSON response
$response = array();

// check for required fields
if (isset($_POST['id']) && isset($_POST['name'])) {

    $id   = $_POST['id'];
    $name = $_POST['name'];

    // include db connect class
    require_once __DIR__ . '/db_connect.php';

    // connecting to db
    $db = new DB_CONNECT();

    // mysql inserting a new row
    $result = mysql_query("INSERT INTO employe_data(id, name) VALUES('$id', '$name')");

    // check if row inserted or not
    if ($result) {
        // successfully inserted into database
        $response["success"] = 1;
        $response["message"] = "Product successfully created.";

        // echoing JSON response
        echo json_encode($response);
    } else {
        // failed to insert row
        $response["success"] = 0;
        $response["message"] = "Oops! An error occurred.";

        // echoing JSON response
        echo json_encode($response);
    }
} else {
    // required field is missing
    $response["success"] = 0;
    $response["message"] = "Required field(s) is missing";

    // echoing JSON response
    echo json_encode($response);
}
?>

Step 8

 

Create an XML file and write this. In this XML file, you will use two text views, two edittexts, and a button.

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >

    <!-- Name Label -->
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Employee_Id"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    <!-- Input Name -->
    <EditText android:id="@+id/inputId"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:singleLine="true"/>

    <!-- Price Label -->
    <TextView android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Employee_Name"
        android:paddingLeft="10dip"
        android:paddingRight="10dip"
        android:paddingTop="10dip"
        android:textSize="17dip"/>

    <!-- Input Price -->
    <EditText android:id="@+id/inputName"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:layout_margin="5dip"
        android:layout_marginBottom="15dip"
        android:singleLine="true"
       />

    <!-- Description Label -->


    <!-- Button Create Product -->
    <Button android:id="@+id/btnCreateProduct"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="Create "/>

</LinearLayout>

Step 9

 

Create a Java class file MainActivity with the following:

package com.example.adddatatotheserver;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import org.apache.http.NameValuePair;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

import android.app.Activity;
import android.app.ListActivity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.inputmethod.EditorInfo;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;

public class MainActivity extends Activity
{

 // Progress Dialog
 private ProgressDialog pDialog;

 // Create the object of JsonParser class
 JSONParser jParser = new JSONParser();

 EditText inputName;
 EditText inputId;

 // url to create send data. This contains the ip address of my machine on which the local server is running. You will write the IP address of your machine
 private static String url = "http://192.168.1.135:8080/connect_php/create_product.php";

 // JSON Node names
 private static final String TAG_SUCCESS = "success";

 @Override
 public void onCreate(Bundle savedInstanceState)
 {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);

  // Edit Text
  inputName = (EditText) findViewById(R.id.inputName);
  inputId = (EditText) findViewById(R.id.inputId);

  // Create button
  Button btnCreateProduct = (Button) findViewById(R.id.btnSend);

  // button click event
  btnCreateProduct.setOnClickListener(new View.OnClickListener()
  {


   /*on button click you will call the execute() method with the object of CreateNewId class and onPreExecute() will be called where we start the progress dialogue. After the execution of
     onPreExecute(), doInBackGround method will be called automatically which sends the data to the JsonParser class. In JsonParser class I have created the Http Client to send the   data to the server.     */
   @Override
   public void onClick(View view)
   {
    // creating new product in background thread
    new CreateNewId().execute();
   }
  });
 }

 /**
  * Background Async Task to Create new product
  * */
 class CreateNewId extends AsyncTask < String, String, String >
 {

  /**
   * Before starting background thread Show Progress Dialog
   * */
  @SuppressWarnings("unused")
  @Override
  protected void onPreExecute()
  {
   super.onPreExecute();
   pDialog = new ProgressDialog(MainActivity.this);
   pDialog.setMessage("Creating Data..");
   pDialog.setIndeterminate(false);
   pDialog.setCancelable(true);
   pDialog.show();
  }

  /**
   * Creating product
   * */
  protected String doInBackground(String...args)
  {
   String name = inputName.getText().toString();
   String id = inputId.getText().toString();

   // Building Parameters
   List < NameValuePair > params = new ArrayList < NameValuePair > ();
   params.add(new BasicNameValuePair("name", name));
   params.add(new BasicNameValuePair("id", id));

   // getting JSON Object
   // Note that create product url accepts POST method
   JSONObject json = jParser.makeHttpRequest(url,
    "POST", params);

   // check log cat fro response
   Log.d("Create Response", json.toString());

   // check for success tag
   try
   {
    int success = json.getInt(TAG_SUCCESS);

    if (success == 1)
    {
     // successfully created product
     // Intent i = new Intent(getApplicationContext(), AllProductsActivity.class);
     //startActivity(i);
     finish();
     // closing this screen

    }
    else
    {
     // failed to create product
    }
   }
   catch (JSONException e)
   {
    e.printStackTrace();
   }

   return null;
  }

  /**
   * After completing background task Dismiss the progress dialog
   * **/
  protected void onPostExecute(String file_url)
  {
   // dismiss the dialog once done
   pDialog.dismiss();
  }

 }
}

Step 10

 

Create another Java class file JsonParser with the following:

package com.example.adddatatotheserver;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;
import java.util.List;

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.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.client.utils.URLEncodedUtils;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONException;
import org.json.JSONObject;

import android.util.Log;

public class JSONParser
{

 static InputStream inputStream = null;
 static JSONObject jObject = null;
 static String jsonString = "";

 // constructor
 public JSONParser()
 {

 }

 // function get json from url
 // by making HTTP POST or GET mehtod
 public JSONObject makeHttpRequest(String url, String method, List < NameValuePair > params)
  {

  // Making HTTP request
  try
  {

   // check for request method
   if (method == "POST")
   {
    // request method is POST
    // defaultHttpClient
    DefaultHttpClient client = new DefaultHttpClient();
    HttpPost post = new HttpPost(url);
    post.setEntity(new UrlEncodedFormEntity(params));

    HttpResponse httpResponse = client.execute(post);
    HttpEntity entity = httpResponse.getEntity();
    inputStream = entity.getContent();

   }
   else if (method == "GET")
   {
    // request method is GET
    DefaultHttpClient httpClient = new DefaultHttpClient();
    String paramString = URLEncodedUtils.format(params, "utf-8");
    url += "?" + paramString;
    HttpGet httpGet = new HttpGet(url);

    HttpResponse httpResponse = httpClient.execute(httpGet);
    HttpEntity httpEntity = httpResponse.getEntity();
    inputStream = httpEntity.getContent();
   }

  }
  catch (UnsupportedEncodingException e)
  {
   e.printStackTrace();
  }
  catch (ClientProtocolException e)
  {
   e.printStackTrace();
  }
  catch (IOException e)
  {
   e.printStackTrace();
  }

  try
  {
   BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(
    inputStream, "iso-8859-1"), 8);
   StringBuilder stringBuilder = new StringBuilder();
   String line = null;
   while ((line = bufferedReader.readLine()) != null)
   {
    stringBuilder.append(line + "\n");
   }
   inputStream.close();
   jsonString = stringBuilder.toString();
  }
  catch (Exception e)
  {
   Log.e("Buffer Error", "Error converting result " + e.toString());
  }
  Log.d("debug", "string: " + jsonString);

  // try parse the string to a JSON object
  try
  {
   jObject = new JSONObject(jsonString);
  }
  catch (JSONException e)
  {
   Log.e("JSON Parser", "Error parsing data " + e.toString());
  }

  // return JSON String
  return jObject;

 }
}

Step 11

 

Android Manifest.Xml file

 

In the Android Manifest.xml file give the internet permission as in the following:

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
  package="com.example.adddatatotheserver"
    android:versionCode="1"
    android:versionName="1.0" >
    <uses-sdk
        android:minSdkVersion="8"
        android:targetSdkVersion="18" />
    <application
        android:allowBackup="true"
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name"
        android:theme="@style/AppTheme" >
        <activity
            android:name="com.example.adddatatotheserver.MainActivity"
            android:label="@string/app_name" >
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>
      <uses-permission android:name="android.permission.INTERNET"></uses-permission>
      <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
</manifest>

Step 12

 

Enter data to send

 

 

Progress

 

 

Data on the Server