Android Tutorials: JSON - insert (insert data into phpMySQL)

XML File

JAVA FILE

package mysql.insert;

import java.io.BufferedReader;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.util.ArrayList;

import org.apache.http.HttpEntity;

import org.apache.http.HttpResponse;

import org.apache.http.NameValuePair;

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 org.json.JSONObject;

import android.app.Activity;

import android.app.AlertDialog;

import android.content.DialogInterface;

import android.content.DialogInterface.OnClickListener;

import android.content.Intent;

import android.os.AsyncTask;

import android.os.Bundle;

import android.util.Log;

import android.view.Menu;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;

public class Insert extends Activity {

private EditText Edname;

private EditText Edemail;

private EditText Edmobile;

private EditText Edaddr;

private Button insert;

private Button clear;

String name,email,mobile,addr;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.insert);

//EditText

Edname = (EditText) findViewById(R.id.editText1);

Edemail = (EditText) findViewById(R.id.editText2);

Edmobile = (EditText) findViewById(R.id.editText3);

Edaddr = (EditText) findViewById(R.id.editText4);

//Button

insert = (Button) findViewById(R.id.button1);

clear = (Button) findViewById(R.id.button2);

insert.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View arg0) {

// TODO Auto-generated method stub

name=Edname.getText().toString();

email=Edemail.getText().toString();

mobile=Edmobile.getText().toString();

addr=Edaddr.getText().toString();

if(name.length()==0){

Edname.setText("");

Edname.requestFocus();

Edname.setError("Please enter name");

}else if(email.length()==0){

Edemail.setText("");

Edemail.requestFocus();

Edemail.setError("Please enter emailId");

}

else if(!(android.util.Patterns.EMAIL_ADDRESS.matcher(email).matches())) {

Edemail.setText("");

Edemail.requestFocus();

Edemail.setError("Invalid Email Address");

}

else if(Edmobile.length()==0){

Edmobile.setText("");

Edmobile.requestFocus();

Edmobile.setError("Please enter number");

}else if(mobile.length() > 0 && mobile.length()<10 ){

Edmobile.setText("");

Edmobile.requestFocus();

Edmobile.setError("Invalid Mobile Number");

}else if(Edaddr.length()==0){

Edaddr.setText("");

Edaddr.requestFocus();

Edaddr.setError("Please enter address");

}else{

AlertDialog.Builder ab=new AlertDialog.Builder(Insert.this);

ab.setMessage("Do You Want to Insert");

ab.setPositiveButton("Yes", new OnClickListener() {

@Override

public void onClick(DialogInterface arg0, int arg1) {

// TODO Auto-generated method stub

new InsertData().execute(name.toString(),email.toString(),mobile.toString(),addr.toString());

clear();

}

});

ab.setNegativeButton("No",new DialogInterface.OnClickListener() {

@Override

public void onClick(DialogInterface arg0, int arg1) {

// TODO Auto-generated method stub

Toast.makeText(getApplicationContext(),"you select no", 50).show();

}

});

AlertDialog a1=ab.create();

a1.show();

}

clear.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View arg0) {

// TODO Auto-generated method stub

clear();

}

});

}

});

}

public void clear() {

// TODO Auto-generated method stub

Edname.setText("");

Edemail.setText("");

Edmobile.setText("");

Edaddr.setText("");

}

class InsertData extends AsyncTask<String, String, String>{

InputStream IS=null;

String line,result;int code;

@Override

protected String doInBackground(String... params) {

// TODO Auto-generated method stub

ArrayList<NameValuePair> names=new ArrayList<NameValuePair>();

names.add(new BasicNameValuePair("name",params[0]));

names.add(new BasicNameValuePair("email",params[1]));

names.add(new BasicNameValuePair("mobile",params[2]));

names.add(new BasicNameValuePair("addr", params[3]));

HttpPost httppost=null;

HttpResponse response=null;

try{

HttpClient httpclient = new DefaultHttpClient();

// httppost = new HttpPost("http://10.0.2.2/MCA/insert.php");

httppost = new HttpPost("http://mca.freeoda.com/MCA/insert.php");

httppost.setEntity(new UrlEncodedFormEntity(names));

response = httpclient.execute(httppost);

HttpEntity entity = response.getEntity();

IS = entity.getContent();

Log.e("PASS 1 ","Connection Success");

}catch(Exception ee){

Log.e("Fail 1", ee.toString());

// Toast.makeText(getApplicationContext(),"Invallid IP Address"+e.toString(),Toast.LENGTH_LONG).show();

}

try{

BufferedReader reader=new BufferedReader(new InputStreamReader(IS,"iso-8859-1"),8);

StringBuilder sb=new StringBuilder();

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

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

}

IS.close();

result=sb.toString();

Log.e("Pass 2","Pass 2 Success"+result);

}catch (Exception e){

Log.e("Fail 2", e.toString());

// Toast.makeText(getApplicationContext(),e.toString(),Toast.LENGTH_LONG).show();

}

try{

JSONObject j_data=new JSONObject(result);

code=j_data.getInt("code");

String sr;

if(code==1){

Log.e("Pass 3", "Done");

sr="Inserted";

}else{

sr="Not Insertes";

//new Disp().fail();

}

Log.e("pass 3", sr);

}catch(Exception e){

Log.e("Fail 3", e.toString());

// Toast.makeText(getBaseContext(),e.toString(),Toast.LENGTH_LONG).show();

}

return null;

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

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

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

return true;

}

Manifest File

<?xml version="1.0" encoding="utf-8"?>

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

package="mysql.insert"

android:versionCode="1"

android:versionName="1.0" >

<uses-sdk

android:minSdkVersion="8"

android:targetSdkVersion="18" />

<uses-permission android:name="android.permission.INTERNET"/>

<application

android:allowBackup="true"

android:icon="@drawable/ic_launcher"

android:label="@string/app_name"

android:theme="@style/AppTheme" >

<activity

android:name="mysql.insert.Insert"

android:label="@string/app_name" >

<intent-filter>

</intent-filter>

</activity>

</application>

</manifest>

Download Source Code :

Android Tutorials

Menu

Search

Wednesday, 7 December 2016

JSON - insert (insert data into phpMySQL)

No comments:

Post a Comment