Input Data to MySQL Database

[Fandy Akhmad]

Dear Javaranch..

I have some problem in my App. I try to connect Android and Mysql database with PHP.
I want to insert some data trough android Textfield. But It can not save to the database.

1. I use XAMPP
2. I use 10.0.2.2 and my Ip address to connect database.
3. I check from Android Emulator browser check connection. and it successfully.

I think the problem in my Main.java file.

Here is my PHP code :

koneksi.php

<?php $conn = mysql_connect("localhost", "root" , ""); $db = mysql_select_db("employee"); ?>

insert.php

<?php include_once("koneksi.php"); $username = $_REQUEST['username']; $password = $_REQUEST['password']; if($username && $pasword){ $string = "INSERT INTO tbl_login(username, password) VALUES ('$username', '$password')"; mysql_query($string); } $string = "SELECT * FROM tbl_login"; $my_string = mysql_query($string); while($object = mysql_fetch_assoc($my_string)){ $output[] = $object; echo json_encode($output); } mysql_close(); ?>


Here is my Android code:

main.xml File

<?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" > <TextView android:layout_marginTop="20px" android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="Input Data user pada MySQL" android:gravity="center" android:textSize="20px" ></TextView> <EditText android:layout_marginTop="20px" android:id="@+id/username" android:layout_width="150px" android:layout_height="wrap_content" android:gravity="center" android:hint="Username" android:layout_gravity="center" ></EditText> <EditText android:id="@+id/password" android:layout_width="150px" android:layout_height="wrap_content" android:gravity="center" android:hint="Password" android:password="true" android:layout_gravity="center" ></EditText> <Button android:id="@+id/input" android:layout_width="150px" android:layout_height="wrap_content" android:text="Input" android:layout_gravity="center" ></Button> </LinearLayout>


Android Manifest file

<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.android.mysql.app" android:versionCode="1" android:versionName="1.0" > <uses-permission android:name="android.permission.INTERNET"></uses-permission> <uses-sdk android:minSdkVersion="8" /> <application android:icon="@drawable/ic_launcher" android:label="@string/app_name" > <activity android:label="@string/app_name" android:name=".Main" > <intent-filter > <action android:name="android.intent.action.MAIN" /> <category android:name="android.intent.category.LAUNCHER" /> </intent-filter> </activity> </application> </manifest>

Main.java File

package com.android.mysql.app;

import java.io.BufferedReader;
import java.io.IOException;
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.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 android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class Main extends Activity implements OnClickListener{
	EditText user, pass;
	   Button input;
	    @Override
	    public void onCreate(Bundle savedInstanceState) {
	        super.onCreate(savedInstanceState);
	        setContentView(R.layout.main);

	        user = (EditText) findViewById(R.id.username);
	        pass = (EditText) findViewById(R.id.password);
	        input = (Button) findViewById(R.id.input);
	        input.setOnClickListener(this);        
	}
	  
		public void onClick(View v) {
			// TODO Auto-generated method stub
			switch(v.getId()){
		      case R.id.input:
		         insert();
		      }  
		}
	   
	   public void insert(){
	         String input_data= "http://192.168.10.101/android/insert.php"; //URL website anda dengan file insert.php yang telah dibuat
	      
	           HttpClient httpClient = new DefaultHttpClient();
	           HttpPost httpPost = new HttpPost(input_data);
	           ArrayList<NameValuePair> param = new ArrayList<NameValuePair>();
	           param.add(new BasicNameValuePair("username", user.getText().toString()));
	           param.add(new BasicNameValuePair("password", pass.getText().toString()));
	           try {
	                httpPost.setEntity(new UrlEncodedFormEntity(param));
	                HttpResponse httpRespose = httpClient.execute(httpPost);
	               HttpEntity httpEntity = httpRespose.getEntity();
	               InputStream in = httpEntity.getContent();
	               BufferedReader read = new BufferedReader(new InputStreamReader(in));
	            
	               String isi= "";
	               String baris= "";
	            
	               while((baris = read.readLine())!=null){
	                  isi+= baris;
	               }
	               
	               //Jika isi tidak sama dengan "null " maka akan tampil Toast "Berhasil" sebaliknya akan tampil "Gagal"
	               if(!isi.equals("null")){                  
	                  Toast.makeText(this, "Berhasil", Toast.LENGTH_LONG).show();
	               }else{
	                  Toast.makeText(this, "Gagal", Toast.LENGTH_LONG).show();
	               }
	            
	         } catch (ClientProtocolException e) {
	            // TODO Auto-generated catch block
	            e.printStackTrace();
	         } catch (IOException e) {
	            // TODO Auto-generated catch block
	            e.printStackTrace();
	         }
	   }
	   
}

Please help me..

Thank you so much..

[Hussein Baghdadi]

Any error or exceptions is thrown?

[Fandy Akhmad]

Nothing errors i found..

I don't know the concept to building Android app with Mysql Database.
May be you can show me simple app,.

Thanks for your responds

[Tim Moores]

Fandy Akhmad wrote:Nothing errors i found..

You need to look into whatever log file PHP writes to, and in the Android logcat output.

[Fandy Akhmad]

Tim Moores wrote:

Fandy Akhmad wrote:Nothing errors i found..

You need to look into whatever log file PHP writes to, and in the Android logcat output.

Here is logcat 'error'

