Block IP with Database

[xsuck91]

how to block someone from visiting my page using ip adress ?

this is the case

if someone come to my site then we record the ip address and put it into database.

when the visitor come again with the same IP they cannot see my page (block them) and redirect it to somewhere page.

 

[ManiacDan]

Wherever you record the IP, do the check right before that.  If their IP matches, redirect them or die.

[xsuck91]

Wherever you record the IP, do the check right before that.  If their IP matches, redirect them or die.

 

can you give me a sample code for this case ?

 

[ManiacDan]

I won't do your work for you, no.  The whole thing I described is maybe 8 lines of code. 

[Far Cry]

Wherever you record the IP, do the check right before that.  If their IP matches, redirect them or die.

 

can you give me a sample code for this case ?

 

<?php 
//Start output buffer so we can use header(); to redirect. Not needed if you are not using sessions.
ob_start();
$current_ip = $_SERVER['REMOTE_ADDR'];
$query = mysql_query("SELECT blocked_ip FROM tbl_name_here WHERE blocked_ip=$current_ip");
//If IP matches DB's IP, redirect.
if(mysql_num_rows($query) == 1){
header("Location:someplace.php");
} else {
//IP is not blocked, continue.	
}
//End output buffer
ob_end_flush();
?>

 

Code is untested, should work.

[Pikachu2000]

Storing IP addresses as strings in a database isn't terribly efficient, nor is running a query only to use mysql_num_rows() to get a count.In that event, a COUNT() query would be the way to go. For storing and retrieving IPs, MySQL has the INET_ATON() and INET_NTOA() functions.

[ManiacDan]

How long have those INET functions been around?  I did an IP-based database in 2008 and they weren't available then (or at least my entire team didn't find them).  If the INET functions weren't available I'd say storing addresses as strings was a good idea UNLESS you need to do math on them (like subnetting).

[Pikachu2000]

I'm really not sure which version added them Dan. I started using them probably about 3 yrs ago.

[Far Cry]

Storing IP addresses as strings in a database isn't terribly efficient, nor is running a query only to use mysql_num_rows() to get a count.In that event, a COUNT() query would be the way to go. For storing and retrieving IPs, MySQL has the INET_ATON() and INET_NTOA() functions.

 

Thanks for the info.