database is saving the person information lots of times ??

[plodos]

form.html

<form action="a.php" method="post">
<table border="0" bgcolor="#ececec" cellspacing="5">

<tr>
<td>Name</td><td>
<input name="name" type="text" id="name"  size="25"/></td>
</tr>

<tr>
<td>Surname</td><td>
<input name="surname" type="text" id="surname"   size="25"/></td>
</tr>
</table>
</form>

 

a.php

<?php
include("dbconfig.php");

$name =mysql_real_escape_string($_POST['name']);
$surname = mysql_real_escape_string($_POST['surname']);

$add_person= mysql_query(" INSERT INTO person (fname,lname) VALUES ('$name','$surname')  "); 

if($add_person)
{

include('ok.html');	
}
else
{
echo "Error";
}
?>

 

This is my sample code, I want to improve that, how can I block the repeated data....

 

If the person click the Register button 3 times, database is saving the person information 3 times, and when I listed, query show me 3 same information....

 

what must I do ? I want to see unique information for each person....I want to block multiple records, please help...

[kenrbnsn]

Check to see if the record is in the database before inserting it.

 

Ken

[revraz]

Also, maybe create a Username field as well and make it unique.

[The Little Guy]

So... It would look like this:

 

include("dbconfig.php");

$name =mysql_real_escape_string($_POST['name']);
$surname = mysql_real_escape_string($_POST['surname']);
$sql = mysql_query("SELECT * FROM person WHERE fname = '$name' AND lname = '$surname'");
if(mysql_num_rows($sql) < 1){
$add_person= mysql_query(" INSERT INTO person (fname,lname) VALUES ('$name','$surname')  "); 
if($add_person){
	include('ok.html');	
}
else{
	echo "Error";
}
}

[revraz]

I think you mean to make that == 0 not greater than 0, since that means they exist.

[The Little Guy]

I think you mean to make that == 0 not greater than 0, since that means they exist.

 

I modified it before this post

[plodos]

thank you...

 

I used this system

include("dbconfig.php");

$name =mysql_real_escape_string($_POST['name']);
$surname = mysql_real_escape_string($_POST['surname']);
$sql = mysql_query("SELECT * FROM person WHERE fname = '$name' AND lname = '$surname'");
if(mysql_num_rows($sql) < 1){

$add_person= mysql_query(" INSERT INTO person (fname,lname) VALUES ('$name','$surname')  "); 

if($add_person){

include('ok.html');
}
else
echo "Error";
}
}

 

but I have one more question:)

 

phpmyadmin recorded the empty data....If the user click register 5 times...mysql is saving the first data with full information and other 4 fields are empty like

 

 

1 nokia mobile

2               

3               

4               

5

6 samsung mobile

7

8 sony mobile

 

how can I block the emyty data?

[revraz]

Those values are not even in your code you posted, so that must be coming from somewhere else.