<?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&sender=FedPolyEde&recipient='.$recipients.'&message='.$message;

    $send = file_get_contents($url);
    return $send;
}
$count=0;
$noCount=0;
$start=0;
$end=0;
require_once('../connect.php');
$db=db_connect();
$sql_venue=$db->query("select * from ace_admitted where closed=0 and used=0");
     $sql_venue_num=$sql_venue->rowCount();
$sql_fetch = $sql_venue->fetch(PDO::FETCH_BOTH);
echo $gsm = '234' . substr($sql_fetch['gsm'], 1);
$surname=$sql_fetch['surname'];
$na=explode(' ',$surname);
$name=$na[0];


    while ($row = $sql_venue->fetch(PDO::FETCH_BOTH)) {
        $formNo = $row['formNo'];
       $course=$row['course'];
//        $sql = $db->query("SELECT * FROM `stddata` where  formNo='$formNo'");
//        $sql_num = $sql->rowCount();
//        if ($sql_num > 0) {
//            $sql_fetch = $sql->fetch(PDO::FETCH_BOTH);
//            echo $gsm = '234' . substr($sql_fetch['gsm'], 1);
//            $surname=$sql_fetch['surname'];
//            echo '<br>';
//        }
        echo  $message = '<b>Dear '. $surname. ', <br>You have been admitted to study for Dual Admission in ' . $course.'. Check Admission Status on www.federalpolyede.edu.ng/ace_entranceForm/adminStatus.php. For enqueries Call 08092000666 & 07058216666.' ;
        echo $row['sn'];
        $senderid = 'FedPolyEde';
        $recipients = $gsm;
        $username = 'aspoa';
        $password = 'aepies12';
        $url = 'http://api.smartsmssolutions.com/smsapi.php';
        $get_sms = sendsms_get($username, $password, $message, $senderid, $recipients);
        if ($get_sms) {
            $count += 1;
            $db->query("UPDATE `fedpoly`.`ace_admitted` SET `closed` = '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";
}
?>