Top 5 Free PHP & Mysql Cheat Sheets

1. Added Bytes – PHP Cheat Sheet v2 

The AddedBytes cheat sheet above covers multiple php topics such as functions list and regular expressions.

2. Blue Shoes – PHP Online Cheat Sheet

If you would rather not download a php cheat sheet, BlueShoes has provided an online php cheat sheet available for you to access at anytime.

3. MySQL Online Cheat Sheet

Above you will find a helpful and quick online guide to basic and slightly complex MySQL commands.

4. Gigantic MySQL Cheat Sheet

If you’re looking for a full fledged MySQL cheat sheet, look no further. The cheat sheet above (again, by AddedBytes) contains MySQL native functions, php MySQL functions, MySQL data types, and MySQL sample queries.

5. WikiBook – MySQL Cheat Sheet

The WikiBook MySQL Cheat Sheet is an open and member contributed online MySQL guide. It has the advantage of constantly being updated as the database languages evolves.

Validate IPv4 Address in PHP

Today I am going to tell how to validate IPv4 / IP address using PHP. Simple function which will used to check client IP address is valid or not.

Steps to validate IPv4 Address in PHP

• Split IP address into segments  by dot(.)  using explode function
• Make sure that there are 4 segments (eg : 192.168.1.45)
• Make sure that IP cannot start with 0
• IP segments must be digits & cannot be longer than 3 digits or greater than 255

function validate_ip($ip)
{
 //split ip address in to array by dot
 $ip_segments = explode('.', $ip);
 // Always 4 segments needed
 if (count($ip_segments) !== 4)
 {
  return FALSE;
 }
 // IP can not start with 0
 if ($ip_segments[0][0] == '0')
 {
  return FALSE;
 }
 // Check each segment
 foreach ($ip_segments as $segment)
 {
  // IP segments must be digits and can not be
  // longer than 3 digits or greater then 255
  if ($segment == '' OR preg_match("/[^0-9]/", $segment) OR $segment > 255 OR strlen($segment) > 3)
  {
   return FALSE;
  }
 }
 return TRUE;
}

//usuage
$ip = validate_ip("192.168.1.43");
if($ip)
{
  echo "Valid IP";
} else {
  echo "Invalid IP";
}

This function will return boolean true or false

Removing index.php from Codeigniter URL

If you are using Codeigniter you are noticed that by default index.php will be included with your URL.

But you can easily remove index.php from your CodeIgniter’s URL so that your URL should be like:

http://domain.com/about

To do this just follows the following steps:

Open config.php from system/application/config directory and replace

$config['index_page'] = “index.php” by $config['index_page'] = “”

Create a “.htaccess”file in the root of CodeIgniter directory (where the system directory resides), open the file using your favorite text editor, write down the following script and save it:

RewriteEngine on
RewriteCond $1 !^(index.php|resources|robots.txt)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L,QSA]

In some case the default setting for uri_protocol does not work properly. To solve this problem just replace
$config['uri_protocol'] = “AUTO” by $config['uri_protocol'] = “REQUEST_URI” from system/application/config/config.php