<?php
$host = "localhost";
$user = "borneope_jon123";
$pass = "jon1234509876";
$db = "borneope_jon123";
$konek = mysql_connect($host, $user, $pass) or die ('Koneksii Gagal! ');
mysql_select_db($db);
class Api
   {
       public $api_url = 'https://sosmedpedia.com/api.php'; // API URL

      public $api_key = 'SOSPED-289739fbf6a4f054e3bf330b0cdecb04'; // Your API key

      public function status($order_id) { // Get status, remains
        return json_decode($this->connect(array(
          'api' => $this->api_key,
          'action' => 'cekin',
          'id' => $order_id
        )));
      }


      private function connect($post) {
        $_post = Array();
        if (is_array($post)) {
          foreach ($post as $name => $value) {
            $_post[] = $name.'='.urlencode($value);
          }
        }
        $ch = curl_init($this->api_url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
        if (is_array($post)) {
          curl_setopt($ch, CURLOPT_POSTFIELDS, join('&', $_post));
        }
        curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)');
        $result = curl_exec($ch);
        echo $result;
        if (curl_errno($ch) != 0 && empty($result)) {
          $result = false;
        }
        curl_close($ch);
        return $result;
      }
   }



$result = mysql_query("SELECT * FROM history_socmed WHERE status != 'Completed' AND provider = 'BORNEO' ORDER BY id ASC");
 while($row = mysql_fetch_array($result))
  {
$statusnya      = $row['status'];
$id_order       = $row['id_order'];
$nomer          = $row['no'];


   // Examples
$api = new Api();
$status = $api->status($id_order);
$check  = $status->datanya->status;

if($check == '4'){
$provice = 'Canceled';
$save = mysql_query("UPDATE history_socmed SET status = '$provice' WHERE id_order = '$id_order'");
if($save){
echo 'Sukses Update '.$id_order.' Link : '.$status->data->link;
}
} else if($check == '2'){
$provice = 'Completed';
$save = mysql_query("UPDATE history_socmed SET status = '$provice' WHERE id_order = '$id_order'");
if($save){
echo 'Sukses Update '.$id_order.' Link : '.$status->data->link;
}
} else {
$provice = $check;
$save = mysql_query("UPDATE history_socmed SET status = '$provice' WHERE id_order = '$id_order'");
if($save){
echo 'Sukses Update '.$id_order.' Link : '.$status->data->link.' Stausnya '.$statusnya;
}
}


}
?>