SC

<?php

require_once("konak.php");

//cari kode
$sql = mysql_query("SELECT * FROM historyall1 WHERE status != 'Sukses'");
while($data = mysql_fetch_array($sql)){
$order_id = $data['order_id'];
$order_lm = $data['no'];
$nmny = $data['pembeli'];
$harga = $data['harga'];

//Ambil Kode Uplink
$uplinknya = mysql_query("SELECT * FROM user WHERE username = '$nmny' ");
$cekkode = mysql_fetch_array($uplinknya);
$kode_ref = $cekkode['id'];
$nama_ref = $cekkode['username'];
$url = 'http://portalpulsa.com/api/connect/';

$header = array(
'portal-userid: 2',
'portal-key: 2', // lihat hasil autogenerate di member area
'portal-secret: 2', // lihat hasil autogenerate di member area
);

$data = array(
'inquiry' => 'STATUS', // konstan
'trxid_api' => $order_id // Ini diambil dari database web saya..
);

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

echo $result;
$data = json_decode($result);
foreach($data->message as $datanya){
            $sts = $datanya->status."</br>";
            $note = $datanya->sn;
            $info = $datanya->note;
            $kodenya = $datanya->trxid_api;
            }
                if ($sts == 4){
                    $send = mysql_query("UPDATE historyall1 SET status = 'Sukses' WHERE order_id = '$order_id' AND status != 'Sukses'");
                    $send = mysql_query("UPDATE log_ref SET status = 'Sukses' WHERE order_id = '$order_id' AND status != 'Sukses'");
                    $send = mysql_query("INSERT INTO log_note VALUES ('$kodenya','$order_lm','$note')");
                    //INI KIRIM SALDO NYA
                    $send = mysql_query("UPDATE user SET balance = balance+50 WHERE username = '$nama_ref'");
                        if ($send){
                            echo "Sukses ganti status";
                        }else{
                            echo "Gagal ganti status";
                        }
                }else if ($sts == 2){
                    $send = mysql_query("UPDATE historyall1 SET status = 'Failed' WHERE order_id = '$order_id' AND status != 'Failed'");
                    $send = mysql_query("UPDATE log_ref SET status = 'Failed' WHERE order_id = '$order_id' AND status != 'Failed'");

                        if ($send && mysql_affected_rows() > 0){
                            $catat = mysql_query("UPDATE log_note SET note = '$note' WHERE kode = '$order_id'");

                            echo "Sukses ganti status";
                        }else{
                            echo "Gagal ganti status";
                        }
                }else if ($sts == 3){
                    $send = mysql_query("UPDATE historyall1 SET status = 'Refund' WHERE order_id = '$order_id' AND status != 'Refund'");
                    $send = mysql_query("UPDATE log_ref SET status = 'Refund' WHERE order_id = '$order_id' AND status != 'Refund'");
                    if ($send && mysql_affected_rows() > 0){
                        $kirim = mysql_query("INSERT INTO log_note VALUES ('$kodenya','$order_lm','$note')");
                        $kirim = mysql_query("UPDATE user SET balance = balance+$harga WHERE username = '$nmny'");
                        if ($kirim){
                            echo "Mntap..";
                        }else{
                            echo "Gagal kriim..";
                        }
                    }else{

                    }
                }
                      ?>
        Order Id = <?php echo $order_id; ?><br>
        Statusnya = <?php echo $sts; ?><br>
        namanya = <?php echo $nmny; ?><br>

<? } ?>