Remove .PHP or .HTML From URL

1. Enable The below module in Httpd.conf in Apache

"rewrite_module" find it in httpd.conf and remove the "#" from that line


2. Create .htaccess file in notepad with below code

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^([^\.]+)$ $1.php [NC,L]


3. Save this file with the Extension ".htaccess" without giving any name

now you don't need to write extension in code for jump any page

Creating A bootable Pen Drive

creating bootable pen drive  follow the below steps.....................

1. U must have an OS image as "winxp.iso" or win7.iso or nrg(if you don't have search in google for that)
2. To download PowerIso click Here Download
3. format pen drive
4. go to tools option and  click create bootable usb drive
5. Select iso file and click on start

Unlock forgotten mobile Pattern in Android Phones

To Unlock The android phone if You forget the pattern use below steps:

1. switch off phone
2. on phone with pressing the volume up key and home button
3. select the options to restore or reset the user data

Enable Any Extension in php On runtime

When we are using PHPMAILER for email service we found error that "ssl is not enable " So here some code so that u can enable it on runtime

<?php
// Example loading an extension based on OS
if (!extension_loaded('openssl')) {
    if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
        dl('php_openssl.dll');
    } else {
        dl('openssl.so');
    }
}

// Or, the PHP_SHLIB_SUFFIX constant is available as of PHP 4.3.0
if (!extension_loaded('openssl')) {
    $prefix = (PHP_SHLIB_SUFFIX === 'dll') ? 'php_' : '';
    dl($prefix . 'openssl.' . PHP_SHLIB_SUFFIX);
}
?>
For looking that it enable or not........................
<?php
if (extension_loaded('openssl')) {
echo 'openssl extension is loaded and everything is fine!';
}
else {
echo 'Where is the openssl library?';
exit();
}
?>

Calculate second min and max row values average in SQL

select (  (  (select row_name from table_name order by row_name desc limit 1,1) + (select row_name  from
table_name order by  row_name asc limit 1,1) )/2) as average from table_name ;