Android Tutorials

Retrieve Database from mysql and Diplaying in Dynamic Table using android

To download Full program click here

I Installed WAMP server on my local machine for excuting PHP programs.

I have programmed in windows 7.

If You need WAMP server, click here to download.

Before run this program ,start wampserver

programs --> wampserver --> start wampserver

see right side below of taskbar WAMPSERVER -server offline icon present.

This is the wampserver icon

Left click icon --> start all services

main.xml

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

    <Button
        android:id="@+id/button1"
        android:layout_width="116dp"
        android:layout_height="wrap_content"
        android:text="Insert" />

    <Button
        android:id="@+id/button2"
        android:layout_width="114dp"
        android:layout_height="wrap_content"
        android:text="Retrieve" />

    <Button
        android:id="@+id/button3"
        android:layout_width="114dp"
        android:layout_height="wrap_content"
        android:text="Update" />

    <Button
        android:id="@+id/button4"
        android:layout_width="116dp"
        android:layout_height="wrap_content"
        android:text="Delete" />

</LinearLayout>

insert.xml

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

    <EditText
        android:id="@+id/e1"
        android:numeric="integer"

        android:layout_width="match_parent"
        android:layout_height="wrap_content" >

        <requestFocus />
    </EditText>

    <EditText
        android:id="@+id/e2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:inputType="text" />

    <EditText
        android:id="@+id/e3"
        android:numeric="integer"

        android:layout_width="match_parent"
        android:layout_height="wrap_content" />


    <Button
        android:id="@+id/button1"
        android:layout_width="276dp"
        android:layout_height="wrap_content"
        android:text="Button" />

</LinearLayout>

update.xml

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

    <EditText
        android:id="@+id/e1"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:numeric="integer" >

        <requestFocus />
    </EditText>

    <Button
        android:id="@+id/button2"
        android:layout_width="78dp"
        android:layout_height="wrap_content"
        android:text="Button" />

    <EditText
        android:id="@+id/e2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:inputType="text" />

    <EditText
        android:id="@+id/e3"
        android:numeric="integer"

        android:layout_width="match_parent"
        android:layout_height="wrap_content" />


    <Button
        android:id="@+id/button1"
        android:layout_width="276dp"
        android:layout_height="wrap_content"
        android:text="Button" />

</LinearLayout>

select.xml

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

    <EditText
        android:id="@+id/e1"
        android:numeric="integer"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" >

        <requestFocus />
    </EditText>


    <Button
        android:id="@+id/button1"
        android:layout_width="276dp"
        android:layout_height="wrap_content"
        android:text="Button" />


    <EditText
        android:id="@+id/e2"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />

    <EditText
        android:id="@+id/e3"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />


</LinearLayout>

delete.xml

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

    <EditText
        android:id="@+id/e1"
        android:numeric="integer"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" >

        <requestFocus />
    </EditText>


    <Button
        android:id="@+id/button1"
        android:layout_width="276dp"
        android:layout_height="wrap_content"
        android:text="Button" />

</LinearLayout>

DatabaseActivity.java

package selva.db; // Change your package name

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;

public class DatabaseActivity extends Activity {
    /** Called when the activity is first created. */
    @Override
        public void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.main);

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


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


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


            Button button3 = (Button) findViewById(R.id.button4);



            button.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view) {


                Intent i = new Intent(getBaseContext(),insert.class);
                startActivity(i);
           }
           });




            button1.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view) {


                Intent i = new Intent(getBaseContext(),select.class);
                startActivity(i);
           }
           });




            button2.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view) {


                Intent i = new Intent(getBaseContext(),update.class);
                startActivity(i);
           }
           });


            button3.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view) {


                Intent i = new Intent(getBaseContext(),delete.class);
                startActivity(i);
           }
           });



        }
}

insert.java

