Skip to main content

Connecting mysql Database in ANDROID using PHP & JSON

 To implement this tutorial you should have basic knowledge of how to run PHP script and start server.  If we talk about client-server architecture, client is Android device and in server side there is a combination of PHP Script and MySQL. In short, PHP Script sits in middle as shown in image.



Lets suppose that we have a MySQL database named Employee, and a table int created, with the following SQL:



CREATE TABLE `employee` (
  `emp_id` int(11) NOT NULL auto_increment,
  `emp_name` varchar(100) NOT NULL,
  PRIMARY KEY  (`emp_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;


The PHP code will be very simple:



Now Create Android Project : 


The Android part is only a bit more complicated:
-use a HttpPost to get the data
-convert response to string
-parse JSON data in to List


In Your First Activity :



O/P :





Comments

  1. Dz-Hi-tech30 April 2013 at 20:14

    Thank you ;)

    ReplyDelete
  2. Sabha21 May 2013 at 08:27

    Hi
    I tried ur coding.I have got an error that the variables "items" and "is" can not be resolved.Where it should be declared.

    ReplyDelete
    Replies
    1. dj-android21 May 2013 at 15:55

      Both items & is are Global Variable. like:

      public class mainActivity extends Activity{

      public ArrayList items = new arrayList();
      String is;

      @Override
      public void onCreate(Bundle savedInstanceState)
      // rest of all code
      }

      }

      Delete
  3. Sabha21 May 2013 at 17:20

    Thank you.But when the app starts i encounter this error
    05-21 17:11:58.115: E/log_tag(410): Error in HTTP connectionjava.net.SocketException: Permission denied
    05-21 17:11:58.146: E/log_tag(410): Error in convert Stringjava.lang.NullPointerException

    ReplyDelete
    Replies
    1. dj-android21 May 2013 at 21:13

      You have added internet permission in android manifest file??

      http://stackoverflow.com/questions/2378607/what-permission-do-i-need-to-access-internet-from-an-android-application

      Delete
  4. Unknown11 August 2013 at 23:36

    Can you please tell the declaration for sb and result? Thanks!

    ReplyDelete
  5. Unknown29 August 2013 at 23:28

    This comment has been removed by the author.

    ReplyDelete
  6. Unknown31 August 2013 at 21:56

    I've managed to make the program work. However, I seem to encounter an unexpected error. What is shown on the browser when I run the php file separately also shows when I run the application on my Android phone. Any thoughts on what may be the cause? Thanks!

    ReplyDelete

Post a Comment

Popular posts from this blog

MCP vs CLI: Which One Fits Your AI Agent's Job?

  Every AI agent that touches the outside world does it one of two ways: it runs a shell command, or it calls a tool through the Model Context Protocol. Both get the job done, but they don't cost the same or fail the same way, which is why "MCP vs CLI" keeps resurfacing without resolving. I want to answer it for the cases that matter most: plain developer tooling, data-heavy systems like banking, forecasting pipelines, and transaction automation like billing or booking. Neither wins outright. Where you draw the line is the actual skill. Key Takeaways CLI is the default for anything the model already knows cold, git, file ops, text processing, since there's no schema tax and commands chain through pipes. MCP earns its cost when a system needs per-user auth, audit trails, or access to sources the model can't otherwise reach, exactly what regulated systems like banking require. Transaction automation works best split: deterministic code drives the repeatable steps, a...
Post a Comment
Read more

ANDROID - Adding ActionBar Navigation Tabs

Note: if you are develop App < 3.0 Android OS then use  ActionBarSherlock   support library. ActionBarSherlock is an extension of the  support library  designed to facilitate the use of the action bar design pattern across all versions of Android with a single API. Create new Android Project : in Main Activity package com.AlarmManager; import android.os.Bundle; import android.view.View; import com.actionbarsherlock.app.ActionBar; import com.actionbarsherlock.app.ActionBar.Tab; import com.actionbarsherlock.app.SherlockFragmentActivity; public class AlarmManagerActivity extends SherlockFragmentActivity { public static String ACTIVE_TAB = "activeTab"; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { setTheme(R.style.Theme_Sherlock_Light_DarkActionBar); super.onCreate(savedInstanceState); // s...
4 comments
Read more

Don't Ship AI Agent Skills Without Evals

At the AI Engineer World's Fair on July 1, 2026, Philipp Schmid, a Staff Engineer on the Gemini API and agents team at Google DeepMind, asked a room full of engineers a simple question: who uses skills with their coding agents? Every hand went up. Who has evals for those skills? Almost none. That gap is the entire talk, which Schmid also wrote up on his own blog, philschmid.de/testing-skills . His team indexed the skills ecosystem through SkillsBench and found the same pattern everywhere: people ship a SKILL.md file after two manual test runs and move on. It looks fine in a demo. It quietly corrupts outputs in production, because bad skills don't crash. They just make the agent confidently wrong. If you've already read our breakdown of Matt Pocock's Claude Code skills library , think of this as the other half of that story: what happens once you've installed a skill and it's actually running against real prompts. Key Takeaways SkillsBench indexed 47,000+ un...
Post a Comment
Read more