SALDO

<?php

require_once("konak.php");


                    $url = 'http://smsgateway.me/api/v3/messages/view/44119311';
                    $data = array(
                    'URL' => 'http://smsgateway.me/api/v3/messages/view/44079884',
                    'Method' => 'GET',
                    'email' => '',
                    'password' => '',


                    );

                    $ch = curl_init();
                    curl_setopt($ch, CURLOPT_URL, $url);
                    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
                    curl_setopt($ch, CURLOPT_POST, 1);
                    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
                    curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
                    $result = curl_exec($ch);

                    //echo $result;
                    $data = json_decode($result);
                    $hasil = $data->result->message;
                    //echo $hasil;

                        $pisah_1 = explode('pulsa ',$hasil);
                        $pisah_2 = explode('.',$pisah_1[1]);
                        $hasil2 = $pisah_2[0];
                        $hasil3 = $hasil2;
                        echo $hasil3;

                        $send = mysql_query("UPDATE request_balance SET status = 'Success' WHERE quantity = '$hasil2' AND status != 'Success'");
                        //Cek username
                        $queri = mysql_query("SELECT * FROM request_balance WHERE quantity = '$hasil2'");
                                $get = mysql_fetch_array($queri);
                                $usernya = $get['username'];
                                $sts = $get['status'];
                        //Mengupdate balance
                        if ($send && mysql_affected_rows() > 0){
                            $kirim = mysql_query("UPDATE user SET balance=balance+$hasil2 WHERE username = '$usernya'");
                            echo "berhasil";
                        }else{
                            $kirim = mysql_query("UPDATE user SET balance=balance+0 WHERE username = '$usernya'");
                            echo "Gagal";
                        }


                    ?>