package selva.db;

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

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.os.StrictMode;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class insert extends Activity
{


    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();



    public void onCreate(Bundle savedInstanceState)

    {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.insert);
            Button button = (Button) findViewById(R.id.button1);
            button.setOnClickListener(new View.OnClickListener()
            {
                   public void onClick(View view)
                     {

                           String result = null;
                           InputStream is = null;
                           EditText editText = (EditText)findViewById(R.id.e1);
                           String v1 = editText.getText().toString();
                           EditText editText1 = (EditText)findViewById(R.id.e2);
                           String v2 = editText1.getText().toString();
                           EditText editText2 = (EditText)findViewById(R.id.e3);
                           String v3 = editText2.getText().toString();
         ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();

                           nameValuePairs.add(new BasicNameValuePair("f1",v1));
                           nameValuePairs.add(new BasicNameValuePair("f2",v2));
                           nameValuePairs.add(new BasicNameValuePair("f3",v3));

                           StrictMode.setThreadPolicy(policy);

                //http post
                try{
                        HttpClient httpclient = new DefaultHttpClient();
                        HttpPost httppost = new HttpPost("http://10.0.2.2/insert.php");
                        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
                        HttpResponse response = httpclient.execute(httppost);
                        HttpEntity entity = response.getEntity();
                        is = entity.getContent();

                        Log.e("log_tag", "connection success ");
    Toast.makeText(getApplicationContext(), "pass", Toast.LENGTH_SHORT).show();
                   }


                catch(Exception e)
                {
                        Log.e("log_tag", "Error in http connection "+e.toString());
Toast.makeText(getApplicationContext(), "Connection fail",                                        Toast.LENGTH_SHORT).show();

                }
                //convert response to string
                try{
                        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
                        StringBuilder sb = new StringBuilder();
                        String line = null;
                        while ((line = reader.readLine()) != null)
                        {
                                sb.append(line + "\n");
                                   Intent i = new Intent(getBaseContext(),DatabaseActivity.class);
                                startActivity(i);
                        }
                        is.close();

                        result=sb.toString();
                }
                catch(Exception e)
                {
                       Log.e("log_tag", "Error converting result "+e.toString());
                   }


                try{

                                JSONObject json_data = new JSONObject(result);

                                CharSequence w= (CharSequence) json_data.get("re");

                                Toast.makeText(getApplicationContext(), w, Toast.LENGTH_SHORT).show();


                     }
                catch(JSONException e)
                   {
                        Log.e("log_tag", "Error parsing data "+e.toString());
                        Toast.makeText(getApplicationContext(), "JsonArray fail", Toast.LENGTH_SHORT).show();
                    }



           }
           });



    }


}

update.java

                      try
                     {
                        HttpClient httpclient = new DefaultHttpClient();
                        HttpPost httppost = new HttpPost("http://10.0.2.2/select.php");
                        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
                        HttpResponse response = httpclient.execute(httppost);
                        HttpEntity entity = response.getEntity();
                        is = entity.getContent();

                        Log.e("log_tag", "connection success ");
                   }


                      catch(Exception e)
                      {
                        Log.e("log_tag", "Error in http connection "+e.toString());
                        Toast.makeText(getApplicationContext(), "Connection fail", Toast.LENGTH_SHORT).show();

                      }
               //convert response to string
               try{
                        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
                        StringBuilder sb = new StringBuilder();
                        String line = null;
                        while ((line = reader.readLine()) != null)
                        {
                                sb.append(line + "\n");

                        }
                        is.close();

                        result=sb.toString();
                   }
               catch(Exception e)
                   {
                       Log.e("log_tag", "Error converting result "+e.toString());
                    Toast.makeText(getApplicationContext(), " Input reading fail", Toast.LENGTH_SHORT).show();

                   }

               //parse json data
               try{

                           JSONObject object = new JSONObject(result);
                        String ch=object.getString("re");
                        if(ch.equals("success"))
                        {

                           JSONObject no = object.getJSONObject("0");
                           String w= no.getString("f2");
                          long e=no.getLong("f3");

                          editText1.setText(w);
                          String myString = NumberFormat.getInstance().format(e);
                          editText2.setText(myString);

                        }
                        else
                          {

                            Toast.makeText(getApplicationContext(), "Record is not available.. Enter valid number", Toast.LENGTH_SHORT).show();

                            }


               }
               catch(JSONException e)
               {
                        Log.e("log_tag", "Error parsing data "+e.toString());
                        Toast.makeText(getApplicationContext(), "JsonArray fail", Toast.LENGTH_SHORT).show();
               }

                   }
               });



            buttonupadte.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view)
              {

               String result = null;
               InputStream is = null;
               EditText editText = (EditText)findViewById(R.id.e1);

               String v1 = editText.getText().toString();

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

               String v2 = editText1.getText().toString();
               EditText editText2 = (EditText)findViewById(R.id.e3);

               String v3 = editText2.getText().toString();

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

               nameValuePairs.add(new BasicNameValuePair("f1",v1));
               nameValuePairs.add(new BasicNameValuePair("f2",v2));
               nameValuePairs.add(new BasicNameValuePair("f3",v3));

               //http post
               try{
                        HttpClient httpclient = new DefaultHttpClient();
                        HttpPost httppost = new HttpPost("http://10.0.2.2/update.php");
                        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
                        HttpResponse response = httpclient.execute(httppost);
                        HttpEntity entity = response.getEntity();
                        is = entity.getContent();

                        Log.e("log_tag", "connection success ");
                        Toast.makeText(getApplicationContext(), "pass", Toast.LENGTH_SHORT).show();
               }
               catch(Exception e)
               {
                        Log.e("log_tag", "Error in http connection "+e.toString());
                        Toast.makeText(getApplicationContext(), "Connection fail", Toast.LENGTH_SHORT).show();

               }
               //convert response to string
               try
               {
                        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
                        StringBuilder sb = new StringBuilder();
                        String line = null;
                        while ((line = reader.readLine()) != null)
                        {
                                sb.append(line + "\n");
                                //Toast.makeText(getApplicationContext(), "Record Inserted", Toast.LENGTH_SHORT).show();
                                Intent i = new Intent(getBaseContext(),DatabaseActivity.class);
                                startActivity(i);
                        }
                        is.close();

                        result=sb.toString();
               }
               catch(Exception e)
               {
                       Log.e("log_tag", "Error converting result "+e.toString());
                   // Toast.makeText(getApplicationContext(), " record passing fail", Toast.LENGTH_SHORT).show();

               }



               //parse json data
               try{

                    JSONObject json_data = new JSONObject(result);
                    CharSequence w= (CharSequence) json_data.get("re");
                    Toast.makeText(getApplicationContext(), w, Toast.LENGTH_SHORT).show();

                      }
               catch(JSONException e)
               {
                        Log.e("log_tag", "Error parsing data "+e.toString());
                        Toast.makeText(getApplicationContext(), "JsonArray fail", Toast.LENGTH_SHORT).show();
               }




           }
           });




    }


}

