<?php
$host="localhost";
$user="root";
$passw="";
$database="demo";

$conn=mysql_connect($host,$user,$passw);
if(! $conn){
    echo "Koneksi Gagal";
}

mysql_select_db($database) or
die ("Database tidak tersedia");

    if($_REQUEST['act']=='show'){
        $query=mysql_query("select * from member order by id");
           //$i=mysql_query("select * from member",$con);
           $num_rows = mysql_num_rows($query);
           $check='';
          while($row = mysql_fetch_array($query))
            {
                  $r[]=$row;
                  $check=$row['id'];
             }
         if($check==NULL)
           {
                      $r[$num_rows]="Record is not available";
                      print(json_encode($r));
             }
            else
             {
                $r[$num_rows]="success";
                 print(json_encode($r));
              }

    }elseif($_REQUEST['act']=='save'){
        $username=$_POST['username'];
        $email=$_POST['email'];
        $fullname=$_POST['fullname'];
        $password=$_POST['password'];
        $query="insert into member values ('$id','$username','$email','$fullname','$password')";
        mysql_query($query);
    }elseif($_REQUEST['act']=='del'){
        $email=$_POST['email'];
        $delete="DELETE FROM `demo`.`member` WHERE `member`.`email` ='".$email."'";
        mysql_query($delete);
    }elseif($_REQUEST['act']=='update'){
        $id=$_POST['id'];
        $username=$_POST['username'];
        $email=$_POST['email'];
        $email1=$_POST['email1'];
        $fullname=$_POST['fullname'];
        $password=$_POST['password'];
        $update="update member set username='$username', email='$email',fullname='$fullname',password='$password' where email='$email1'";
        mysql_query($update);

    }elseif($_REQUEST['act']=='search'){
        $pil=$_REQUEST['pil'];
        $input=$_REQUEST['parameter'];
        $cari = "SELECT * FROM pemesanan where $pil like '%$input%' order by ID";
        $hasil = mysql_query($cari);

           //$i=mysql_query("select * from pemesanan",$con);
           $num_rows = mysql_num_rows($hasil);
           $check='';
          while($row = mysql_fetch_array($hasil))
            {
                  $r[]=$row;
                  $check=$row['ID'];
             }
         if($check==NULL)
           {
                      $r[$num_rows]="Record is not available";
                      print(json_encode($r));
             }
            else
             {
                $r[$num_rows]="success";
                 print(json_encode($r));
              }
    }else
        echo "Act Parameter is missing!!!"
?>