format("Y-m-d"); $prfTime = date('H:i:s'); $fullDateTime = $prfDate . " ".$prfTime; $myDate = date_create() ->format("Y-m-d"); $toDate = date_create() ->format("Y-m-d"); $uniqueRefID=$user_data['u_id']; $apicode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0); $passwd = mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); if(isset($_POST['done'])){ $userID = mysql_escape_string($_POST['userID']); $itemID = mysql_escape_string($_POST['itemID']); $smsLink = mysql_result(mysql_query("SELECT sms_link FROM `prf_validate_links` WHERE `deleted`=0 AND `completed`=0 AND `uid`='$userID' AND `item_id`='$itemID'"),0); $number = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE u_id = '$userID'"),0); //$myUFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE u_id = '$userID'"),0); //$myULName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE u_id = '$userID'"),0); $message = "You have pending Canvass Sheet for approval. Kindly click the link below to view and process the request. ". $smsLink; $result = itexmoAA($number, $message,$apicode,$passwd); if ($result == 0){ echo ''; }else{ echo ''; } } ?>