Aplikasi client server database android sebagai client akan berhubungan dengan mysql server dengan perantara php, secara konsep dasar di gambarkan sebagai berikut :
*ANDROID - PHP - MYSQL SERVER* http://nsafaat.wordpress.com/2011/07/27/form-master-entry-data-ke-mysql-server-berbasis-android/ Tabel user. ----------------------------------------------------------------------------------------- create table user { username varchar(20) NOT NULL, password varchar(20) NOT NULL, repassword varchar(20) NOT NULL, nama_lengkap varchar(40), jekel varchar(10), alamat varchar(30), nomor_tlp varchar(10), nomor_hp varchar(12), PRIMARY KEY (`username`) ) ----------------------------------------------------------------------------------------- simpan.php ---------------------------------------------------------------------------------------- <?php $un=$_POST['username']; $pw=$_POST['password']; $rpw=$_POST['repassword']; $nl=$_POST['nama']; $jk=$_POST['jekel']; $al=$_POST['alamat']; $nt=$_POST['nomor_tlp']; $nh=$_POST['nomor_hp']; $conn = mysql_connect("localhost","root",""); mysql_select_db("latihan"); $query = "INSERT INTO user (username,password,repassword,nama_lengkap,jekel,alamat,nomor_tlp,nomor_hp) values ('$un','$pw','$rpw','$nl','$jk','$al','$nt','$nh')"; $result = mysql_query($query) or die("REPORTGagal Query Simpan DATA."); ?> ------------------------------------------------------------- main.xml ------------------------------------ <?xml version="1.0" encoding="utf-8"?> <ScrollView xmlns:android="http://schemas.android.com/apk/res/android"; android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent" android:background="#ff00ffff" > <TableLayout xmlns:android="http://schemas.android.com/apk/res/android"; android:layout_width="fill_parent" android:layout_height="fill_parent" > <TextView android:text="Silakan Masukkan Data Pengguna" android:layout_width="match_parent" android:layout_height="match_parent" android:textColor="#ff0000ff" /> <TableRow android:baselineAligned="true" android:layout_width="match_parent"> <TextView android:text="Username:" android:layout_width="match_parent" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:id="@+id/et_un" android:maxWidth="140sp" android:layout_height="wrap_content" android:layout_width="match_parent" android:layout_gravity="center_vertical" > </EditText> </TableRow> <TableRow> <TextView android:text="Password:" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:id="@+id/et_pw" android:layout_height="wrap_content" android:layout_width="match_parent" android:layout_gravity="center_vertical" android:inputType="textPassword"> </EditText> </TableRow> <TableRow> <TextView android:text="retype-Password:" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:layout_height="wrap_content" android:id="@+id/et_rpw" android:layout_width="match_parent" android:inputType="textPassword"> </EditText> </TableRow> <TableRow> <TextView android:text="Nama Lengkap:" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:layout_height="wrap_content" android:id="@+id/et_nama" android:layout_width="match_parent"> </EditText> </TableRow> <TableRow> <TextView android:text="Jekel:" android:textColor="#ff0000ff"/> <RadioGroup android:id="@+id/jekel"> <RadioButton android:id="@+id/pria" android:text="Pria" /> <RadioButton android:id="@+id/perempuan" android:text="Perempuan" /> </RadioGroup> </TableRow> <TableRow> <TextView android:text="Alamat:" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:layout_height="wrap_content" android:id="@+id/et_alamat" android:layout_width="match_parent"> </EditText> </TableRow> <TableRow> <TextView android:text="Nomor Tlp:" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:layout_height="wrap_content" android:id="@+id/et_notel" android:layout_width="match_parent"> </EditText> </TableRow> <TableRow> <TextView android:text="Nomor HP:" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> <EditText android:layout_height="wrap_content" android:id="@+id/et_nohp" android:layout_width="match_parent"> </EditText> </TableRow> <TableRow > <Button android:text="S I M P A N" android:id="@+id/btn_simpan" android:layout_width="wrap_content" android:layout_height="wrap_content"> </Button> <Button android:text="K E L U A R" android:id="@+id/btn_keluar" android:onClick="keluar" android:layout_width="wrap_content" android:layout_height="wrap_content"> </Button> </TableRow> <TextView android:text="" android:id="@+id/error" android:layout_width="wrap_content" android:layout_height="wrap_content" android:textColor="#ff0000ff" /> </TableLayout> </ScrollView> ------------------------------------ tambah_user.java ------------------------------------ package com.wilis.entrydatamysql; import java.util.ArrayList; import org.apache.http.NameValuePair; import org.apache.http.message.BasicNameValuePair; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.RadioGroup; import android.widget.TextView; public class tambah_user extends Activity { EditText un,pw,rpw,nl,al,nt,nh; RadioGroup jk; TextView error; Button simpan,keluar; /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.tambah_user); un=(EditText)findViewById(R.id.et_un); pw=(EditText)findViewById(R.id.et_pw); rpw=(EditText)findViewById(R.id.et_rpw); nl=(EditText) findViewById(R.id.et_nama); jk=(RadioGroup) findViewById(R.id.jekel); al=(EditText) findViewById(R.id.et_alamat); nt=(EditText) findViewById(R.id.et_notel); nh=(EditText) findViewById(R.id.et_nohp); simpan=(Button)findViewById(R.id.btn_simpan); keluar=(Button)findViewById(R.id.btn_keluar); error=(TextView)findViewById(R.id.error); simpan.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub //atur variabel utk menampung pilihan jenis kelamin String type=null; switch (jk.getCheckedRadioButtonId()) { case R.id.pria: type="Pria"; break; case R.id.perempuan: type="Perempuan"; break; } ArrayList<NameValuePair> postParameters = new ArrayList<NameValuePair>(); postParameters.add(new BasicNameValuePair("username", un.getText().toString())); postParameters.add(new BasicNameValuePair("password", pw.getText().toString())); postParameters.add(new BasicNameValuePair("repassword", rpw.getText().toString())); postParameters.add(new BasicNameValuePair("nama", nl.getText().toString())); postParameters.add(new BasicNameValuePair("jekel", type)); postParameters.add(new BasicNameValuePair("alamat", al.getText().toString())); postParameters.add(new BasicNameValuePair("nomor_tlp", nt.getText().toString())); postParameters.add(new BasicNameValuePair("nomor_hp", nh.getText().toString())); /* String valid = "1";*/ String response = null; try { response = CustomHttpClient.executeHttpPost("http://10.0.2.2/hellomysql/simpan.php";, postParameters); String res = response.toString(); res = res.trim(); res = res.replaceAll("\\s+",""); error.setText(res); } catch (Exception e) { un.setText(e.toString()); } } }); } public void keluar (View theButton) { Intent a = new Intent (this,login.class); startActivity(a); } } ------------------------------------ CustomHttpClient.java ------------------------------------ package com.wilis.formloginmysql; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; import java.net.URI; import java.util.ArrayList; 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.HttpGet; import org.apache.http.client.methods.HttpPost; import org.apache.http.conn.params.ConnManagerParams; import org.apache.http.impl.client.DefaultHttpClient; import org.apache.http.params.HttpConnectionParams; import org.apache.http.params.HttpParams; public class CustomHttpClient { /** The time it takes for our client to timeout */ public static final int HTTP_TIMEOUT = 30 * 1000; // milliseconds /** Single instance of our HttpClient */ private static HttpClient mHttpClient; /** * Get our single instance of our HttpClient object. * * @return an HttpClient object with connection parameters set */ private static HttpClient getHttpClient() { if (mHttpClient == null) { mHttpClient = new DefaultHttpClient(); final HttpParams params = mHttpClient.getParams(); HttpConnectionParams.setConnectionTimeout(params, HTTP_TIMEOUT); HttpConnectionParams.setSoTimeout(params, HTTP_TIMEOUT); ConnManagerParams.setTimeout(params, HTTP_TIMEOUT); } return mHttpClient; } /** * Performs an HTTP Post request to the specified url with the * specified parameters. * * @param url The web address to post the request to * @param postParameters The parameters to send via the request * @return The result of the request * @throws Exception */ public static String executeHttpPost(String url, ArrayList<NameValuePair> postParameters) throws Exception { BufferedReader in = null; try { HttpClient client = getHttpClient(); HttpPost request = new HttpPost(url); UrlEncodedFormEntity formEntity = new UrlEncodedFormEntity(postParameters); request.setEntity(formEntity); HttpResponse response = client.execute(request); in = new BufferedReader(new InputStreamReader(response.getEntity().getContent())); StringBuffer sb = new StringBuffer(""); String line = ""; String NL = System.getProperty("line.separator"); while ((line = in.readLine()) != null) { sb.append(line + NL); } in.close(); String result = sb.toString(); return result; } finally { if (in != null) { try { in.close(); } catch (IOException e) { e.printStackTrace(); } } } } /** * Performs an HTTP GET request to the specified url. * * @param url The web address to post the request to * @return The result of the request * @throws Exception */ public static String executeHttpGet(String url) throws Exception { BufferedReader in = null; try { HttpClient client = getHttpClient(); HttpGet request = new HttpGet(); request.setURI(new URI(url)); HttpResponse response = client.execute(request); in = new BufferedReader(new InputStreamReader(response.getEntity().getContent())); StringBuffer sb = new StringBuffer(""); String line = ""; String NL = System.getProperty("line.separator"); while ((line = in.readLine()) != null) { sb.append(line + NL); } in.close(); String result = sb.toString(); return result; } finally { if (in != null) { try { in.close(); } catch (IOException e) { e.printStackTrace(); } } } } } ------------------------------------------------------------ -- "Indonesian Android Community" Join: http://forum.android.or.id =============== Join ID-ANDROID Developers http://groups.google.com/group/id-android-dev --------------------- Gunakan Paket Unlimited Data XL Mobile Broadband http://www.xl.co.id/XLInternet/BroadbandInternet -------------------- PING'S Mobile - Plaza Semanggi E-mail: [email protected] Ph. 021-25536796 -------------------- i-gadget Store - BEC Bandung E-mail: [email protected] Ph. 0812-21111191 -------------------- Toko EceranShop - BEC Bandung E-mail: [email protected] Ph. 0815-56599888 =============== Aturan Jualan dan Kloteran ID-Android http://goo.gl/YBN21
