include '../inc/db.inc.php';
echo "
Great Neck South Class of 1972: Add Alumni";
$message = "";
$adminPage = true;
$now = gettimeofday();
if($admin && $_POST['addAlum'])
{//Try to add
$title = $_POST['title'];
$firstname = $_POST['firstname'];
$middlename = $_POST['middlename'];
$lastname = $_POST['lastname'];
$maidenname =$_POST['maidenname'];
$suffix = $_POST['suffix'];
$street1 = nl2br($_POST['street1']);
$street2 = nl2br($_POST['street2']);
$city = $_POST['city'];
$state = $_POST['state'];
$zip = $_POST['zip'];
$homephone = $_POST['homephone'];
$workphone = $_POST['workphone'];
$mobilephone = $_POST['mobilephone'];
$fax = $_POST['fax'];
$email = $_POST['email'];
$biography = addslashes(nl2br($_POST['biography']));
if(!($firstname && $lastname ))
{
$message = "
Error adding alum. First Name, Last Name must be included.
";
}
else
{
$query = "INSERT INTO gns_alums (title , firstname , middlename ,lastname, maidenname, suffix , street1 , street2 , city , state , zip , homephone , workphone , mobilephone , fax , email , biography )
VALUES ('$title', '$firstname', '$middlename','$lastname','$maidenname','$suffix', '$street1', '$street2', '$city', '$state', '$zip', '$homephone', '$workphone', '$mobilephone', '$fax', '$email', '$biography')";
$result = mysql_query($query);
if($result)
{
$message = "
\"$firstname $lastname\" Added Succesfully
";
}
else
{
$message = "
Error Adding
".mysql_error()."";
}
}
}
include '../inc/header.php';
echo $message;
$addAlumForm = "
";
// display the form on every page instance
echo $addAlumForm;
include '../inc/footer.php';
?>