Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once"../konmysqli.php";
- $respon = array();
- if (isset($_GET["username"])) {
- $username= $_GET['username'];
- $password= $_GET['password'];
- $sql="SELECT * FROM `$tbpengelola` WHERE `username` ='$username' and `password`='$password'";
- $jum=getJum($conn,$sql);
- if ($jum>0) {
- $d=getField($conn,$sql);
- $record = array();
- $kode_pengelola=$d["kode_pengelola"];
- $nama_pengelola=$d["nama_pengelola"];
- $alamat=$d["alamat"];
- $telepon=$d["telepon"];
- $username=$d["username"];
- $password=$d["password"];
- $keterangan=$d["keterangan"];
- $status=$d["status"];
- $record["xmlbio"] = "$kode_pengelola#$nama_pengelola#$alamat#$telepon#$username#$password#$keterangan#$status";
- $respon["sukses"] = 1;
- $respon["record"] = array();
- array_push($respon["record"], $record);
- $respon["pesan"] = "$jum record";
- echo json_encode($respon);
- } else {
- $respon["sukses"] = 0;
- $respon["pesan"] = "0 record";
- echo json_encode($respon);
- }
- } else {
- $respon["sukses"] = 0;
- $respon["pesan"] = "? lengkapi data";
- echo json_encode($respon);
- }
- ?>
- <?php
- function getJum($conn,$sql){
- $rs=$conn->query($sql);
- $jum= $rs->num_rows;
- $rs->free();
- return $jum;
- }
- function getField($conn,$sql){
- $rs=$conn->query($sql);
- $rs->data_seek(0);
- $d= $rs->fetch_assoc();
- $rs->free();
- return $d;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement