php regiteration page is not working and not adding data into data base plz

<?php
$fullname=strip_tags($_POST['fullname']);
$username=strip_tags($_POST['username']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$date=date("Y-m-d");
$submit=$_POST['submit'];
?>
<html>
<h1>REGISTER !</h1>
<form action='register.php' method='POST'>
<table border =25 color=black align=center space=5 >
      <tr>
           <td>Full Name:</td>
           <td><input type='text' name='fullname' value='<?php echo $fullname; ?>'></td>
      </tr>
      <tr>
          <td>User Name  :</td>
          <td><input type='text' name='username' value='<?php echo $username; ?>'></td>
      </tr>
      <tr>
          <td>Password :</td>
          <td><input type='password' name='password'></td>
      </tr>
       <tr>
           <td>Confirm Password:</td>
           <td><input type='password' name='repeatpassword'></td>
      </tr>
      <td><input type='submit' value='Register !'</td>
</table>
</form>
</html>
<?php
$fullname=strip_tags($_POST['fullname']);
$username=strip_tags($_POST['username']);
$repeatpassword = strip_tags($_POST['repeatpassword']);
$date=date("Y-m-d");
if($submit)
   {
           //check for existance
           if($fullname&&$username&&$password&&$repeatpassword)
           {
           //encrypt password
                     $password=md5($password);
                     $repeatpassword=md5($repeatpassword);
                     if($password==$repeatpassword)
                      {
                       echo"Password dont match";
                       }
                     elseif(strlen($password)>25||strlen($password)<6)
                         {
                         echo"Password must be between 6 and 25 characters";
                         }
                     elseif(strlen($username)<20||strlen($fullname)>25)
                         {
                          echo"Username or fullname is too long";
                         }
           }
           else
           {
           echo"fill all fields";
           }
   }
   else
   echo"Registered Successfully";
   $connect =  mysql_connect("localhost","root","");
   mysql_select_db("phplogin");//select database
         $query=mysql_query ("
         INSERT INTO users VALUES('','$fullname','$username','$password','$date')
         ");
         die("you have been registered !<a href='index.php'>click</a>here to log in");


?>

2

Contributors

2

Replies

4 Days

Discussion Span

9 Months Ago

Last Updated

3

Views

coolsid01

Newbie Poster

2 posts since Aug 2012

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

9 Months Ago

0

A couple of things:

Your are using the variable $password but I can't see anywhere above that code that actuallys assigns a value to that variable.
You are assigning your query to a variable but not actually running the query anywhere, you don't need a blank space for the id and you should indicate the columns you are inserting into. Try your query as

mysql_select_db("phplogin");//select database
mysql_query ("
INSERT INTO users (fullname, username, password, date) VALUES('$fullname','$username','$password','$date')
");

ALso, remove the die - that should be used for database erors only.

simplypixie

Practically a Master Poster

642 posts since Oct 2010

Reputation Points: 157

Solved Threads: 118

Skill Endorsements: 5

9 Months Ago

0

thanks for help but i did this as i was not using same varriable which i was posting now i did it thanks man

coolsid01

Newbie Poster

2 posts since Aug 2012

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

php regiteration page is not working and not adding data into data base plz

This article has been dead for over three months: Start a new discussion instead