$Content .= '<strong>Thank you for booking at Pacific Sailing School</strong></p>';
$Content .= '<p><h2>YOUR BOOKING TIMES</h2></p><table width="800" border="1"><tr><td width="300"><h3>Course</h3></td><td width="200"><h3>Lesson</h3></td><td width="200"><h3>Course Date/Time</h3></td><td width="100"><h3>Balance</h3></td></tr>';
}
if ($row["Course_Date"] == null) {
$Course_Date = "OPEN";
} else {
$Course_Date = $row["Course_Date"];
}
$Content .= '<tr><td>' . $row["Course"] . '</td><td>' . $row["Lesson"] . '</td><td>' . $Course_Date . '</td><td align="right">' . $row["Course_Balance"] . '</td></tr>';
$Total_Balance = $Total_Balance + $row["Course_Balance"];
}
if ($data_found != 0) {
$Content .= '<tr></tr><tr><td>Balance</td><td></td><td></td><td align="right">' . number_format(round((double) $Total_Balance, 2), 2) . '</td></tr></table>';
$Signature = getAdditional_Content('SIG');
$Conditions = getAdditional_Content('BSC');
$Terms = getAdditional_Content('TRM');
$Content .= '<p>' . $Terms . '</p><p>' . $Conditions . '</p><p>' . $Signature;
//echo $Content;
$mail = new PHPMailer(true);
$mail->IsSMTP();
$mail->CharSet = 'UTF-8';
$mail->Host = "mail.sunwindwater.com.au";
// SMTP server example
$mail->SMTPDebug = 0;
// enables SMTP debug information (for testing)
$mail->SMTPAuth = true;
// enable SMTP authentication
$mail->Port = 25;
// set the SMTP port for the GMAIL server
$mail->Username = "******";
// SMTP account username example
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'LIST') {
$query = "SELECT * FROM Email_Content order by ID";
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$source[] = array('ID' => $row['ID'], 'Description' => $row['Description'], 'Content' => $row['Content']);
}
echo json_encode($source);
} else {
if (isset($_REQUEST["type"]) && trim($_REQUEST["type"]) == 'SEND') {
$StudentNo = $_REQUEST['StudentNo'];
$Email = $_REQUEST['Email_Address'];
$Subject = $_REQUEST['Subject'];
$Content = '<p>' . nl2br($_REQUEST['Content']) . '</p>';
$Additional_Code = $_REQUEST['Additional_Content'];
$Additional_Content = getAdditional_Content($Additional_Code);
$Signature = getAdditional_Content('SIG');
$Content .= $Additional_Content . '<p></p>' . $Signature;
$mail = new PHPMailer(true);
$mail->IsSMTP();
$mail->CharSet = 'UTF-8';
$mail->Host = "mail.sunwindwater.com.au";
// SMTP server example
$mail->SMTPDebug = 0;
// enables SMTP debug information (for testing)
$mail->SMTPAuth = true;
// enable SMTP authentication
$mail->Port = 25;
// set the SMTP port for the GMAIL server
$mail->Username = "******";
// SMTP account username example
$mail->Password = "******";