select.java

package selva.db;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.text.NumberFormat;
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.JSONException;
import org.json.JSONObject;

import android.app.Activity;
import android.os.Bundle;
import android.os.StrictMode;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class select extends Activity
{
    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();


    public void onCreate(Bundle savedInstanceState)
    {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.select);

            Button button = (Button) findViewById(R.id.button1);
            StrictMode.setThreadPolicy(policy);

            button.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view)
              {
                 String result = null;
                InputStream is = null;
                EditText editText = (EditText)findViewById(R.id.e1);
                String v1 = editText.getText().toString();
                   EditText editText1 = (EditText)findViewById(R.id.e2);

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

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

                nameValuePairs.add(new BasicNameValuePair("f1",v1));
                    try
                    {
                        HttpClient httpclient = new DefaultHttpClient();
                        HttpPost httppost = new HttpPost("http://10.0.2.2/select.php");
                        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
                        HttpResponse response = httpclient.execute(httppost);
                        HttpEntity entity = response.getEntity();
                        is = entity.getContent();

                        Log.e("log_tag", "connection success ");

                    }
                catch(Exception e)
                    {
                        Log.e("log_tag", "Error in http connection "+e.toString());
                        Toast.makeText(getApplicationContext(), "Connection fail", Toast.LENGTH_SHORT).show();

                    }
                //convert response to string
                    try{
                        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
                        StringBuilder sb = new StringBuilder();
                        String line = null;
                        while ((line = reader.readLine()) != null)
                        {
                                sb.append(line + "\n");

                        }
                        is.close();

                        result=sb.toString();
                    }
                    catch(Exception e)
                    {
                       Log.e("log_tag", "Error converting result "+e.toString());

                    Toast.makeText(getApplicationContext(), " Input reading fail", Toast.LENGTH_SHORT).show();

                    }

                //parse json data
                try{


                      JSONObject object = new JSONObject(result);
                        String ch=object.getString("re");
                        if(ch.equals("success"))
                        {

                         JSONObject no = object.getJSONObject("0");

                         //long q=object.getLong("f1");
                        String w= no.getString("f2");
                        long e=no.getLong("f3");

                        editText1.setText(w);
                       String myString = NumberFormat.getInstance().format(e);


                        editText2.setText(myString);

                         }


                        else
                        {

                            Toast.makeText(getApplicationContext(), "Record is not available.. Enter valid number", Toast.LENGTH_SHORT).show();

                        }


                }
                catch(JSONException e)
                {
                        Log.e("log_tag", "Error parsing data "+e.toString());
                        Toast.makeText(getApplicationContext(), "JsonArray fail", Toast.LENGTH_SHORT).show();
                }

           }
           });



    }


}

delete.java

