File manager - Edit - /home/autoph/public_html/connect/BAK_ANA.php
Back
<?php date_default_timezone_set('Asia/Manila'); //header('Content-Type: application/json'); $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 //########################################################################## //====================================================================== if($keyCode == 10090706){ $sql = "SELECT DISTINCT(employee_id),u_id, u_fname, u_lname, usr_mobile, u_position FROM vts_users WHERE `u_status`='1'"; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $activeUID = $row['u_id']; $activeUMobile = $row['usr_mobile']; $myUFName = $row['u_fname']; $myULName = $row['u_lname']; $getProspect = mysql_result(mysql_query("SELECT COUNT('id') FROM sales_prospecting WHERE sales_id = $activeUID AND status='open'"),0); //echo $activeUID. "<br>"; //echo $activeUMobile. "<br>"; // echo $myUFName. "<br>"; // echo $myULName. "<br>My Propect: "; // echo $getProspect. "<br>My Count: "; // echo $count. "<br>"; if($getProspect > 0){ $MyMessage = "Hi ". $myUFName . " " . $myULName ."! Your clients are waiting for your updates today. Please login to your ASA to access your prospect information. Thank you! "; itexmoCGlobal($activeUMobile,$MyMessage,$MyApicode,$MyPasswd); } } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings