MySQL/SQL Queries Fetching Current and Previous Month Data

These queries are for fetching data for the last Months only not the days. :: SQL-Query For Fetching Current Data :: SELECT * FROM table_name WHERE MONTH(field_name) = MONTH(NOW) AND YEAR(field_name) = YEAR(NOW()); :: SQL-Query For Fetching Last One Month Data :: SELECT * FROM table_name WHERE MONTH(created) = (MONTH(CURRENT_DATE)-1); :: SQL-Query For Fetching Previous 3-Months Data :: SELECT * FROM table_name WHERE field_name BETWEEN (CURDATE() - INTERVAL 4 MONTH) AND (CURDATE() - (MONTH(CURRENT_DATE)-1)); <b>:: SQL-Query For Fetching Previous x-Months Data ::</b> SELECT * FROM table_name WHERE field_name BETWEEN (CURDATE() - INTERVAL (x+1) MONTH) AND (CURDATE() - (MONTH(CURRENT_DATE)-1));

Get target check box checked in post editor

When adding a link in the WP visual post editor you have to click the settings after adding the link and then click the Open link in a new tab to have it add a link with a target in a new window/tab. Here is the way to have this automatically checked by default.

Add this function in your theme's functions.php function my_enqueue($hook) { if ('post.php' != $hook ) { return; } wp_enqueue_script('my_custom_script', get_template_directory_uri() . '/js/myscript.js'); } add_action('admin_enqueue_scripts', 'my_enqueue'); In myscript.js place this code jQuery(document).ready(function(){ jQuery('#wp-link-target').prop("checked", true); })

Get Related Posts (Posts Under Same Category/Tags)

// get related posts $term_list = wp_get_post_terms(get_the_ID(), 'my_taxonomy', array("fields" => "ids")); $args = array( 'post_type' => 'my_post_type', 'post__not_in' => array(get_the_ID()), 'orderby' => 'rand', 'tax_query' => array( 'relation' => 'AND', array( 'taxonomy' => 'articles_cat', 'field' => 'term_id', 'terms' => $term_list, 'operator' => 'IN', ), ), ); $query = new WP_Query($args); while ( $query->have_posts() ) : $query->the_post(); echo $post->ID; echo $post->post_title; echo $post->post_content; echo '<img width="298" height="198" src="'.wp_get_attachment_url(get_post_thumbnail_id($post->ID)).'" u="image">'; echo get_permalink(); endwhile; wp_reset_query();

jQuery simple slider

<img alt="" id="slide" width="800px" /> <script type="text/javascript"> //Images Array //<> var img = [ 'http://127.0.0.1/mglearn/skin/frontend/rwd/default/images/media/homepage_banner_1@2x.jpg', 'http://127.0.0.1/mglearn/skin/frontend/rwd/default/images/media/homepage_callout_3.jpg', 'http://127.0.0.1/mglearn/skin/frontend/rwd/default/images/media/homepage_banner_2.jpg']; var cnt = 0; function slideOut() { jQuery('#slide').animate({opacity:1}, 1300).attr('src', img[cnt]).delay(2000).animate({left:'+=800', opacity:0},1300); cnt++; if(img.length == cnt) { cnt = 0; } } setInterval(function(){slideOut();}, 4700); slideOut(); </script>

Function for Showing Page Navigation on WordPress

function wp_pagenavi($pages = '', $range = 4) { $showitems = ($range * 2) + 1; global $paged; if (empty($paged)) $paged = 1; if ($pages == '') { global $wp_query; $pages = $wp_query->max_num_pages; if (!$pages) { $pages = 1; } } if (1 != $pages) { echo "<div class=\"pagination\"><span>Page " . $paged . " of " . $pages . "</span>"; if ($paged > 2 && $paged > $range + 1 && $showitems < $pages) echo "<a href='" . get_pagenum_link(1) . "'>« First</a>"; if ($paged > 1 && $showitems < $pages) echo "<a href='" . get_pagenum_link($paged - 1) . "'>‹ Previous</a>"; for ($i = 1; $i <= $pages; $i++) { if (1 != $pages && (!($i >= $paged + $range + 1 || $i <= $paged - $range - 1) || $pages <= $showitems )) { echo ($paged == $i) ? "<span class=\"current\">" . $i . "</span>" : "<a href='" . get_pagenum_link($i) . "' class=\"inactive\">" . $i . "</a>"; } } if ($paged < $pages && $showitems < $pages) echo "<a href=\"" . get_pagenum_link($paged + 1) . "\">Next ›</a>"; if ($paged < $pages - 1 && $paged + $range - 1 < $pages && $showitems < $pages) echo "<a href='" . get_pagenum_link($pages) . "'>Last »</a>"; echo "</div>\n"; } }

Code for Blocking Plugin Updates

/** Here, I blocked s2Member updates **/
/** You have to pass main file path. **/
function filter_plugin_updates($value) {
    unset($value->response['s2member/s2member.php']);
    return $value;
}
add_filter('site_transient_update_plugins', 'filter_plugin_updates');

Handling Post Request in PHP

Instead of $_POST you can handle the post data using function. By using this you need not to worry about the undefined index notice.

function postData($key) {
    $res = '';
    if (isset($_POST[$key])) {
        if (!is_array($_POST[$key])) {
            $res = htmlentities($_POST[$key]);
        } else if (is_array($_POST[$key]) && !empty($_POST[$key])) {
            $res = array();
            foreach ($_POST[$key] as $k => $v) {
                $res[$k] = htmlentities($v);
            }
        }
        return $res;
    }
    return '';
}

Function for Currency Conversion PHP

function currencyConvert($from, $to, $amount) {
    $url = "http://www.google.com/finance/converter?a=$amount&from=$from&to=$to";
    $request = curl_init();
    $timeOut = 0;
    curl_setopt($request, CURLOPT_URL, $url);
    curl_setopt($request, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($request, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']);
    curl_setopt($request, CURLOPT_CONNECTTIMEOUT, $timeOut);
    $response = curl_exec($request);
    curl_close($request);
    return $response;
}

Get Key From Array JavaScript

var _dat = array('name':'Rahul Dravid');
for (var prop in _dat) 
{
   //Adding extra parameters to form_data
   console.log(_dat[prop]['name'])
}