package selva.db;

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

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.os.StrictMode;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class delete extends Activity {


    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();




    public void onCreate(Bundle savedInstanceState)

    {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.delete);

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


            button.setOnClickListener(new View.OnClickListener()
            {
            public void onClick(View view)
            {

                String result = null;
               InputStream is = null;



               EditText editText = (EditText)findViewById(R.id.e1);

               String v1 = editText.getText().toString();


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

               nameValuePairs.add(new BasicNameValuePair("f1",v1));


               StrictMode.setThreadPolicy(policy);

               //http post
               try
               {
                        HttpClient httpclient = new DefaultHttpClient();
                        HttpPost httppost = new HttpPost("http://10.0.2.2/delete.php");
                        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
                        HttpResponse response = httpclient.execute(httppost);
                        HttpEntity entity = response.getEntity();
                        is = entity.getContent();

                        Log.e("log_tag", "connection success ");
                        Toast.makeText(getApplicationContext(), "pass", Toast.LENGTH_SHORT).show();
               }
               catch(Exception e)
               {
                        Log.e("log_tag", "Error in http connection "+e.toString());
                        Toast.makeText(getApplicationContext(), "Connection fail", Toast.LENGTH_SHORT).show();

               }
               //convert response to string
               try
               {
                        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
                        StringBuilder sb = new StringBuilder();
                        String line = null;
                        while ((line = reader.readLine()) != null) {
                                sb.append(line + "\n");
                         Intent i = new Intent(getBaseContext(),DatabaseActivity.class);
                                startActivity(i);
                  }
                        is.close();

                        result=sb.toString();
               }
               catch(Exception e)
               {
                       Log.e("log_tag", "Error converting result "+e.toString());

        }



               //parse json data
               try
               {

                               JSONObject json_data = new JSONObject(result);


                                CharSequence w= (CharSequence) json_data.get("re");

                                Toast.makeText(getApplicationContext(), w, Toast.LENGTH_SHORT).show();

                  }
               catch(JSONException e)
               {
                        Log.e("log_tag", "Error parsing data "+e.toString());
                        Toast.makeText(getApplicationContext(), "JsonArray fail", Toast.LENGTH_SHORT).show();
               }

           }
           });


    }
   }


AndroidMenifest.xml

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

<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="selva.db"
    android:versionCode="1"
    android:versionName="1.0" >

    <uses-sdk android:minSdkVersion="14" />

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

    <application
        android:icon="@drawable/ic_launcher"
        android:label="@string/app_name" >
      <activity
             android:label="@string/app_name"
              android:name=".DatabaseActivity" >
              <intent-filter >
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
          </intent-filter>
          </activity>





         <activity
              android:label="Insert Record"
              android:name=".insert" >
           <intent-filter >
                <action android:name="q.w.e.qwe" />
                <action android:name="android.intent.action.VIEW" />
                <category android:name="android.intent.category.DEFAULT" />
            </intent-filter>
        </activity>

       <activity
            android:label="Get Record"
            android:name=".select" >
            <intent-filter >
                <action android:name="q.w.e.qwe" />
        <action android:name="android.intent.action.VIEW" />
                <category android:name="android.intent.category.DEFAULT" />
            </intent-filter>
        </activity>


       <activity
            android:label="Delete Record"
            android:name=".delete" >
            <intent-filter >
                <action android:name="q.w.e.qwe" />
         <action android:name="android.intent.action.VIEW" />
                <category android:name="android.intent.category.DEFAULT" />
            </intent-filter>
        </activity>

       <activity
            android:label="Update Record"
            android:name=".update" >
            <intent-filter >
                <action android:name="q.w.e.qwe" />
            <action android:name="android.intent.action.VIEW" />
                <category android:name="android.intent.category.DEFAULT" />
            </intent-filter>
        </activity>

    </application>

</manifest>

After installing the wamp server, C drive --> wamp --> www --> save the following php program in given corresponding names.

database name: ex1

Table Name : t1

Fields Name    : f1(bigint),f2(text),f3(bigint)

insert.php

     <?php

         $con = mysql_connect("localhost","root","");
         if (!$con)
           {
             die('Could not connect: ' . mysql_error());
           }

           mysql_select_db("ex1", $con);

           $v1=$_REQUEST['f1'];
           $v2=$_REQUEST['f2'];
           $v3=$_REQUEST['f3'];

if($v1==NULL || $v2==NULL || $v3==NULL)
             {

                $r["re"]="Fill the all fields!!!";
                 print(json_encode($r));
                die('Could not connect: ' . mysql_error());
   }

else
          {
           $i=mysql_query("select * from t1 where f1=$v1",$con);
           $check='';
            while($row = mysql_fetch_array($i))
              {

                $check=$row['f1'];

               }


           if($check==NULL)
                  {

              $q="insert into t1 values('$v1','$v2','$v3')";
              $s= mysql_query($q);
                  if(!$s)
                          {
                          $r["re"]="Inserting problem in batabase";

                         print(json_encode($r));
                           }
                   else
                          {
                         $r["re"]="Record inserted successfully";
                        print(json_encode($r));
                   }
             }
            else
             {
   $r["re"]="Record is repeated";
                 print(json_encode($r));

              }
}
mysql_close($con);

    ?>

