Aplikasi Sistem Sekolah Android (3)

Untuk Mengkoneksikannya Kita Butuh File Php yang tersimpan di Htdocs, nah kita buat file tersebut.
  1. smember.php
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "sekolah";
mysql_connect($server, $username, $password) or die("<h1>Koneksi Mysql Error : </h1>" . mysql_error());
mysql_select_db($database) or die("<h1>Koneksi Kedatabase Error : </h1>" . mysql_error());
@$operasi = $_GET['operasi'];
switch ($operasi) {
   case "view":
         /* Source code untuk Menampilkan Biodata */
    
       $query_tampil_biodata = mysql_query("SELECT * FROM user") or die(mysql_error());
       $data_array = array();
       while ($data = mysql_fetch_assoc($query_tampil_biodata)) {
           $data_array[] = $data;
       }
       echo json_encode($data_array);
       //print json_encode($data_array);
       //[{"id":"1","nama":"Jhohannes H Purba","Alamat":"Kabanjahe"},{"id":"2","nama":"Berkat Junaidi Banurea","Alamat":"Sidikalang"},{"id":"3","nama":"Totok BluesMan Silalahi","Alamat":"Medan"}]
       break;
   case "insert":
       /* Source code untuk Insert data */
       @$nama = $_GET['nama'];
       @$alamat = $_GET['alamat'];
       @$telpon = $_GET['telpon'];
       $query_insert_data = mysql_query("INSERT INTO user (nama, alamat, telpon) VALUES('$nama', '$alamat', '$telpon')");
       if ($query_insert_data) {
           echo "Data Berhasil Disimpan";
       } else {
           echo "Error Inser Biodata " . mysql_error();
       }
       break;
   case "get_biodata_by_id":
       /* Source code untuk Edit data dan mengirim data berdasarkan id yang diminta */
       @$id = $_GET['id'];
       $query_tampil_biodata = mysql_query("SELECT * FROM user WHERE id='$id'") or die(mysql_error());
       $data_array = array();
       $data_array = mysql_fetch_assoc($query_tampil_biodata);
       echo "[" . json_encode($data_array) . "]";
       break;
   case "update":
       /* Source code untuk Updatedata */
       @$nama = $_GET['nama'];
       @$alamat = $_GET['alamat'];
       @$telpon = $_GET['telpon'];
       @$id = $_GET['id'];
       $query_update_biodata = mysql_query("UPDATE user SET nama='$nama', alamat='$alamat', telpon='$telpon' WHERE id='$id'");
       if ($query_update_biodata) {
           echo "Update Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   case "delete":
       /* Source code untuk Deletedata */
       @$id = $_GET['id'];
       $query_delete_biodata = mysql_query("DELETE FROM user WHERE id='$id'");
       if ($query_delete_biodata) {
           echo "Delete Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   default:
       break;
}
?>
  1. sobat
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "seapotik";
mysql_connect($server, $username, $password) or die("<h1>Koneksi Mysql Error : </h1>" . mysql_error());
mysql_select_db($database) or die("<h1>Koneksi Kedatabase Error : </h1>" . mysql_error());
@$operasi = $_GET['operasi'];
switch ($operasi) {
   case "view":
         /* Source code untuk Menampilkan Biodata */
    
       $query_tampil_biodata = mysql_query("SELECT * FROM obat") or die(mysql_error());
       $data_array = array();
       while ($data = mysql_fetch_assoc($query_tampil_biodata)) {
           $data_array[] = $data;
       }
       echo json_encode($data_array);
       //print json_encode($data_array);
       //[{"id":"1","nama":"Jhohannes H Purba","Alamat":"Kabanjahe"},{"id":"2","nama":"Berkat Junaidi Banurea","Alamat":"Sidikalang"},{"id":"3","nama":"Totok BluesMan Silalahi","Alamat":"Medan"}]
       break;
   case "insert":
       /* Source code untuk Insert data */
       @$jenis = $_GET['jenis'];
       @$nama = $_GET['nama'];
       @$stok = $_GET['stok'];
       @$apotik = $_GET['apotik'];
       @$harga = $_GET['harga'];
       $query_insert_data = mysql_query("INSERT INTO obat (jenis, nama, stok, apotik, harga) VALUES('$jenis', '$nama', '$stok', '$apotik', '$harga')");
       if ($query_insert_data) {
           echo "Data Berhasil Disimpan";
       } else {
           echo "Error Inser Biodata " . mysql_error();
       }
       break;
   case "get_biodata_by_id":
       /* Source code untuk Edit data dan mengirim data berdasarkan id yang diminta */
       @$id = $_GET['id'];
       $query_tampil_biodata = mysql_query("SELECT * FROM obat WHERE id='$id'") or die(mysql_error());
       $data_array = array();
       $data_array = mysql_fetch_assoc($query_tampil_biodata);
       echo "[" . json_encode($data_array) . "]";
       break;
   case "update":
       /* Source code untuk Updatedata */
       @$jenis = $_GET['jenis'];
       @$nama = $_GET['nama'];
       @$stok = $_GET['stok'];
       @$apotik = $_GET['apotik'];
       @$harga = $_GET['harga'];
       @$id = $_GET['id'];
       $query_update_biodata = mysql_query("UPDATE obat SET jenis='$jenis', nama='$nama', stok='$stok', apotik='$apotik', harga='$harga' WHERE id='$id'");
       if ($query_update_biodata) {
           echo "Update Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   case "delete":
       /* Source code untuk Deletedata */
       @$id = $_GET['id'];
       $query_delete_biodata = mysql_query("DELETE FROM obat WHERE id='$id'");
       if ($query_delete_biodata) {
           echo "Delete Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   default:
       break;
}
?>
  1. sapotik.php
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "seapotik";
mysql_connect($server, $username, $password) or die("<h1>Koneksi Mysql Error : </h1>" . mysql_error());
mysql_select_db($database) or die("<h1>Koneksi Kedatabase Error : </h1>" . mysql_error());
@$operasi = $_GET['operasi'];
switch ($operasi) {
   case "view":
         /* Source code untuk Menampilkan Biodata */
    
       $query_tampil_biodata = mysql_query("SELECT * FROM apotik") or die(mysql_error());
       $data_array = array();
       while ($data = mysql_fetch_assoc($query_tampil_biodata)) {
           $data_array[] = $data;
       }
       echo json_encode($data_array);
       //print json_encode($data_array);
       //[{"id":"1","nama":"Jhohannes H Purba","Alamat":"Kabanjahe"},{"id":"2","nama":"Berkat Junaidi Banurea","Alamat":"Sidikalang"},{"id":"3","nama":"Totok BluesMan Silalahi","Alamat":"Medan"}]
       break;
   case "insert":
       /* Source code untuk Insert data */
       @$nama = $_GET['nama'];
       @$alamat = $_GET['alamat'];
       @$pemilik = $_GET['pemilik'];
       @$telpon = $_GET['telpon'];
       $query_insert_data = mysql_query("INSERT INTO apotik (nama, alamat, pemilik, telpon) VALUES('$nama', '$alamat', '$pemilik', '$telpon')");
       if ($query_insert_data) {
           echo "Data Berhasil Disimpan";
       } else {
           echo "Error Inser Biodata " . mysql_error();
       }
       break;
   case "get_biodata_by_id":
       /* Source code untuk Edit data dan mengirim data berdasarkan id yang diminta */
       @$id = $_GET['id'];
       $query_tampil_biodata = mysql_query("SELECT * FROM apotik WHERE id='$id'") or die(mysql_error());
       $data_array = array();
       $data_array = mysql_fetch_assoc($query_tampil_biodata);
       echo "[" . json_encode($data_array) . "]";
       break;
   case "update":
       /* Source code untuk Updatedata */
       @$nama = $_GET['nama'];
       @$alamat = $_GET['alamat'];
       @$pemilik = $_GET['pemilik'];
       @$telpon = $_GET['telpon'];
       @$id = $_GET['id'];
       $query_update_biodata = mysql_query("UPDATE apotik SET nama='$nama', alamat='$alamat', pemilik='$pemilik', telpon='$telpon' WHERE id='$id'");
       if ($query_update_biodata) {
           echo "Update Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   case "delete":
       /* Source code untuk Deletedata */
       @$id = $_GET['id'];
       $query_delete_biodata = mysql_query("DELETE FROM apotik WHERE id='$id'");
       if ($query_delete_biodata) {
           echo "Delete Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   default:
       break;
}
?>
  1. stransaksi.php
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "seapotik";
mysql_connect($server, $username, $password) or die("<h1>Koneksi Mysql Error : </h1>" . mysql_error());
mysql_select_db($database) or die("<h1>Koneksi Kedatabase Error : </h1>" . mysql_error());
@$operasi = $_GET['operasi'];
switch ($operasi) {
   case "view":
         /* Source code untuk Menampilkan Transaksi */
    
       $query_tampil_transaksi = mysql_query("SELECT * FROM transaksi") or die(mysql_error());
       $data_array = array();
       while ($data = mysql_fetch_assoc($query_tampil_transaksi)) {
           $data_array[] = $data;
       }
       echo json_encode($data_array);
       //print json_encode($data_array);
       //[{"id":"1","nama":"Jhohannes H Purba","Alamat":"Kabanjahe"},{"id":"2","nama":"Berkat Junaidi Banurea","Alamat":"Sidikalang"},{"id":"3","nama":"Totok BluesMan Silalahi","Alamat":"Medan"}]
       break;
   case "insert":
       /* Source code untuk Insert data */
       @$namauser = $_GET['namauser'];
       @$namaobat = $_GET['namaobat'];
       @$namaapotik = $_GET['namaapotik'];
       @$tanggal = $_GET['tanggal'];
       $query_insert_data = mysql_query("INSERT INTO transaksi (namauser, namaobat, namaapotik, tanggal) VALUES('$namauser', '$namaobat', '$namaapotik', '$tanggal')");
       if ($query_insert_data) {
           echo "Data Berhasil Disimpan";
       } else {
           echo "Error Inser Transaksi " . mysql_error();
       }
       break;
   case "get_transaksi_by_id":
       /* Source code untuk Edit data dan mengirim data berdasarkan id yang diminta */
       @$id = $_GET['id'];
       $query_tampil_transaksi = mysql_query("SELECT * FROM transaksi WHERE id='$id'") or die(mysql_error());
       $data_array = array();
       $data_array = mysql_fetch_assoc($query_tampil_transaksi);
       echo "[" . json_encode($data_array) . "]";
       break;
   case "update":
       /* Source code untuk Updatedata */
       @$namauser = $_GET['namauser'];
       @$namaobat = $_GET['namaobat'];
       @$namaapotik = $_GET['namaapotik'];
       @$tanggal = $_GET['tanggal'];
       @$id = $_GET['id'];
       $query_update_transaksi = mysql_query("UPDATE transaksi SET namauser='$namauser', namaobat='$namaobat', namaapotik='$namaapotik', tanggal='$tanggal' WHERE id='$id'");
       if ($query_update_transaksi) {
           echo "Update Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   case "delete":
       /* Source code untuk Deletedata */
       @$id = $_GET['id'];
       $query_delete_transaksi = mysql_query("DELETE FROM transaksi WHERE id='$id'");
       if ($query_delete_transaksi) {
           echo "Delete Data Berhasil";
       } else {
           echo mysql_error();
       }
       break;
   default:
       break;
}

?>

Komentar

Posting Komentar

Postingan populer dari blog ini

Aplikasi kamus bahasa isyarat indonesia 1

Gambar
Halaman ini berisi list angka apabila  list  tersebut  ditekan  maka akan  muncul sebuah  gerak isyarat sesuai yang dipilih. Menu isyarat angka satu 1. Bilangan.java package com.example.bisi; import android.support.v7.app.ActionBarActivity; import android.os.Bundle; import android.view.Menu; import android.view.MenuItem; public class Bilangan extends ActionBarActivity { @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_bilangan); } @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.bilangan, menu); return true; } @Override public boolean onOptionsItemSelected(MenuItem item) { // Handle action bar item clicks here. The action bar will // automatically handle clicks on the Home/Up button, so long // a...
Baca selengkapnya

Aplikasi kamus bahasa isyarat indonesia 2

package com.example.coba; import android.os.Bundle; import android.app.Activity; import android.content.Intent; import android.view.Menu; import android.view.View; import android.widget.AdapterView; import android.widget.ListView; import android.widget.AdapterView.OnItemClickListener; public class Imbuhan extends Activity { Integer[] image = {R.drawable.lebih, R.drawable.maaf, R.drawable.minum, R.drawable.makasih, R.drawable.lebih}; String[] name = {"Lebih","Maaf","Minum","Makasih","Suka"}; ListView listview; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_list); listview = (ListView) findViewById(R.id.listview); Custom adapter = new Custom(Imbuhan.this, name, image); listview.setAdapter(adapter); listview.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(Adapte...
Baca selengkapnya

Aplikasi kamus bahasa isyarat indonesia 3

Android Mengunggah Gambar Kamera, gambar ke Server dengan Progress Bar package com.example.coba; import android.os.Bundle; import android.app.Activity; import android.content.Intent; import android.view.Menu; import android.view.View; import android.widget.AdapterView; import android.widget.ListView; import android.widget.AdapterView.OnItemClickListener; public class Imbuhan extends Activity {                                 Integer[] image = {R.drawable.lebih, R.drawable.maaf, R.drawable.minum, R.drawable.makasih, R.drawable.lebih};                 String[] name = {"Lebih","Maaf","Minum","Makasih","Suka"};                 ListView listview;   ...
Baca selengkapnya