<?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%'");
$sql_venue=$db->query("select * from ace_admitted where sent=0 and used=0 and batch=20");
     $sql_venue_num=$sql_venue->rowCount();

    while ($row = $sql_venue->fetch(PDO::FETCH_BOTH)) {
        $formNo = $row['formNo'];
       $course=$row['course'];
              $gsm = '234' . $row['gsm'];
            $names=explode(' ',$row['names']);
//            echo '<br>';
        $message = '<b>Dear '. $names[0]. ', <br>You have been admitted to study ' . $course.'. Check Admin Status on www.federalpolyede.edu.ng.Call 08092000666/08034274705.' ;
//        echo $row['sn'];
//        die();

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

        } else {
            $noCount += 1;
        }
    }
    echo $count . 'Messages Sent<br>';
    echo $noCount . 'Message rejected';
if ($sql_venue_num>0){
    echo $get_sms;

}else{
   echo "No record";
}


?>