update.php


     <?php

         $con = mysql_connect("localhost","root","");
         if (!$con)
           {
             die('Could not connect: ' . mysql_error());
           }

           mysql_select_db("ex1", $con);

             $v1=$_REQUEST['f1'];
             $v2=$_REQUEST['f2'];
             $v3=$_REQUEST['f3'];

      if($v1==NULL || $v2==NULL || $v3==NULL)
{
   $r["re"]="Fill the all fields!!!";
                 print(json_encode($r));
                die('Could not connect: ' . mysql_error());
   }
   else
   {

       $i=mysql_query("select * from t1 where f1=$v1",$con);
            $check='';
                      while($row = mysql_fetch_array($i))
                       {

                 $check=$row['f1'];

                        }


          if($check!=NULL)
             {

               $q="update t1 set f2='$v2',f3='$v3' where f1='$v1'";
                 $s= mysql_query($q,$con);
                  if(!$s)
                   {
                     $r["re"]="updating problem in batabase";

                       print(json_encode($r));
                  }
                else
                {
                     $r["re"]="Record updated successfully";

                       print(json_encode($r));
                  }
            }
              else
            {
   $r["re"]="Record is not available.. Enter valid number!!";
                  print(json_encode($r));
                }

   }
mysql_close($con);

    ?>

select.php

        <?php

         $con = mysql_connect("localhost","root","");
         if (!$con)
           {
             die('Could not connect: ' . mysql_error());
           }

           mysql_select_db("ex1", $con);
           $v1=$_REQUEST['f1'];
          if($v1==NULL)
{

                $r["re"]="Enter the number!!!";
                 print(json_encode($r));
                die('Could not connect: ' . mysql_error());
    }

          else

            {

        $i=mysql_query("select * from t1 where f1=$v1",$con);
             $check='';
         while($row = mysql_fetch_array($i))
              {

                  $r[]=$row;
                  $check=$row['f1'];
               }
if($check==NULL)
             {
                      $r["re"]="Record is not available";
                      print(json_encode($r));

                     }
                   else
               {
   $r["re"]="success";
                  print(json_encode($r));

             }

}

mysql_close($con);

    ?>

delete.php

     <?php

         $con = mysql_connect("localhost","root","");
         if (!$con)
           {
             die('Could not connect: ' . mysql_error());
           }

             mysql_select_db("ex1", $con);

            $v1=$_REQUEST['f1'];

                 if($v1==NULL)
{

              $r["re"]="Enter the number!!!";
                  print(json_encode($r));
                         die('Could not connect: ' . mysql_error());

   }

                    else

                   {
   $i=mysql_query("select * from t1 where f1=$v1",$con);
             $check='';

            while($row = mysql_fetch_array($i))
           {

                 $check=$row['f1'];

               }


       if($check==NULL)
             {

                 $r["re"]="Record is not found.. Enter valid number";
               print(json_encode($r));
}
                           else
            {
$q="delete from t1 where f1='$v1'";
                 $s= mysql_query($q,$con);
               if(!$s)
                {
                    $r["re"]="Record deletion problem in batabase";

                       print(json_encode($r));
               }
                       else
                {
                         $r["re"]="Record Deleted successfully";
                      print(json_encode($r));
                        }

                 }

                    }

mysql_close($con);

    ?>

you should run php by giving your own values. Then you should use php programs
in android.

output:

click insert button

you will get record added successfully message after Clicking Button.

Then click back button --> Retrieve button --> Enter number which is given while inserting -->Click button --> you will get record which is inserted in database.

Then click back button --> update button --> Enter number which is given while inserting -->Click button --> you will get record which is inserted in database.

Then alter name--> then click button

Then click back button --> Retrieve button --> Enter number which is given while inserting -->Click button --> you will get record which is upadted in database.

Then click back button --> Delete button --> Enter number which is given while inserting -->Click button --> you will get delete message which is inserted in database.

To download Full program click here

Retrieve Database from mysql and Diplaying in Dynamic Table using android

Thank you friends.....

Android Tutorials

Tuesday, July 3, 2012

Connect MySQL Database from android

Anatomy of an Android Application

Click here

First, note the various files that make up an Android project in the Package Explorer in Eclipse.

MAIN.XML

Observe the content of the AndroidManifest.xml file:

About Me

Blog Archive