load_data_petugas php

<?php
include "koneksi.php";
include "notice.php";
 if($_SERVER['REQUEST_METHOD']=='POST'){

         $email = $_POST['email'];
        // $email = 'as@gmail.com';
/*
         if($email!=""){
            $sql = "SELECT * FROM user WHERE id_user='$email' ";
            $result = $conn->query($sql);
         }
*/

$sql = "SELECT a.* FROM daftar_usaha_umkm a
        JOIN user b on b.id_user=a.id_user
        WHERE b.email='$email' ";
$result = $conn->query($sql);

if ($result->num_rows >0) {
     // output data of each row
     while($row[] = $result->fetch_assoc()) {

         $tem = $row;

         $json = json_encode($tem);
     echo "success";

     }

    echo $json;
    $conn->close();

}

    }else {

      echo "Pesan Web : Tidak Konek dengan Server";

    }

?>