Php doubt

suvin_prathab · September 7, 2008

I hve created a registration form and when i submit the form at first the data are not stored on the database and displays Duplicate entry 'suvin_prathab' for key 1 in the browser(suvin_prathab actually the previous entry) . But when i fill the form again and submit it the data are stored .But when i refresh the page again it browser asks for RESEND OR CANCEL when i click RESEND then it shows how can i correct this .I want the data to stored only once .. i need help to sort this thing... I will give the whole code here ...

<?php

//ERROR REPORTING AND DISABLING NOTICES

error_reporting(E_ALL & ~E_NOTICE);

$connection = mysql_connect("localhost","root","suvin");

if(!$connection){

die("Database Connection Failed !".mysql_error());

}

?>

<?php

$db_select = mysql_select_db("guest_book",$connection);

if(!$db_select){

die("Database Selection Failed !".mysql_error());

}

?>

<head>

<title>Fight Club</title>

</head>

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

<table>

<tr><td width="175">Username:</td><td><input type="text" name="txt_username" /></td></tr><br /><br />

<tr><td width="175">Password:</td><td><input type="password" name="txt_password" /></td></tr><br /><br />

<tr><td width="175">Confrim Password:</td><td><input type="password" name="txt_confirm_pass" /></td></tr><br /><br />

<tr><td width="175">Security Question:</td><td><input type="text" name="txt_security_q" /></td></tr><br /><br />

<tr><td width="175">Answer:</td><td><input type="text" name="txt_answer" /></td></tr><br /><br />

</table>

</font>

</form>

<?php

if(isset($_POST['txt_username']) && isset($_POST['txt_password']) && isset($_POST['txt_confirm_pass']) && isset($_POST['txt_email']) && isset($_POST['txt_security_q']) && isset($_POST['txt_answer'])){

$username = $_POST["txt_username"];

$password = $_POST["txt_password"];

$confirm_pass = $_POST["txt_confirm_pass"];

$email = $_POST["txt_email"];

$security_q = $_POST["txt_security_q"];

$answer = $_POST["txt_answer"];

$query2 = "INSERT INTO register (username,password,email,security_q,answer,confirm _pass) VALUES ('$username','$password','$email','$security_q','$ answer','$confirm_pass')";

mysql_query($query2,$connection) or die(mysql_error());

}

?>

</body>

</html>

<?php

mysql_close($connection);

?>

budimir · September 7, 2008

You can use a query and select all users from the databse before insert function and then make na if statment where you will check if you already have this info in db.

SELECT * FROM users

if($_PST["username"] == $username && something else && something else ...){
echo "It's already in the db";
} else {
Insert into DB
}

Hope, that helps!

Sign In

Php doubt

Recommended Posts

suvin_prathab

Link to comment

Share on other sites

budimir

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information