problem inserting data into mysql database from a form...

[vikas1111]

Hi All..

While putting data into database from form if i refresh the php form a blank data will be added into database ... How can i remove that bug???

Here is my code....

 
<?php
$con = mysql_connect("localhost","root","rootwdp");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("sample", $con);
$sql="INSERT INTO usttable (usr_login,usr_password,usr_name,usr_email)
VALUE ('$_POST[fname]','$_POST[password]','$_POST[fname]','$_POST[email]')";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
mysql_close($con)
?>
 

[hsriat]

Apply validations before you insert the data to the database.

<?php
 
//redirect to the form page if not submitted
if (!isset($_POST['submit']))
header ("Location:login_form.php");//which ever page is submitting to this script.
 
//if any of the parameter is missing.
if (!isset($_POST[fname]) || !isset($_POST[email]) || !isset($_POST[password]))
die ("Invalid parameters");
 
 
//---- your code ---
$con = mysql_connect("localhost","root","rootwdp");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("sample", $con);
$sql="INSERT INTO usttable (usr_login,usr_password,usr_name,usr_email)
VALUE ('$_POST[fname]','$_POST[password]','$_POST[fname]','$_POST[email]')";
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
mysql_close($con)
?>
 

And make sure you add name="submit" to the submit button.

I would suggest you to do the same validations in PHP before you insert data, which you do in JavaScript onsubmit of form (if you are doing any).

[jessica87]

thanks for the tips...
i have the same problem to.....
^_^

[vikas1111]

hi hsriat

thanks its working........

[hsriat]

You are welcome... :)

I'm glad that one reply helped both of you.