<?php
function sendsms_get($username, $password, $message, $senderid, $recipients)
{
    $message = urlencode($message);
    $senderid = urlencode($senderid);
    //$url = 'http://api.smartsmssolutions.com/smsapi.php?username=aspoa&password=aepies12&balance=true&';
  //$url='http://api.smartsmssolutions.com/smsapi.php?username='.$username.'&password='.$password.'&sender='.$senderid.'&recipient='.$recipients.'&message='.$message.'&';
  $url='http://api.smartsmssolutions.com/smsapi.php?username=aspoa&password=aepies12&sender=FedPolyEde&recipient='.$recipients.'&message='.$message;

    $send = file_get_contents($url);
    return $send;
}
//$username = 'aspoa';
//$password = 'aepies12';
$count=0;
$noCount=0;
$start=0;
$end=0;

/*if (isset($_GET['id'])){
    $id=$_GET['id'];
}else{
    die('ID Error');
}*/
require_once('../connect.php');
$db=db_connect();
//for($i=1;$i)

    //$trans=substr($phoneNumber,7);

//    $sql_venue=$db->query("select * from venuetb where smsSent=0 and used=0 and formNo like '18%'");
//echo "select * from eace_admitted where closed=0 and used=0";
 $sql_venue=$db->query("select * from eace_admitted where sent=0 and used=0");
      $sql_venue_num=$sql_venue->rowCount();

    while ($row = $sql_venue->fetch(PDO::FETCH_BOTH)) {
        $formNo = $row['formNo'];


       $course=$row['course'];



             $gsm = $row['sex'];
             echo $gsm=2348034496359;
//            echo $gsm=2348034496359;
//        echo $row['names'];
        $sur=explode(' ',$row['names']);
            $surname=$sur[0];

            echo '<br>';
//        }
        //end of phone no


//        $message = '<b>Dear '. $surname. ', <br>Screening Details:</b> Date:' . $day . ', Venue:' . $venue . ', Time:' . $sTime.'Reprint your Application Form.' ;
      echo  $message = '<b>Dear '. $surname. ', <br>You have been admitted to study for Dual Awards in ' . $course.'. Check Admission Status on www.federalpolyede.edu.ng/eace_entranceForm/adminStatus.php. For enqueries Call/WhatsApp 08092000666.' ;
        // echo $message='You have been invited for an entrance Exam on '. $day .' by '.$sTime. ' @ '. $venue.' also advised to reprint your completed form and bring it along';
//        echo $row['sn'];


//$message = 'I dey';
        $senderid = 'FedPolyEde';
        $recipients = $gsm;
        $username = 'aspoa';
        $password = 'aepies12';
        $url = 'http://api.smartsmssolutions.com/smsapi.php';
//        echo $username. $password. $message. $senderid.$recipients;
        $get_sms = sendsms_get($username, $password, $message, $senderid, $recipients);
        if ($get_sms) {
//            echo "am here";
//            echo "am here";
            $count += 1;
//            $db->query("UPDATE `fedpoly`.`venuetb` SET `smsSent` = '1' WHERE `venuetb`.`formNo` = '$formNo'");
            $db->query("UPDATE `fedpoly`.`eace_admitted` SET `sent` = '1' WHERE `eace_admitted`.`formNo` = '$formNo'");

        } else {
            $noCount += 1;
        }
        die($get_sms);
    }
    echo $count . 'Messages Sent<br>';
    echo $noCount . 'Message rejected';
//$recipients='2348034496359';
//$get_sms = sendsms_get($username, $password, $message2, $senderid, $recipients);
if ($sql_venue_num>0){
//    echo $get_sms;
//    echo $row['sn'];
//    echo $url;
//    echo $sql_venue_num;
}else{
   echo "No record";
}

//http://api.smartsmssolutions.com/smsapi.php?username=YourUsername&password=YourPassword&sender=SenderID&recipient=234809xxxxxxx,2348030000000&message=YourMessage


//Below is the API cofiguration for CHECK SMS Balance.
//http://api.smartsmssolutions.com/smsapi.php?username=aspoa&password=aepies12&balance
?>