New Topic/Question
Reply
<?php
if(isset($_POST['submit'])){
$dbhost = "localhost";
$dbname = "name";
$dbuser = "username";
$dbpass = "pass";
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$username=$_POST['username'];
$password=md5($_POST['password']);
$email=$_POST['email'];
if($firstname==' ') { $error="First name required!";}
if ($lastname==' ') { $error="Last name required!";}
if ($username==' ') { $error="Username required!";}
if ($password==' ') { $error="Password required!";}
if ($email==' ') { $error="Email required!";}
else
{
$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'");
$username_exist = mysql_num_rows($checkuser);
if($username_exist =='1'){
$error= "I'm sorry but the username you specified has already been taken. Please pick another one.";}
$query = "INSERT INTO users (firstname,lastname, username, password,email)
VALUES('$name', '$lastname', '$username', '$password','$email')";
mysql_query($query) or die(mysql_error());
$msg="You are now registered";
}
}
?>
<html>
<head><title>Registration</title></head>
<body>
<p></$msg/></p>
<form action="register.php" method="post">
<table border="0">
<tr><td>Firstname:</td>
<td><input type="text" name="firstname" value=""></td></tr>
<tr><td>Lastname:</td>
<td><input type="text" name="lastname" value=""></td></tr>
<tr><td>Username:</td>
<td><input type="text" name="username" value=""></td></tr>
<tr><td>Password:</td>
<td><input type="password" name="password" value=""></td></tr>
<tr><td>Email:</td>
<td><input type="email" name="email" value=""></td></tr>
<tr><td><input type="submit" name="submit" value="Submit"></td></tr>
</table>
</form>
</body>
</html>
I have problem when I put values to my register form always comes back "You are now registered" and when I am not entering values in some fields does not call for error that the field is required and to try again but it puts in my database as blanc fields.why is that?
MultiQuote
Thanks a lot CTphpnwb,you pointed to me to realize
| 