mysql values does not get inserted.

[shwetapandit]

the form get's executed correctly n also shows the expected message(echo). but it does not insert any value in database. why it is so.PLZ help.

 

<?php
 // Connects to your Database

 mysql_connect("localhost", "root", "") or die(mysql_error());

 mysql_select_db("simple_login") or die(mysql_error());


 //This code runs if the form has been submitted

 if (isset($_POST['submit'])) {



 //This makes sure they did not leave specific  fields blank

 if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] ) {

         die('You did not complete all of the required fields');

     }



 // checks if the username is in use

     if (!get_magic_quotes_gpc()) {

         $_POST['username'] = addslashes($_POST['username']);

     }

 $usercheck = $_POST['username'];

 $check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")

or die(mysql_error());

 $check2 = mysql_num_rows($check);



 //if the name exists it gives an error

 if ($check2 != 0) {

         die('Sorry, the username '.$_POST['username'].' is already in use.');

                 }


 // this makes sure both passwords entered match

     if ($_POST['pass'] != $_POST['pass2']) {

         die('Your passwords did not match. ');

     }



     // here we encrypt the password and add slashes if needed

     $_POST['pass'] = md5($_POST['pass']);

     if (!get_magic_quotes_gpc()) {

         $_POST['pass'] = addslashes($_POST['pass']);

         $_POST['username'] = addslashes($_POST['username']);

             }

//post date to variables
$username=   $_POST['username'];
$pass=       $_POST['pass'];
$firstname=  $_POST['firstname'];
$middlename= $_POST['middlename'];
$lastname=   $_POST['lastname'];
$email=    $_POST['email'];

if(isset($_POST['designation'])){

$designation=$_POST['designation'];}
if (isset($_POST['gender'])){
        $gender = $_POST['gender'];}
if (isset($_POST['tskills'])) {
        $tskills=$_POST['tskills'];}



 // now we insert it into the database

     $insert = "INSERT INTO users (username, password,firstname,middlename,lastname,gender,tskills)

             VALUES ('$username' , '$pass' , '$firstname' , '$middlename' , '$lastname' ,
            '$gender' , '$tskills' , '$designation' , '$email')";

     $add_member = mysql_query($insert);

     ?>



 
 <h1>Registered</h1>

 <p>Thank you, you have registered - you may now login</a>.</p>

 <?php
 }

 else
 {    
 ?>


 
 <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

 <table border="0">
<tr><td>
<legend>NAME</legend>
FirstName: <input type="text"  name="firstname"  id="firstname">  <br/>
MiddleName:<input type="text"  name="middlename" id="middlename"> <br/>
LastName:  <input type="text"  name="lastname"   id="lastname">   <br/>
</td></tr>
<tr><td>
<legend>PHYSICAL INFO</legend>
Male  <input type="radio" id="male"   name="gender" value="male"><br/>
Female<input type="radio" id="female" name="gender" value="female"><br/>
</td></tr>
<tr><td>
<legend>TECHNICAL SKILLS</legend>
<input type="checkbox" name="tskills[]" value="html">html<br/>
<input type="checkbox" name="tskills[]" value="css">CSS<br/>
<input type="checkbox" name="tskills[]" value="javascript">Javascript<br/>
<input type="checkbox" name="tskills[]" value="jquery">Jquery<br/>
<input type="checkbox" name="tskills[]" value="php">PHP<br/>
<input type="checkbox" name="tskills[]" value="mysql">MySQL<br/>
<input type="checkbox" name="tskills[]" value="codeignitor">CodeIgnitor<br/>
</td></tr>

<tr><td>
<legend>CURRENT DESIGNATION</legend>
<select name="designation">
  <option type="text"  value="developer"   name="developer"   id="developer">  Developer    </option>
  <option type="text"  value="designer"     name="designer"    id="designer">    Designer       </option>
  <option type="text"  value="analyst"       name="analyst"       id="analyst">      Analyst         </option>
  <option type="text"  value="manager"    name="manager"    id="manager">    Manager      </option>
  <option type="text"  value="marketing"  name="marketing"   id="marketing">   Marketing    </option>
  <option type="text"  value="trainee"      name="trainee"        id="trainee">       Trainee        </option>
</select>
</td></tr>

<tr><td>Email ID:<input type="email" name="email" id="name"></td></tr></br>
<tr><td>
<legend>LOGIN DETAILS</legend>
 <tr><td>Username:</td><td>

 <input type="text" name="username" maxlength="60">

 </td></tr>

 <tr><td>Password:</td><td>

 <input type="password" name="pass" maxlength="10">

 </td></tr>

 <tr><td>Confirm Password:</td><td>

 <input type="password" name="pass2" maxlength="10">

 </td></tr>

 <tr><th colspan=2><input type="submit" name="submit"
value="Register"></th></tr> </table>

 </form>
<a href="login.php">PLEASE LOGIN</a><br/>
<a href="form.php">FORGET PASSWORD</a>
<?php

}
 ?>
 

[shwetapandit]

i understand now.its solved.its not inserted becoz of my mistake.sorry