| Server IP : 172.64.80.1 / Your IP : 172.71.120.136 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs/ |
Upload File : |
<html>
<head>
<title>Ilori CoE SMS Alert</title>
</head>
<?php
$count=0;
$noCount=0;
$start=0;
$end=0;
require_once('connect.php');
$db=db_connect();
$sql_venue=$db->query("select * from stddata where admStatus=3 and sent=0 and used=0 limit 0,100");
$sql_venue_num=$sql_venue->rowCount();
while ($row = $sql_venue->fetch(PDO::FETCH_BOTH)) {
$formNo = $row['formNo'];
$course = $row['course'];
$levelID=$row['levelID'];
switch ($levelID) {
case 1:
$level = 'ND FT';
break;
case 3:
$level = 'HND FT';
break;
case 5:
$level = 'ND RPT';
break;
case 8:
$level = 'ND DPT';
break;
case 11:
$level = 'HND DPT';
break;
}
$gsm = $row['gsm'];
// $gsm = '08034496359';
$sur = explode(' ', $row['names']);
$surname = $sur[0];
// echo '<br>';
$message = '<b>Dear ' . $surname . ', <br>You have been admitted to study for Dual Awards in ' . $course . '. Check Admission Status on www.federalpolyede.edu.ng/ace_entranceForm/adminStatus.php. For enqueries Call/What.sApp 0.';
//$message = 'baTest message';
$senderid = 'FedPolyEde';
$to = $gsm;
$token = 'DdyxDgGoJURC0W88O73e2e5Ymts6S6LlRtuWVdAhnk8oJ0WQep7sXMBBTutLdlbG6fLv3QgRitauRuUnelwjYP2DX7VurbHPe1j1';
$baseurl = 'https://smartsmssolutions.com/api/json.php?';
$sms_array = array
(
'sender' => $senderid,
'to' => $to,
'message' => $message,
'type' => '0',
'routing' => 3,
'token' => $token
);
$params = http_build_query($sms_array);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $baseurl);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $params);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$response = curl_exec($ch);
echo curl_error($ch);
curl_close($ch);
$decoded_result = json_decode($response);
//echo "<pre>";
//var_dump($decoded_result);
//echo "</pre>";
$codeID = $decoded_result->code; // response code
if ($codeID==1000) {
// echo "am here";
// echo "am here";
$count += 1;
// $db->query("UPDATE `fedpoly`.`venuetb` SET `smsSent` = '1' WHERE `venuetb`.`formNo` = '$formNo'");
$db->query("UPDATE `fedpoly`.`admitted` SET `sent` = '1' WHERE `admitted`.`formNo` = '$formNo'");
} else {
$noCount += 1;
$db->query("UPDATE `fedpoly`.`admitted` SET `sent` = '2' WHERE `admitted`.`formNo` = '$formNo'");
}
echo $count . 'Messages Sent<br>';
echo $noCount . 'Message rejected';
// die();
}
?>