Vidiame - Navigating YOU to future success.

September 19, 2024 0

How does SEO improve your website?

Site improvement or SEO alludes to the way toward enhancing the position that your site shows up at in the "natural" list items returned by destinations, for example, Google. When in doubt of thumb, destinations that seem higher up in…

SEO

September 19, 2024 0

16+ WordPress Plugins That Make Your Blog Perfect!

No one can denies that WordPress plugins are so handful. In this post I am going to show you 16 plugins that I believe they are essential to make a blog works perfectly. If you have any suggestions or comments…

SEO

September 18, 2024 0

Google Page Rank Has Been Updated

I would like to announce that Google has updated the Page Rank today October 30, 2009. The last update was in August 2009. So if you own a website you can go and check your new PR. Vidiame has not been affected…

How To Upload a Big SQL File To MySQL

Recently, I wanted to upload a 10GB SQL file to MySQL using PhpMyAdmin. unfortunately, it didn’t work properly. the fields were created in the database but with no records. It seemed to be a memory and PHP configuration issue. After that i made some searches. And eventually, figured out that there is a script called BigDump is made for this purpose.

To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can’t access the server shell and you can’t import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server. -ozerov.de/bigdump.php

alright, so now all what you gotta do is to follow these steps:

Download the script (10 KB ZIP archive).
open BigDump.php with any text editor. Edit your MySQL connection information.

$db_server   = '';
$db_name     = '';
$db_username = '';
$db_password = '';

Upload the script (bigdump.php) to your server.
Upload the SQL (.sql) file to your server.
Go to http://www.mywebsite.com/bigdump.php and from there you can start the process.

Click on Start Import and you are done! Congrats.

For more information and detailed steps, you can visit BigDump homepage.

How To Block Multiple IP Addresses Using PHP

Sometimes you need to disallow a visitor to access your website. The most common reason for this is Spammers. Although there are several other solutions to block multiple IP addresses such as using Apache’s mod_rewrite which I am going to write about it soon. but today I am going to focus on the method of PHP.

Now, Let’s start the code from the beginning.

Step One: Adding The IPs

<?php
// The blacklisted IPs.
$denied_ips = array(
		    '123.456.789.1',
		    '127.0.0.1',
		    '67.220.200.75'
		);

I opened a PHP tag and then created a variable named $denied_ips contains an array of the 3 assigned values which are the IPs we are dealing with. Also you may want to use an external file rather than opening this PHP file every time you want to edit the IPs. it’s easy, just create a new file name it “blacklist.txt” or whatever, and put the IPs that you want to disallow. Another thing you have to do is to change the code to this.

// The blacklisted ips.
$denied_ips = file('ips.txt');

Step Two: Getting The Visitor’s IP

// Function to get the visitor's IP.
function getUserIP()
{
    //check ip from share internet
    if (!empty($_SERVER['HTTP_CLIENT_IP']))
    {
      $ip=$_SERVER['HTTP_CLIENT_IP'];
    }
    //to check ip is pass from proxy
    elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
    {
      $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
    }
    else
    {
      $ip=$_SERVER['REMOTE_ADDR'];
    }
	return $ip;
}

//The user IP
$visitorIp = getUserIP();

This is the function we are going to use to get the IP of the visitor. Some people just like to use $_SERVER[‘REMOTE_ADDR’] which is fine but i believe by this method we will get more accurate data. Also i have assigned the variable $visitorIp to the function getUserIP().

Edit: Using $_SERVER[‘HTTP_X_FORWARDED_FOR’] to detect the IP could be useless sometimes. And even a reason to grant access to the visitor since it can be modified. So you can just use:

// Function to get the visitor's IP.
function getUserIP()
{
    //check ip from share internet
    if (!empty($_SERVER['HTTP_CLIENT_IP']))
    {
      $ip=$_SERVER['HTTP_CLIENT_IP'];
    }
    else
    {
      $ip=$_SERVER['REMOTE_ADDR'];
    }
	return $ip;
}

//The user IP
$visitorIp = getUserIP();

Step Three: Matching The IPs

// Now let's search if this IP is blackliated
$status = array_search($visitorIp, $denied_ips);

// Let's check if $status has a true OR false value.
if($status !== false)
    {
	echo "YOUR IP HAS BEEN BANNED.";
	// header("Location: http://zombo.com");
	exit;
    }

In the code above the function array_search Searches the array for a given value and returns the corresponding key if successful. So the variable $status is Boolean, if it’s true the program will stop and print “YOUR IP HAS BEEN BANNED”. Otherwise the script will work normally. the redirection to zombo.com is just for irony.

the Complete Code

<?php
// The blacklisted ips.
$denied_ips = array(
		    '123.456.789.1',
		    '127.0.0.1',
		    '67.220.200.75'
		);

// The function to get the visitor's IP.
function getUserIP()
{
    //check ip from share internet
    if (!empty($_SERVER['HTTP_CLIENT_IP']))
    {
      $ip=$_SERVER['HTTP_CLIENT_IP'];
    }
    //to check ip is pass from proxy
    elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
    {
      $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];
    }
    else
    {
      $ip=$_SERVER['REMOTE_ADDR'];
    }
	return $ip;
}

//The user
$visitorIp = getUserIP();

// Now let's search if this IP is blackliated
$status = array_search($visitorIp, $denied_ips);

// Let's check if $status has a true OR false value.
if($status !== false)
    {
	echo "YOUR IP HAS BEEN BANNED.";
	// header("Location: http://zombo.com");
	exit;
    }
?>

Conclusion

Even though this is mostly used to block IPs from a particular website, it can be used in some other ideas as to verify if the user has only one account and so on. I hope you enjoyed this tutorial and thanks for reading. If you you have anything to say please leave it in the comments section below.

Golf Training Tips for Senior Golfers to Increase Distance

What Is Information Technology?

St. Patrick’s Day Centerpieces

The Hunt for Perfect Skin: Innovative Skincare’s Active Serum

What Do Technology Jobs Pay?

Golf Training Tips for Senior Golfers to Increase Distance

How To Block Multiple IP Addresses Using PHP

A Modest Reflection of Getting Things Done

Know if Someone is Copying Your Blog Articles

Ping Search Engines for Your Sitemap

Golf Training Tips for Senior Golfers to Increase Distance

What Is Information Technology?

St. Patrick’s Day Centerpieces

The Hunt for Perfect Skin: Innovative Skincare’s Active Serum

What Do Technology Jobs Pay?