File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_SEND_ALERT.php

Back
<?php date_default_timezone_set('Asia/Manila'); //header('Content-Type: application/json'); $sqlHost='localhost'; $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("Y/m/d"); $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $keyCode= $_REQUEST['token']; $MyApicode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `ver_id`=1"),0); $MyPasswd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `ver_id`=1"),0); //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## function itexmoCGlobal($number,$message,$apicode,$passwd){ $ch = curl_init(); $itexmo = array('1' => $number, '2' => $message, '3' => $apicode, 'passwd' => $passwd); curl_setopt($ch, CURLOPT_URL,"https://www.itexmo.com/php_api/api.php"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($itexmo)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); return curl_exec ($ch); curl_close ($ch); } //########################################################################## // ITEXMO SEND SMS API - PHP - CURL-LESS METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## //########################################################################## //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## function itexmoAA($number,$message){ $SendToNumber = $number; try { $ch = curl_init(); $itexmo = array( 'Email' => 'aendaya@autohubgroup.com', 'Password' => 'JRE@jre0911', 'ApiCode' => 'PR-AUTOH172111_IE74I', 'SenderId'=> 'AUTOHUB GRP', 'Recipients' => [$SendToNumber], 'Message' => $message ); curl_setopt($ch, CURLOPT_URL,"https://api.itexmo.com/api/broadcast"); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($itexmo)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $response = curl_exec($ch); //return curl_exec ($ch); curl_close ($ch); return $response; }catch (Exception $ex){ return $ex->getMessage(); } } //########################################################################## // ITEXMO SEND SMS API - PHP - CURL METHOD // Visit www.itexmo.com/developers.php for more info about this API //########################################################################## //====================================================================== //====================================================================== if(isset($_POST['done'])){ $sql = "SELECT * FROM `cl_clearance_data` WHERE `cl_approver_id_a` != 0 AND `cl_approved_by_id` = 0 AND `cl_sla_start`!='' GROUP BY `cl_approver_id_a`"; while($row = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $activeUID = $row['cl_approver_id_a']; $activeUMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE u_id = $activeUID"),0); $myUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE u_id = $activeUID"),0); $MyMessage = "Hi ". $myUFName . "! You have pending employee clearance form waiting for your signature. Please login at https://autohub.ph/connect or via ASA APP. Thank you! "; itexmoAA($activeUMobile,$MyMessage); } echo " SMS Notification has been sent to ". $count . " clearing officers"; } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings