echo "$Notes
";
$Notes_strip = stripslashes($Notes);
$Notes = htmlentities(stripslashes($Notes), ENT_QUOTES);
echo "$Notes";
?>
require("header.h") ?>
// YOUR MSSQL 7.0 SERVER PARAMETERS
$hostname = "192.168.1.1";
$username = "phpuser";
$password = "phpuser";
// YOUR MSSQL 7.0 DATABASE
$dbname = "contacts";
// CONNECT TO THE MSSQL 7.0 DATABASE
$connection = mssql_connect($hostname,$username,$password);
mssql_select_db("$dbname");
if ($inup == "i") {
$sql_query = "INSERT INTO tbl_contacts (LastName, FirstName, Address1, Address2, City, State, Zip, Email, Notes) VALUES ('$LastName', '$FirstName', '$Address1', '$Address2', '$City', '$State', '$Zip', '$Email', '$Notes')";
echo "Your entry was added succesfully.
";
}
else {
$sql_query = "UPDATE tbl_contacts SET LastName = '$LastName', FirstName = '$FirstName', Address1 = '$Address1', Address2 = '$Address2', City = '$City', State = '$State', Zip = '$Zip', Email = '$Email', Notes = '$Notes' WHERE LastName = '$LastName'";
echo "Your entry was updated succesfully.
";
}
$query_result = mssql_query($sql_query);
mssql_close($connection);
?>
/* recipients */
$recipient .= "$Email";
/* subject */
$subject = "Test PHP Mail";
/* message */
$message .= "$FirstName $LastName\n";
$message .= "$Address1\n";
$message .= "$Address2\n";
$message .= "$City, $State $Zip\n\n";
$message .= "$Notes_strip\n";
/* you can add a stock signature */
$message .= "\n\n-------------------------------------------------------------\r\n"; //Signature delimiter
$message .= "Please do not reply. This message was generated automatically.";
/* additional header pieces for errors, From cc's, bcc's, etc */
$headers .= "From: Intranet \n";
$headers .= "X-Sender: \n";
$headers .= "X-Mailer: PHP\n"; // mailer
$headers .= "X-Priority: 3\n"; // 3 means normal priority.
$headers .= "Return-Path: \n"; // Return path for errors
/* If you want to send html mail, uncomment the following line */
// $headers .= "Content-Type: text/html; charset=iso-8859-1\n"; // Mime type
/* and now mail it */
/* mail($recipient, $subject, $message, $headers); */
?>