if (strlen($Phone) > 10) {
// a 10 digit number, format as 1-800-555-5555
$Phone = substr($Phone, 0, 1) . '.' . substr($Phone, 1, 3) . '.' . substr($Phone, 4, 3) . '.' . substr($Phone, 7, 4);
} else {
$Phone = substr($Phone, 0, 3) . '.' . substr($Phone, 3, 3) . '.' . substr($Phone, 5, 4);
}
return $Phone;
}
function phn_numb($Phone2)
{
if (!is_numeric(substr($Phone2, 0, 1)) && !is_numeric(substr($Phone2, 1, 1))) {
return $Phone2;
}
$chars = array(' ', '(', ')', '-', '.');
$Phone = str_replace($chars, "", $Phone2);
if (strlen($Phone2) > 10) {
// a 10 digit number, format as 1-800-555-5555
$Phone2 = substr($Phone2, 0, 1) . '-' . substr($Phone2, 1, 3) . '-' . substr($Phone2, 4, 3) . '-' . substr($Phone2, 7, 4);
} else {
$Phone2 = substr($Phone2, 0, 3) . '-' . substr($Phone2, 3, 3) . '-' . substr($Phone2, 5, 4);
}
return $Phone2;
}
$Phone = substr('+14357725684', 1);
$Phone2 = substr('19182932500', 0);
//$FormattedPhone = implode(' ',str_split($Phone));
//$phone_text = textPhone($Phone);
$phone_text = substr(phn_numb_dots($Phone), 2);
echo $phone_text . '<br>';
$sms_text = substr(phn_numb($Phone2), 2);
echo $sms_text . '<br>';
$resultAppts = mysqli_query($con, $sqlAppts);
$rsAppts = mysqli_fetch_assoc($resultAppts);
//$dial_attempt = $rsAppts['dial_attempt'];
$twilio_number = $rsAccount['twilio_number'];
$StartTime = date("l F jS g:iA", $rsAppts['start_appt']);
$Doc = $rsAccount['name'];
$Contact = $rsAppts['contact'];
$Email = $rsAppts['email_address'];
$ContactPhone = $rsAppts['phone'];
$MainID = $rsAppts['main_id'];
$facility_name = $rsAccount['facility_name'];
$facility_phonics = $rsAccount['facility_phonics'];
$Phone = substr($rsAccount['mobile_number'], 1);
//$FormattedPhone = implode(' ',str_split($Phone));
//$phone_text = textPhone($Phone);
$phone_text = phn_numb(substr($Phone, 0));
//$language = $rsMessage['language'];
$email_subject = $rsMessage['lang1_subject'];
$email_message = $rsMessage['lang1_email'];
$EmailMessageNew = sprintf($email_message, $Contact, $Doc, $StartTime, $phone_text, $appt_id, $MainID, $account_id, $facility_name);
try {
$ch = curl_init();
// Pass the mailgun credentials
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($ch, CURLOPT_USERPWD, $mailgun_user_pwd);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'POST');
curl_setopt($ch, CURLOPT_URL, $mailgun_api_url);
curl_setopt($ch, CURLOPT_POSTFIELDS, array('from' => $mailgun_from_address, 'to' => $Email, 'subject' => $email_subject, 'html' => $EmailMessageNew));
$result = curl_exec($ch);
curl_close($ch);
<P>Your appointment with Dr. <?php
echo $Doc;
?>
at <?php
echo $Facility;
?>
<?php
echo $statement;
?>
<p>Thank you,</P>
<P><?php
echo $Facility;
?>
<br>
<?php
echo phn_numb($Phone);
?>
</P>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; box-sizing: border-box; font-size: 14px; width: 100%%; clear: both; color: #999; margin: 0; padding: 20px;">
<table width="100%%" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; box-sizing: border-box; font-size: 14px; margin: 0;">
<tr style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; box-sizing: border-box; font-size: 14px; margin: 0;">
<td class="aligncenter content-block" style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; box-sizing: border-box; font-size: 12px; vertical-align: top; text-align: center; margin: 0; padding: 0 0 20px;" align="center" valign="top"></td>
</tr>
</table>
</div></div>
/* SELECT * FROM APPTS BY ACCOUNT ID */
$sqlAppts = "SELECT * FROM `{$tbl_appts}` WHERE id=" . $appt_id . "";
$resultAppts = mysqli_query($con, $sqlAppts);
$rsAppts = mysqli_fetch_assoc($resultAppts);
//$dial_attempt = $rsAppts['dial_attempt'];
$twilio_number = $rsAccount['twilio_number'];
$StartTime = date("l F jS g:iA", $rsAppts['start_appt']);
$Doc = $rsAccount['name'];
$Contact = $rsAppts['contact'];
$ContactPhone = $rsAppts['phone'];
$facility_name = $rsAccount['facility_name'];
$facility_phonics = $rsAccount['facility_phonics'];
$Phone = $rsAccount['mobile_number'];
//$FormattedPhone = implode(' ',str_split($Phone));
//$phone_text = textPhone($Phone);
$sms_phone = substr(phn_numb($Phone), 2);
//$language = $rsMessage['language'];
$sms_message = $rsMessage['lang1_sms'];
$SMSMessageNew = sprintf($sms_message, $Contact, $Doc, $StartTime, $sms_phone, $facility_name);
echo "<p>SMS Results:</p>";
try {
$call = $client->account->messages->create(array('To' => $ContactPhone, 'From' => $twilio_number, 'Body' => $SMSMessageNew, 'StatusCallback' => "http://notify.kicktech.com/broadcast/sms-receive.php?appt_id=" . $appt_id));
$sqlUpdateAppt = "UPDATE {$tbl_appts} SET `status`='completed', `sms_status`= 'SMS Sent' WHERE id = '" . $appt_id . "'";
echo 'SMS SID: ' . $call->sid . " - " . $call->status . "<br>";
} catch (Exception $e) {
echo 'Error: ' . $e->getMessage() . "<br>";
}
$result = mysqli_query($con, $sqlUpdateAppt);
//echo $StartTime;
//echo $Doc;
//echo $Contact;
