Php > Miscellaneous

Banning I.P

Banning I.P

The sql: 

CREATE TABLE banip ( 
ID int(12) NOT NULL auto_increment, 
IP varchar(25) NOT NULL default '', 
PRIMARY KEY (ID) 
) TYPE=MyISAM; 

The script: 


<?php 
include "connect.php";   //this is the file that connect to sql 

$s=$_SERVER["REMOTE_ADDR"];  //draws IP address of visitor 

$ipbancheck="SELECT * from banip where IP='$s'"; 

//above lines check to see if user Ip is in banned IPs 
if(mysql_num_rows(mysql_query($ipbancheck)) > 0) { 
print "BANNED!!! Go Away!!"; 
}else{ 
//put content 
} 
?>