View Single Post
  #7 (permalink)  
Old 02-20-2008, 01:44 AM
jinchiruki jinchiruki is offline
WebProWorld New Member
 

Join Date: Feb 2008
Posts: 3
jinchiruki RepRank 0
Default Re: undefine variable

ok guy,pass...change few code..but now,facing 1 problem...how can i stop query to databse when theres no data fill in the form if i click submit?


here my latest code

Code:
 
<table width="1000" height="95" border="1">
  <tr>
    <td bgcolor="#0000FF">&nbsp;</td>
  </tr>
</table>

<center>

<?
   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 ';
  
 }
 
      if(isset($errors))
{

    foreach($errors as $val)
    {
    
        echo "Error: $val <br/>"; 
    }
}
 
 
      if
      
      ($name="" && $email="" && $contact="" && $person_attend="" && $comment="" )
      
      {
 
      //insert statements
 
      } else 
      
      {
 
      //error message
 
      }
 
      //process form
 
      //this is your add query....
  
      $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());
    
      {
 
      echo "thanks you ";
 
      }
   
      mysql_close();
 }
      

?>
</center>
<center> 
<br>
<a href="Index.php">View list attend</a><br>
<a href="register.html">Clik here to register</a>
</center>
Reply With Quote