MySql replace function

UPDATE MyTable

SET StringColumn = REPLACE (StringColumn, 'SearchForThis', 'ReplaceWithThis')

WHERE SomeOtherColumn LIKE '%PATTERN%'

Wordpress Add multiple custom fields to the general settings page

Add multiple custom fields to the general settings page

function register_fields()
{
    register_setting('general', 'my_first_field', 'esc_attr');
    add_settings_field('my_first_field', '<label for="my_first_field">'.__('My Field' , 'my_first_field' ).'</label>' , 'print_custom_field', 'general');
}

function print_custom_field()
{
    $value = get_option( 'my_first_field', '' );
    echo '<input type="text" id="my_first_field" name="my_first_field" value="' . $value . '" />';
}

add_filter('admin_init', 'register_fields');

Function Reference/get settings

Reading a settings Value in wordpress

<h1><?php echo get_settings('blogname'); ?></h1> 

Recent Post of Particular Parent Category

 Wordpress List Recent Post of Particular Parent Category

<?php $query = new WP_Query( 'category_name=blog&posts_per_page=5' );?>

    <ul>
<?php while ( $query->have_posts() ) : $query->the_post(); ?>
      <li> <a href="<?php the_permalink() ?>"><?php the_title();  ?> </a></li>
 <?php endwhile;?>
    </ul>

How to make Windows 7 bootable install USB stick

Install Windows 7 from a USB drive

Preparing the USB drive:

1. Open command prompt as administrator - Right click on Start > All Programs > Accessories > Command Prompt and select Run as administrator or type cmd in the Start search bar.
2. Run diskpart utility by typing diskpart into command prompt window and pressing “Enter”.
3. Locate your USB drive disk number by executing list disk. We'll assume the USB drive is 1.
4. Run the following commands:
   1. select disk 1
   2. clean
   3. create partition primary
   4. select partition 1
   5. active
   6. format fs=NTFS
   7. assign
   8. exit

Now we have prepared USB drive. Lets make it bootable:

1. Insert Windows 7, 32/64-bit installation disk into DVD drive. Let's assume it's D
2. Go to D:\boot (cd d:\boot)
3. If your USB drive letter is “e” please run bootsect /nt60 e:
4. Copy DVD Windows 7 media content to USB root folder (etc. don't put it into any folder)

1. Install Windows 7 from a USB drive 

Next type

DISKPART

this loads the diskpart application we need to proceed

Then type

LIST DISK

the image above shows our 32 GB USB drive is listed as DISK 2

so you have to type

SELECT DISK 2 (your USB Drive may have a different number, don’t follow exactly this text it depends on your usb drive)

You will get a successful response “Disk 2 is now the selected disk”

Next we want to clean the USB drive

Type:

CLEAN

you will get a successful response ‘DiskPart succeeded in cleaning the disk”.

After the drive is cleaned follow the list in the image above (detailed below in list order) – you can also note the successful text responses from the OS as you enter each command.

SELECT DISK 2 (or what number your USB drive has)

CREATE PARTITION PRIMARY

SELECT PARTITION 1

ACTIVE

FORMAT FS=NTFS

Formatting can take a little time depending on the size of the drive, our 32GB unit took about 10 minutes to format - you will see a percentage readout until it is finished.

Next type:

ASSIGN

EXIT (DISK PART will exit)

Type D: CD BOOT (substitute the “D” if necessary with the letter of your Windows 7 DVD drive)

then key

CD BOOT

then

BOOTSECT.EXE /NT60 E: (substitute the “E” if necessary with the letter of your now ready USB drive) – we are telling the system to create a boot sector file on the USB drive.

Now you can exit the command prompt and copy all the files on the Windows 7 DVD to the USB drive.

Once this step is finished you’ll be ready to boot from this drive, all you need to do is configure your motherboard bios setup to boot first from USB rather than hard drive or optical drive. If you don’t know how to do this, refer to your specific motherboard manual or search the internet.

Redirect domain.com to m.domain.com on mobile devices using htaccess

m.domain.com on mobile devices using htaccess

RewriteEngine On
RewriteBase /

RewriteCond %{HTTP_USER_AGENT} (android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge\ |maemo|midp|mmp|mobile.+firefox|netfront|opera\ m(ob|in)i|palm(\ os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows\ ce|xda|xiino [NC,OR]
RewriteCond %{HTTP_USER_AGENT} ^(1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a\ wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r\ |s\ )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1\ u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp(\ i|ip)|hs\-c|ht(c(\-|\ |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac(\ |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt(\ |\/)|klon|kpt\ |kwc\-|kyo(c|k)|le(no|xi)|lg(\ g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-|\ |o|v)|zz)|mt(50|p1|v\ )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v\ )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-|\ )|webc|whit|wi(g\ |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-) [NC]
RewriteRule ^$ http://m.domain.com/ [R,L]

Stop and Fix WordPress Ask for FTP Credentials

The easiest way to solve this problem is add the following FTP information to your wp-config.php

define('FS_METHOD', 'direct');

Prevent file caching with a .htaccess file

Avoid  file caching with a .htaccess file

<filesMatch "\.(html|htm|js|css)$">
  FileETag None
  <ifModule mod_headers.c>
     Header unset ETag
     Header set Cache-Control "max-age=0, no-cache, no-store, must-revalidate"
     Header set Pragma "no-cache"
     Header set Expires "Wed, 11 Jan 1984 05:00:00 GMT"
  </ifModule>
</filesMatch>