already put the validation..it will prompt user the errors..but it query into database also how can i solved it??
<table width="1000" height="95" border="1">
<tr>
<td bgcolor="#0000FF"> </td>
</tr>
</table>
<?php
include("connect.php");
//this is your validation in the form,put it here....
if (empty($_POST['name']))
{
$errors[] = 'Please enter a name';
}
if (empty($_POST['email']))
{
$errors[] = 'Please enter a valid e-mail address';
}
else if (!eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$",
$_POST['email']))
{
$errors[] = 'Please enter a valid e-mail address';
}
if (empty($_POST['contact']))
{
$errors[] = 'Please enter a valid contact with numeric value';
}
else if (!is_numeric($_POST['contact']))
{
$errors[] = 'Please enter a valid contact with a numeric value';
}
if (empty($_POST['person_attend']))
{
$errors[] = 'Please enter some word for person attend';
}
else if (strlen ($_POST['person_attend']) > 255)
{
$errors[] = 'person attend';
}
if (empty($_POST['comment']))
{
$errors[] = 'Please enter some comment';
}
else if (strlen ($_POST['comment']) > 255)
{
$errors[] = 'comment ';
}
$name = $_POST['name'];
$email = $_POST['email'];
$contact = $_POST['contact'];
$person_attend = $_POST['person_attend'];
$comment = $_POST['comment'];
if($name="" && $email="" && $contact="" && $person_attend="" && $comment="" )
$name = $_POST['name'];
$email = $_POST['email'];
$contact = $_POST['contact'];
$person_attend = $_POST['person_attend'];
$comment = $_POST['comment'];
$query = "INSERT INTO rsvp (id, name, email, contact, person_attend, comment)
VALUES ('', '$name', '$email', '$contact', '$person_attend', '$comment')";
$results = mysql_query($query) or die
("Could not execute query : $query." . mysql_error());
{
if(isset($errors))
{
foreach($errors as $val)
{
echo "Error: $val <br>";
}
}
{
echo "Thanks for join us.";
}
}
{
mysql_close();
}
?>
<a href="Index.php">View list attend</a>