Tuesday 29 December 2015

MySql replace function

UPDATE MyTable

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

WHERE SomeOtherColumn LIKE '%PATTERN%'

Sunday 11 October 2015

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> 

Thursday 1 October 2015

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 
cmd-prompt-usb-bootable

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”
Clean Cmd USB Drive
Next we want to clean the USB drive
Type:
CLEAN
you will get a successful response ‘DiskPart succeeded in cleaning the disk”.
Clean USB Drive

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.
Bootable USB Final Cmd Prompt
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.

Thursday 16 July 2015

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]

Thursday 9 July 2015

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');

Tuesday 28 April 2015

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>