Membuat Simple Web Service Dengan PHP ( PDO) + Json

1. koneksi.php
2. mhs.php
3. web_service.php
4. akses_web_service.php

class Koneksi {
    
    //DB name : test    protected $dns   = "mysql:host=localhost;dbname=test";     protected $db_user        = "root";    protected $db_pass     = "";    protected $konek   = "";           public function getKon() {                try{                              $db = new PDO($this->dns,$this->db_user,$this->db_pass);   $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);    if($db===FALSE){                           throw new Exception("Koneksi Gagal");                                }else{                            $this->konek = $db;    }                     }catch(Exception $e){                      echo "Error : ".$e->getMessage();     }
   return $this->konek;   }     public function closeKon(){                 $this->konek = NULL; //diskonek Koneksi    }}

/*
Kita sekalian buat Class active record simple
untuk fetch data ke DB */
class ActiveRecord extends Koneksi{            public function fetchObject($sql){          $clone = array();               try{
      $data =  $this->getKon()->prepare($sql);         $data->setFetchMode(PDO::FETCH_INTO,$this);      $data->execute(); 

           /* krena fetch ingin sbg Object, 
            maka kita hrus clone hasilnya */          while($result = $data->fetch()){                                          $clone[] = clone $result;      }
      $this->closeKon();                        }catch(PDOException $e){                          echo $e->getMessage();       }   
       return $clone;
   }}

require_once "koneksi.php";

class MhsWebService{
    
    protected $name;
    protected $umur;
    
    //misal API yg dikasih utk client
    protected $API = 'khss8363621';
    
    public function setName($name){
        
        $this->name = $name;
    }
    public function getName(){
        
        return $this->name;
    }
    
    public function setUmur($umur){
        
        $this->umur = $umur;
    }
    public function getUmur(){
        
        return $this->umur;
    }
    
    public function validateAPI($api){
        
        if($this->API !== $api)
            return false;
            
        return true;
    }
    
    
    public function getMhs(){
                                        
       $objAr= new ActiveRecord();
       
       /*Query blm pake bind params, silahkan edit sendiri*/
       $sql = "SELECT * FROM mhs WHERE 1=1  ";
          if($this->getName()){
                    
              $sql .=" AND nama LIKE '%{$this->getName()}%' ";
          }
          if($this->getUmur()){

            $sql .=" AND umur LIKE '%{$this->getUmur()}%' ";
          }
                
      return $objAr->fetchObject($sql);
       
    }   
}

validateAPI($s_API)){
    
    //kirim params" nya
    $mhs->setName($s_name);
    $mhs->setUmur($s_umur);
    
    $data = $mhs->getMhs();
    //print_r($data);
    reset($data);
    $i=0;
    //saya pake while, klo mau foreach silahkan :D
    while(list(,$r) =  each($data)){
        
        $hasil[$i]['nama'] = $r->nama;
        $hasil[$i]['umur'] = $r->umur;
        $hasil[$i]['alamat'] = $r->alamat;
        
        ++$i;
    }
   
   //hanya utk flag saja
   $hasil['status'] = TRUE;
    
}else{
    
    $hasil['status'] = FALSE;
}

echo json_encode($hasil);

?>

    
       
    
    
        
        
MHS Web Service
        

        

            Name  : 
            
            Umur  : 
            
            Search
        
          $s_name,
                    'umur' => $s_umur
                );
                
                $data = http_build_query($fields);

                $context = stream_context_create(array(
                    'http' =>  array(
                        'method'  => 'GET',
                        'header'  => 'Content-type: application/x-www-form-urlencoded',
                        'content' => $data,
                    )
                ));

                $result = file_get_contents($url, false, $context);
                //decode json nya ke array
                $vr = json_decode($result,true);
                
                echo "
";
                    print_r($vr);
                echo "
";
            }
            
        
        ?>
    

localhost/web-service/akses_web_service.php