Contact form issue

programming
1

Hello - I’ve been working on this contact form that writes the users info to db. Everything works great but I’m having trouble with displaying a confirmation message after the user submits their information. Please help if you can!!

Thanks,

AM,

Here is the code I’m using

<?php
include ‘includes/config.php’;
include ‘includes/opendb.php’;

mysql_select_db(‘newsletter2’) or die(‘Cannot select database’);

$query = 'CREATE TABLE guestbook ( '.
'id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, '.
'name VARCHAR(30) NOT NULL, '.
'email VARCHAR(50) NOT NULL, '.
'entry_date DATE NOT NULL, '.
‘PRIMARY KEY(id))’;

$result = mysql_query($query);

// check if the form is submitted
if(isset($_POST[‘btnSign’]))
{
// get the input from $_POST variable
// trim all input to remove extra spaces
$name = trim($_POST[‘Name’]);
$email = trim($_POST[‘Email’]);

// escape the message ( if it's not already escaped )
if(!get_magic_quotes_gpc())
{
    $name    = addslashes($name);
}

// if the visitor do not enter the url
// set $url to an empty string
if ($url == 'http://')
{
    $url = '';
}

// prepare the query string
$query = "INSERT INTO guestbook (name, email, entry_date) " .
         "VALUES ('$name', '$email', current_date)";

// execute the query to insert the input to database
// if query fail the script will terminate         
mysql_query($query) or die('Error, query failed. ' . mysql_error());

// redirect to current page so if we click the refresh button 
// the form won't be resubmitted ( as that would make duplicate entries )
header('Location: ' . $_SERVER['REQUEST_URI']);

// force to quite the script. if we don't call exit the script may
// continue before the page is redirected



exit;

}
?>
<html>
<head>
<title>Guestbook</title>
<script language=“JavaScript” src=“gen_validatorv2.js” type=“text/javascript”></script>
<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1”>
<link rel=“stylesheet” type=“text/css” href=“styles/styles.css”>
</head>
<body>
<form method=“post” name=“guestform”>
<table width=“550” border=“0” cellpadding=“2” cellspacing=“1”>
<tr>
<td width=“100”>Name *</td> <td>
<input name=“Name” type=“text” id=“txtName” size=“30” maxlength=“30”></td>
</tr>
<tr>
<td width=“100”>Email</td>
<td>
<input name=“Email” type=“text” id=“txtEmail” size=“30” maxlength=“50”></td>
</tr>
<tr>
<td width=“100”> </td>
<td>
<input name=“btnSign” type=“submit” id=“btnSign” value=“Sign Guestbook” onClick=“return checkForm();”></td>
</tr>
</table>
</form>
<script language=“JavaScript” type=“text/javascript”>
//You should create the validator only after the definition of the HTML form
var frmvalidator = new Validator(“guestform”);
frmvalidator.addValidation(“Name”,“req”,“Please enter your Name”);
frmvalidator.addValidation(“Name”,“maxlen=20”,
“Max length for Name is 20”);
frmvalidator.addValidation(“Name”,“alpha”);

frmvalidator.addValidation(“Email”,“maxlen=50”);
frmvalidator.addValidation(“Email”,“req”);
frmvalidator.addValidation(“Email”,“email”);

</script>
<br>
<br>

</body>
</html>