Vn65zzkz

1<?php
2$username = $_POST['username'];
3$password = $_POST['password'];
4$con = mysqli_connect("localhost","root","","dbsekolah");
5$sql = "INSERT INTO tbuser (username , password) VALUES ('$username', '$password')";
6$json["hasil"]=array();
7if($con->query($sql) === TRUE) {
8$json["hasil"]["respon"]=true;
9}else{
10$json["hasil"]["respon"]=false;
11}
12echo json_encode($json);
13?>
14
15
16*Back End
17I. Buatlah tabel user (tbuser)
18dengan kolom :
19id int 10 auto increment primary Key
20username varchar 50
21password varchar 50
22
23
24II. kemudian isi lah dengan
25username : admin
26password : admin
27(bebas)
28
29III. Buat file php nya (API), copas dari google classroom (posting yang atas)
30*Android Front End
31-Buat project baru,
32-Set up graddle nya untuk Fast Android Networking
33https://github.com/amitshekhariitbhu/Fast-Android-Networking
34-manifest internet
35-Buat layout login
36-Implementasikan API login
37
38
39
40<?php
41$Email = $_POST['Email'];
42$Password = $_POST['Password'];
43$con = mysqli_connect("localhost","root","","dbrusmart");
44$sql = "select * from tblogin where username = '$Email' and password = '$Password' ";
45$json["hasil"]=array();
46$result = mysqli_query($con,$sql);
47$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
48$count = mysqli_num_rows($result);
49if($count > 0) {
50$json["hasil"]["sukses"]=true;
51}else{
52$json["hasil"]["gagal"]=false;
53}
54echo json_encode($json);
55?>
56
57
58<?php
59$con = mysqli_connect("localhost","root","","dbsiswa");
60
61$sql = "SELECT * from tbsiswa";
62$i=0;
63$json["result"]=array();
64$result=mysqli_query($con,$sql);
65while($row = mysqli_fetch_assoc($result)){
66$arr_result=$row;
67array_push($json["result"],$arr_result);
68}
69mysqli_close($con);
70echo json_encode($json);
71?>
72
73
74Yang sudah selesai tugas tutorial dan bangun datar, silahkan bisa dikirimkan projectnya dengan ketentuan sbb
75
76email : ajisuryawan123@gmail.com
77subj : tugas11rplapps
78file : tugas11rplapps.rar
79
80kemudian bisa lanjut ke tutorial selanjutnya. terima kasih