Update record if exists, else write new record


 INSERT INTO upsert_table(id, name, value) VALUES(4,"Check_Upsert",888) ON DUPLICATE KEY UPDATE name = VALUES(name), value = VALUES(value);

If id=4 already there in table it will update values else write the new record in table


2015 in My site review From WordPress.com

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 15,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 6 sold-out performances for that many people to see it.

Click here to see the complete report.

Disable the content editor for a specific page template

Use this snippet in your theme’s functions.php file to disable the editor for a specific page template.

add_action( 'admin_init', 'hide_editor' );

function hide_editor() {
    // Get the Post ID.
    $post_id = $_GET['post'] ? $_GET['post'] : $_POST['post_ID'] ;
    if( !isset( $post_id ) ) return;

    // Get the name of the Page Template file.
    $template_file = get_post_meta($post_id, '_wp_page_template', true);
    if($template_file == 'contact.php'){ // edit the template name
        remove_post_type_support('page', 'editor');

Date picker required doesn’t work in Contact Form 7

Date picker required doesn’t work in Contact Form 7

You need to edit core plugin files before that you need to save contact-form-7-datepicker folder for backup

You go to  wp-content/plugins/contact-form-7-datepicker/modules/date.php

Normal Code (Line Number :124)

if ('datetime*' == $type && empty($value)) {
    $result['valid'] = false;
    $result['reason'][$name] = wpcf7_get_message('invalid_required');
if (! empty($value) && ! self::is_valid_date($value)) {
    $result['valid'] = false;
    $result['reason'][$name] = wpcf7_get_message('invalid_datetime');

Change to below code

if ('date*' == $type && empty($value)) {
    $result['valid'] = false;
    $result['reason'] = array($name => wpcf7_get_message('invalid_required'));
if (! empty($value) && ! self::is_valid_date($value)) {
    $result['valid'] = false;
    $result['reason'] = array($name => wpcf7_get_message('invalid_datetime'));

Then I changed also time.php (from line 119) and datetime.php (from line 119) files in that similar way.
I hope this helps to you

How to get Custom Menu in Query Posts WordPress

    $args = array(
    'post_type' => 'nav_menu_item', 'orderby'   => 'menu_order',
    'order'  => 'ASC',
    'tax_query' => array(
            'taxonomy' => 'nav_menu', 'field' => 'slug', 'terms' => 'my'        
while( have_posts()):the_post();
echo $post->ID;
endwhile; wp_reset_query();?>