12-02 09:23:27.497: E/Zygote(33): setreuid() failed. errno: 2
12-02 09:23:38.707: E/Zygote(33): setreuid() failed. errno: 17
12-02 09:23:42.097: E/BatteryService(69): usbOnlinePath not found
12-02 09:23:42.097: E/BatteryService(69): batteryVoltagePath not found
12-02 09:23:42.097: E/BatteryService(69): batteryTemperaturePath not found
12-02 09:23:42.169: E/SurfaceFlinger(69): Couldn't open /sys/power/wait_for_fb_sleep or /sys/power/wait_for_fb_wake
12-02 09:23:50.036: E/EventHub(69): could not get driver version for /dev/input/mouse0, Not a typewriter
12-02 09:23:50.036: E/EventHub(69): could not get driver version for /dev/input/mice, Not a typewriter
12-02 09:23:50.377: E/System(69): Failure starting core service
12-02 09:23:50.377: E/System(69): java.lang.SecurityException
12-02 09:23:50.377: E/System(69): at android.os.BinderProxy.transact(Native Method)
12-02 09:23:50.377: E/System(69): at android.os.ServiceManagerProxy.addService(ServiceManagerNative.java:146)
12-02 09:23:50.377: E/System(69): at android.os.ServiceManager.addService(ServiceManager.java:72)
12-02 09:23:50.377: E/System(69): at com.android.server.ServerThread.run(SystemServer.java:184)
12-02 09:23:52.717: E/SoundPool(69): error loading /system/media/audio/ui/Effect_Tick.ogg
12-02 09:23:52.736: E/SoundPool(69): error loading /system/media/audio/ui/KeypressStandard.ogg
12-02 09:23:52.746: E/SoundPool(69): error loading /system/media/audio/ui/KeypressSpacebar.ogg
12-02 09:23:52.757: E/SoundPool(69): error loading /system/media/audio/ui/KeypressDelete.ogg
12-02 09:23:52.767: E/SoundPool(69): error loading /system/media/audio/ui/KeypressReturn.ogg
12-02 09:23:55.177: E/ThrottleService(69): Could not open GPS configuration file /etc/gps.conf
12-02 09:23:56.937: E/logwrapper(149): executing /system/bin/tc failed: No such file or directory
12-02 09:23:57.007: E/logwrapper(150): executing /system/bin/tc failed: No such file or directory
12-02 09:23:57.127: E/logwrapper(151): executing /system/bin/tc failed: No such file or directory
12-02 09:24:14.124: E/HierarchicalStateMachine(69): TetherMaster - unhandledMessage: msg.what=3

[Chrobione Robinson]

Fandy Akhmad wrote:

Tim Moores wrote:

Fandy Akhmad wrote:Nothing errors i found..

You need to look into whatever log file PHP writes to, and in the Android logcat output.

Here is logcat 'error'

12-02 09:23:27.497: E/Zygote(33): setreuid() failed. errno: 2
12-02 09:23:38.707: E/Zygote(33): setreuid() failed. errno: 17
12-02 09:23:42.097: E/BatteryService(69): usbOnlinePath not found
12-02 09:23:42.097: E/BatteryService(69): batteryVoltagePath not found
12-02 09:23:42.097: E/BatteryService(69): batteryTemperaturePath not found
12-02 09:23:42.169: E/SurfaceFlinger(69): Couldn't open /sys/power/wait_for_fb_sleep or /sys/power/wait_for_fb_wake
12-02 09:23:50.036: E/EventHub(69): could not get driver version for /dev/input/mouse0, Not a typewriter
12-02 09:23:50.036: E/EventHub(69): could not get driver version for /dev/input/mice, Not a typewriter
12-02 09:23:50.377: E/System(69): Failure starting core service
12-02 09:23:50.377: E/System(69): java.lang.SecurityException
12-02 09:23:50.377: E/System(69): at android.os.BinderProxy.transact(Native Method)
12-02 09:23:50.377: E/System(69): at android.os.ServiceManagerProxy.addService(ServiceManagerNative.java:146)
12-02 09:23:50.377: E/System(69): at android.os.ServiceManager.addService(ServiceManager.java:72)
12-02 09:23:50.377: E/System(69): at com.android.server.ServerThread.run(SystemServer.java:184)
12-02 09:23:52.717: E/SoundPool(69): error loading /system/media/audio/ui/Effect_Tick.ogg
12-02 09:23:52.736: E/SoundPool(69): error loading /system/media/audio/ui/KeypressStandard.ogg
12-02 09:23:52.746: E/SoundPool(69): error loading /system/media/audio/ui/KeypressSpacebar.ogg
12-02 09:23:52.757: E/SoundPool(69): error loading /system/media/audio/ui/KeypressDelete.ogg
12-02 09:23:52.767: E/SoundPool(69): error loading /system/media/audio/ui/KeypressReturn.ogg
12-02 09:23:55.177: E/ThrottleService(69): Could not open GPS configuration file /etc/gps.conf
12-02 09:23:56.937: E/logwrapper(149): executing /system/bin/tc failed: No such file or directory
12-02 09:23:57.007: E/logwrapper(150): executing /system/bin/tc failed: No such file or directory
12-02 09:23:57.127: E/logwrapper(151): executing /system/bin/tc failed: No such file or directory
12-02 09:24:14.124: E/HierarchicalStateMachine(69): TetherMaster - unhandledMessage: msg.what=3

Those logs are showing a different issue that is happening before your code is even ran...

Thins I would confirm:

I would check to make sure that my php code is working by passing the following url code

http://192.168.10.101/android/insert.php?username=validuser&password=validpassword

through the browser on the phone and on the dev computer.... ******Please change validuser and valid password to a user and password in the database and see if it gets a response. ******

Also clear the log view on logcat prior to running the application and also use the debug mode on eclipse.

hope this helps

-chrobi