I've got a simple page for adding new courses to the database. That works fine. I'd like to add in the feature that whenever a new course is added, an email is sent to a certain email address to notify that person that the new course was added. How would I go about dropping this into my code?
Code:
<?php include_once "../mainfile.php"; //load the global vars and functions ?>
<html>
<head>
<title>Spectrum Training Brokers | New Course Admin</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
a:hover { text-decoration: none}
a:active { }
a:link { }
-->
</style>
<link rel="stylesheet" href="speciallinks.css" type="text/css">
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body onLoad="xinha_init()" bgcolor="#F5F5F5" text="#000000" link="#CC0000" vlink="#990000" alink="#CC0000">
<div>
<?php adminToolbar("<b>New Course Addition</b> - Please verify all data is correct"); ?>
</div>
<br>
<table width=800 align="center">
<td width="682" height="51" valign="top" ><table width="800" bgcolor="#CCCCCC" align="center" cellpadding="10" cellspacing="0" class="dottedborder">
<tr>
<td width="800" bgcolor="#CCCCCC"><div align="left">
<?php
$today= getDate();
$year = $today['year'];
if ($HTTP_POST_VARS['submit_date']=="Submit") {
//check to see if course is not already in there
$sql = "SELECT course_num FROM spec_course WHERE course_num='$course_num'";
$result = getSQLresult($sql);
$check = mysql_num_rows($result);
if ($check > 0) {
echo "SORRY that Course ID <b>$course_num</b> is already in use.<br>Use your browsers back button and change the course ID. $check ";
} else {
$sql = "INSERT INTO spec_course
SET course_num='$course_num',
ctitle='$ctitle',
supid='$supid',
introduction='$introduction',
outline='$outline',
STATUS='$status',
online='$online'";
$result = getSQLresult($sql);
if ($result) {
echo("<p align='center'>The record has been added.</p>");
} else {
echo("<p>Error adding submitted record: " .
mysql_error() . "</p>");
}
}
} else {
echo("<form name='courseadd' method='post' action='$PHP_SELF'>");
echo("<p align='left'> <font size='2' face='Tahoma'>Course Id:<br></font>");
echo("<input name='course_num' type='text' id='course_num'>
<p align='left'> <font size='2' face='Tahoma'>Title:<br>
<input name='ctitle' type='text' size='65' id='ctitle'></p>
<p>Status:<br><select name='status' id='status'>
<option value='Active'>Active</option>
<option value='Retired'>Retired</option>
</select></p> <p>Show on Site? <select name='online' id='online'>
<option value='Yes' selected>Yes</option>
<option value='No'>No</option>
</select></p><br>
<p>Supplier:<br>");
db_makeOptionList('spec_supplier','name','supid', 'supid');
echo("</p>
<p align='left'><font size='2' face='Tahoma'>Introduction:<br></font><textarea id='introduction' name='introduction' rows='20' cols='50' style='width: 100%'></textarea></p>
<p align='left'><font size='2' face='Tahoma'>Outline: (Paste from Word here.)<br></font><textarea name='outline' rows='20' cols='50' style='width: 100%' id='outline'></textarea></font></p>
<p align='center'>
<input name='submit_date' type='submit' id='submit_date' value='Submit'>
<input name='Reset' type='reset' id='Reset' value='Reset'>
</p>
</form>
<p align='center'> </p>
</td>
</tr>
</table></td>
</tr>
</table>");
}
// FORM SUBMITTED UPDATE DBASE
// CLOSEOUT CONTROL STRUCTURE
?>
</div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="369" valign="top"><p align="center"> </p>
</table>
<?php siteFooter(); ?>
</body>
</html>