Learn the ABC of Ip Banning

[demonhunter]

You need Php Enabled and Mysql on your server to do this:
This tutorial will show you how to ban people by IP address with php and mysql. First you need to go into php my admin and create the follow tables:

--------------------------------------------------------------------------------

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

--------------------------------------------------------------------------------

This is the basic table structure with only two fields, a field for a ID that identifies a unique field and a field for all IP's banned. Now we'll look at the code that actually bans the IP on each. Structure each page you want IP banning this way.

--------------------------------------------------------------------------------

<?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'";
$ipbancheck2=mysql_query($ipbancheck);
while($ipbancheck3=mysql_fetch_array($ipbancheck2))
{
$IPBANNED=$ipbancheck3[IP];
}
//above lines check to see if user Ip is in banned IPs
if ($IPBANNED)
{
print "You have been banned ";
}
else
{
//put content you want unbanned users to see here
}
?>

--------------------------------------------------------------------------------

Okay, this code should be fairly simple to understand. $_SERVER["REMOTE ADDR"] draws the IP address of the user the next line select from the table of baned IP where a field matches the user's IP. If no fields match the users IP, it comes up blank. The while loop sets the variable IPBANNED equal to the banned IP if the first select statement had any matches and, if the select didn't have any matches, it doesn't set a IPBANNED variable. Then when the the next few lines says if the IPBANNED variable exists, then we shows the 'You have been banned" message, otherwise show the actual page content in the else case

[Anonymoose]

Nice, but it only works if viewers are trying to access PHP pages.

Also, considering you just asked

[Moxxnixx]

It's not just similar, it's exactly the same!

demonhunter, It's common courtesy to give credit to the original source if you
copy/paste something from another website...and, in most cases, AFTER you
ask the author for permission first.

I didn't see a "terms of use" on chipmunk's site, but like Anonymoose said,
it's still a good idea to give credit where credit is due.

[demonhunter]

Did i Make any Modifications to it? No i didnt make any Modifications to it so i placed here so that others can use it to not just using the other one

[Anonymoose]

So if you made no modifications or improvements to it, you credit the original author. :idea:

[fourtwentymatt]

Where is PHP Admin. Does it come with Abyss webserver ... if so.. where is it?

[Moxxnixx]

phpMyAdmin is popular program used to creation and management of databases
for the MySQL Database Server.
You can go to http://www.phpmyadmin.net to download the latest version.
There is a tutorial for installing it in this section or you can go to http://os17fan.cjb.net/
for an alternate tutorial.

[demonhunter]

I am not Saying i own that php code anyone can use that