IP Spam Stop thing

Does any 1 know a code where once an IP has entered a form it logs there ip so it wont let them use the form again?
iv looked around but couldnt find any :(
If you know, could you send link pls.
+Rep


Thread moved to ' Website Designing & Development ' by Yoshimitsui (Super Moderator).

You need alot of things lately don't you :P Can't you just store submitted IPs into a file?

Then it could be easily found and people could get hacked

Quote:

---

Originally Posted by !Lily

You need alot of things lately don't you :) Can't you just store submitted IPs into a file?

---

put it into a mysql db then query if ip = 0 display form ;)

right, iv got it so it adds the ip 2 the database, now i need it so:
if ip is in database it says you cant use it
but if ip isnt it displays a form.

can any 1 provide me with a script pls <3

well you would query like

Code:

---

Mysql_query()
fetch it lol
if ($query=1){
echo("You have taken part in the form");
}
if ($query=0){
echo("FORM");
}

---

Quote:

---

Originally Posted by Eccentric

well you would query like

Code:

---

Mysql_query()
fetch it lol
if ($query=1){
echo("You have taken part in the form");
}
if ($query=0){
echo("FORM");
}

---

---

im not very good with querys :(

Quote:

---

Originally Posted by .:Jack120:.

im not very good with querys :(

---

PHP Code:

---

$ip = $_SERVER['REMOTE_ADDR'];
$query = "SELECT * FROM `loggedips ` WHERE `ip`='" . $ip . "';";
$res = mysql_query($query);
$num = mysql_num_rows($res);

if($num > 0) {
//don't display form
} else {
//display the form
} 


---

Edit the query as appropriate.

Quote:

---

Originally Posted by Tomm

PHP Code:

---

$ip = $_SERVER['REMOTE_ADDR'];
$query = "SELECT * FROM `loggedips ` WHERE `ip`='" . $ip . "';";
$res = mysql_query($query);
$num = mysql_num_rows($res);

if($num > 0) {
//don't display form
} else {
//display the form
} 


---

Edit the query as appropriate.

---

Thanks for touching up on that as i'm not too good on php havnt revised on it for a while ;)