Advertisement
Guest User

JSON php

a guest
Mar 27th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. <?php
  2.  define('HOST','localhost');
  3.  define('USER','root');
  4.  define('PASS','');
  5.  define('DB','absensi');
  6.  
  7.  $con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect');
  8.  
  9.  ?>
  10.  
  11.  
  12. <?php
  13.  
  14.  if($_SERVER['REQUEST_METHOD']=='POST'){
  15.  //Dapatkan Data
  16.  $username = $_POST['username'];
  17.  $password = $_POST['password'];
  18.  $group = $_POST['group'];
  19.  
  20.  //Membuat SQL Query
  21.  $sql = "SELECT * FROM user WHERE username='$username' AND password='$password'";
  22.  
  23.  //memanggil file koneksi
  24.  include 'koneksi.php';
  25.  
  26.  //exsekusi query
  27.  $result = mysqli_query($con,$sql);
  28.  
  29.  //fetching hasil
  30.  $check = mysqli_fetch_array($result);
  31.  $dgroup = $check['group'];
  32.  
  33.  //jika dapatkan beberapa data
  34.  if(isset($check) && $dgroup == $group){
  35.  //tampilkan sukses
  36.  echo "success";
  37.  }else{
  38.  //tampilkan failure
  39.  echo "failure";
  40.  }
  41.  //tutup koneksi
  42.  mysqli_close($con);
  43.  }
  44.  
  45.  ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement