query code example

//Post Query in index.php
<?php if(have_posts()) : ?>
<?php while (have_posts()) : the_post(); ?>
<--Your Post Query here -->
<?php endwhile; ?>
<?php endif; ?>
        <!--or-->
<?php if(have_posts()) : ?>
<?php while (have_posts()) : the_post(); ?>
<--Your Post Query here -->
<?php endwhile; ?>
<?php else : ?>
<h3><?php _e('404 Error&#58; Not Found'); ?></h3>
<?php endif; ?>


//Custom page Query in page dynamic
<?php while(have_posts()) : the_post(); ?>
    <?php the_content(); ?>
<?php endwhile; ?>

<?php while(have_posts()) : the_post(); ?>
    <h2><?php the_title(); ?></h2>
<?php endwhile; ?>

//Custom Post Query in index.php
<?php
global $post;
$args = array( 'posts_per_page' => -1, 'post_type'=> 'working-method', 'department_cat' => 'Commerical', 'p' => '30', 'post__in' => array( 2, 5, 12, 14, 20 ) );
$myposts = get_posts( $args );
foreach( $myposts as $post ) : setup_postdata($post); ?>
// Your Post Query here -->
<?php endforeach; ?>

//Custom Post Query for pagenavi support
<?php
  $temp = $wp_query;
  $wp_query = null;
  $wp_query = new WP_Query();
  $wp_query->query('showposts=6&category_name=Beauty&post_type=post'.'&paged='.$paged);
  while ($wp_query->have_posts()) : $wp_query->the_post();
?>

 // Your Post Query here -->

<?php endwhile; ?>
<?php if (function_exists('wp_pagenavi')) { wp_pagenavi(); } else { include('navigation.php'); } ?>
<?php
  $wp_query = null;
  $wp_query = $temp;  // Reset
?>

----------------------or --------------------------
// Post Query for pagenavi support
<?php query_posts('post_type=post&post_status=publish&posts_per_page=30&paged='. get_query_var('paged')); ?>
    <?php if(have_posts()) : ?>
    <?php while (have_posts()) : the_post(); ?>
        // Your Post Query here -->
    <?php endwhile; ?>
    <?php endif; ?>
<?php if (function_exists('wp_pagenavi')) { wp_pagenavi(); } else { include('navigation.php'); } ?>


==============================================
QUERY CODE FOR RELATED POST WITH AND WITHOUT THUMBNAIL
==============================================
<?php $orig_post = $post;
    global $post;
    $categories = get_the_category($post->ID);
    if ($categories) {
    $category_ids = array();
    foreach($categories as $individual_category) $category_ids[] = $individual_category->term_id;

    $args=array(
    'category__in' => $category_ids,
    'post__not_in' => array($post->ID),
    'posts_per_page'=> 6, // Number of related posts that will be shown.
    'caller_get_posts'=>1
    );

    $my_query = new wp_query( $args );
    if( $my_query->have_posts() ) {
    echo '<div class="single_coment_all">';
    while( $my_query->have_posts() ) {
    $my_query->the_post();?>
    <div class="single_coment floatleft fix">
        <div class="relatedthumb_img">
            <a href="<?php the_permalink()?>" rel="bookmark" title="<?php the_title(); ?>">
                <?php the_post_thumbnail('related_image'); ?>
            </a>
        </div>
        <div class="comments_caption">
            <div class="comments_caption_left">
                <p><?php the_category(', '); ?></p>
            </div>
            <div class="comments_caption_right">
                <a href="<?php the_permalink(); ?>"><h2><?php the_title(); ?></h2></a>
            </div>
        </div>
    </div>
    <?php
    }
    echo '</div>';
    }
    }
    $post = $orig_post;
    wp_reset_query(); ?>

=============================================
কোন একটা নির্দিষ্ট ক্যাটেগরির পপুলার পোস্ট শো করুন লিস্ট আকারে
=============================================
<?php

$args=array(
'cat' => 58, // this is category ID
'orderby' => 'comment_count',
'order' => 'DESC',
'post_type' => 'post',
'post_status' => 'publish',
'posts_per_page' => 6, // how much post you want to display
'caller_get_posts'=> 1
);

$my_query = null;
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) { ?>

<ul>
<?php while ($my_query->have_posts()) : $my_query->the_post(); ?>

<li><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></li>

<?php  endwhile; ?>
</ul>
<?php }

wp_reset_query(); ?>

========================================
show related posts form current taxonomy
==========================================

function pippin_related_posts($taxonomy = '') {

    global $post;

    if($taxonomy == '') { $taxonomy = 'post_tag'; }

    $tags = wp_get_post_terms($post->ID, $taxonomy);
    $content = '';
    if ($tags) {
        $first_tag  = $tags[0]->term_id;
        $second_tag = $tags[1]->term_id;
        $third_tag  = $tags[2]->term_id;
        $args = array(
            'post_type' => get_post_type($post->ID),
            'posts_per_page' => 4,
            'tax_query' => array(
                'relation' => 'OR',
                array(
                    'taxonomy' => $taxonomy,
                    'terms' => $second_tag,
                    'field' => 'id',
                    'operator' => 'IN',
                ),
                array(
                    'taxonomy' => $taxonomy,
                    'terms' => $first_tag,
                    'field' => 'id',
                    'operator' => 'IN',
                ),
                array(
                    'taxonomy' => $taxonomy,
                    'terms' => $third_tag,
                    'field' => 'id',
                    'operator' => 'IN',
                )
            )
        );
        $related = get_posts($args);
        $i = 0;
        if( $related ) {
            global $post;
            $temp_post = $post;
                foreach($related as $post) : setup_postdata($post);
                    $content .= '<ul class="related-posts-box">';
                        $content .= '<li><a href="' . get_permalink() . '" title="' . get_the_title() . '">' . get_the_title() . '</a></li>';
                    $content .= '</ul>';

                endforeach;
            $post = $temp_post;
        }
    }

    return $content;
}


add_action('the_content', 'do_jt_related_posts');
function do_jt_related_posts() {

    if( is_singular('post') ) :
        echo get_the_content();
        echo pippin_related_posts();
    else :
        echo get_the_content();
endif;  }

==============================================
query code for display post from each category
==============================================
<?php
  // array of category IDs
  $categories =  array(10,9,8,7,6,5,4,3,2,1);

  foreach ($categories as $cat) :
    $post = false;
    $post = get_posts('cat='.$cat.'&posts_per_page=1');
    if($post) :
      $post = $post[0];
      setup_postdata($post); ?>
    // Your content for loop

    <?php endif; ?>
  <?php endforeach; ?>


==================================================
        bootstrap carousel query code
==================================================
  <!-- Carousel-->
<?php
$items = new WP_Query(array(
'post_type' => 'banner-items',
'posts_per_page' => -1,
'meta_key' => '_thumbnail_id'
));
$count = $items->found_posts;
?>

  <div id="myCarousel" class="carousel slide" data-ride="carousel">
      <!-- Indicators -->
    <ol class="carousel-indicators">
      <li data-target="#myCarousel" data-slide-to="0" class="active"></li>
      <?php for($num = 1; $num < $count; $num++){ ?>
      <li data-target="#myCarousel" data-slide-to="<?php echo $num; ?>"></li>
      <?php } ?>
    </ol>

    <div class="carousel-inner">
<?php
        $ctr = 0;
        while ( $items->have_posts() ) :
          $items->the_post();
          $url = wp_get_attachment_url( get_post_thumbnail_id($post->ID) );
          $custom = get_post_custom($post->ID);
          $link = $custom["more-link"][0];
          $class = $ctr == 0 ? ' active' : '';
        ?>

        <div class="item<?php echo $class; ?>" id="<? the_ID(); ?>">
            <img src="<?php $image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), '' ); echo $image[0]; ?>">
            <div class="container">
              <?php the_content(); ?>
            </div>
        </div>
    <?php $ctr++;
        endwhile;  ?>


    </div>
    <!-- /.carousel-inner -->

    <!-- Controls -->
    <a class="left carousel-control" href="#myCarousel" role="button" data-slide="prev"> <span class="fa fa-angle-left fa-5x"></span> </a>
    <a class="right carousel-control" href="#myCarousel" role="button" data-slide="next"> <span class="fa fa-angle-right fa-5x"></span> </a>

    </div>
  <!-- /.carousel -->

============================================
 Carousel Loop for slide 4 or many post together
============================================
function event_get_carousel(){
 $owlcarousel= '<div class="single_events">';
 $efs_query= "post_type=tribe_events&posts_per_page=-1";
 query_posts($efs_query);
 if (have_posts()) : while (have_posts()) : the_post();
  $thumb= get_the_post_thumbnail();
  $owlcarousel.=' <div class="single_ticket">
      '.$thumb.'
      <h2>'.get_the_title().'</h2>
      <p>' . tribe_get_full_address( get_the_ID() ) . '</p>
      <h3>'.tribe_events_event_schedule_details().'</h3>
      <a href="'.get_the_permalink().'">Buy Ticket</a>
      </div>
     ';
 endwhile; endif; wp_reset_query();
 $owlcarousel.= '</div>';
 return $owlcarousel;
}

/**add the shortcode for the slider- for use in editor**/
function event_insert_carousel($atts, $content=null){
 $owlcarousel= event_get_carousel();
 return $owlcarousel;
}
add_shortcode('events', 'event_insert_carousel');


==================================================
How to remove menus in WordPress dashboard
==================================================
Simply paste the following code into the functions.php file of your theme. The following example will remove all menus named in the $restricted array.

function remove_menus () {
global $menu;
    $restricted = array(__('Dashboard'), __('Posts'), __('Media'), __('Links'), __('Pages'), __('Appearance'), __('Tools'), __('Users'), __('Settings'), __('Comments'), __('Plugins'));
    end ($menu);
    while (prev($menu)){
        $value = explode(' ',$menu[key($menu)][0]);
        if(in_array($value[0] != NULL?$value[0]:"" , $restricted)){unset($menu[key($menu)]);}
    }
}
add_action('admin_menu', 'remove_menus');

 =======================================================
bxslider.com/examples/thumbnail-pager-1   dynamic code by custom post
=======================================================
<div id="slider" class="row" style="padding:0; position:relative">
    <ul class="bxslider" >
        <?php  $args = array(
            'post_type' => 'slider',
            'posts_per_page' => 4,
            'order' => 'DESC',
            'orderby' => 'date'
        );?>

        <?php $slider = new WP_Query($args); while($slider->have_posts()) : $slider->the_post(); ?>
      <li>
        <?php the_post_thumbnail('slider'); ?>
        <div class="col-md-7 hidden-sm hidden-xs" style="padding:0">
            <div class="titulo">
                <h3><?php the_title(); ?></h3>
            </div>
        </div>
      </li>

    <?php endwhile; wp_reset_postdata(); ?>
    </ul>

    <div class="container navegador hidden-sm hidden-xs">
        <div class="row">
            <div class="col-md-5 col-md-offset-7 text-right" style="padding:0;" >
                <div id="bx-pager">
                    <?php  $args = array(
                        'post_type' => 'slider',
                        'posts_per_page' => 4,
                        'order' => 'DESC',
                        'orderby' => 'date'
                    );?>
                    <?php $numero = 0; ?>
                        <?php $slider = new WP_Query($args); while($slider->have_posts()) : $slider->the_post(); ?>
                            <a data-slide-index="<?php echo $numero; ?>" href=""><?php the_post_thumbnail('thumbnailSlider'); ?></a>
                        <?php $numero++; ?>
                    <?php endwhile; wp_reset_postdata(); ?>
                </div>
            </div>
        </div>
    </div>

    <div class="clearfix"></div>

</div> <!--/#slider -->

=======================================================
Owl carousel dynamic code multiple item like 4 item slide with 1 item
=======================================================
<div class="custom_slider">
    <div id="owl-demo" class="owl-carousel owl-theme">

        <?php if(!is_paged()) { ?>
        <?php
        $args = array( 'post_type' => 'main-slider', 'posts_per_page' => -1 );
        $loop = new WP_Query( $args );
        $count=2;
        ?>

        <div class="item">
        <?php while ( $loop->have_posts() ) : $loop->the_post(); ?>

        <?php
                $state = get_post_meta($post->ID, 'state', true);
                $location = get_post_meta($post->ID, 'location', true);
                $phone = get_post_meta($post->ID, 'phone', true);
                $website = get_post_meta($post->ID, 'website', true);
                $facebook = get_post_meta($post->ID, 'facebook', true);
                $fblink = get_post_meta($post->ID, 'fblink', true);

            ?>


            <div class="single_slider floatleft">
                <div class="fetured_img">
                    <a href="<?php echo site_url(); ?>/EPARCH "><?php the_post_thumbnail('main_slider_image'); ?></a>
                </div>
                <a href="<?php echo site_url(); ?>/EPARCH "><h2><?php the_title();?></h2></a>
                <p><?php echo $state; ?> <?php echo $location; ?><br/>
                <?php echo $phone; ?> <span><?php echo $website; ?></span></p>
                <div class="social_icon">
                    <a href="<?php echo $fblink; ?>"><img src="<?php echo $facebook; ?>" alt="" /></a>
                </div>
            </div>
        <?php
        if($count%4==1&&$count>1){
            echo '</div><div class="item">';
            }
            $count++;
         ?>
        <?php endwhile; ?>
        </div>
        <?php wp_reset_query(); ?>
        <?php } ?>

    </div>
</div>


=======================================================
bxslider.com/examples/thumbnail-pager-1   dynamic code by Metabox slider
=======================================================
<div class="portfolio_single_wrapper fix">

                <?php
                $spyr_demo_slider = get_post_meta( $post->ID, 'spyr_demo_slider', true );

                echo '<div id="portfolio_single_slider" class="fix">';
                foreach( $spyr_demo_slider as $slide ) {

                            echo '<div class="portfolio_single_item fix">
                            <img src="'. $slide['image'] .'" alt="" />
                            </div>';
                }
                echo '</div>';

                ?>


            <?php
                $spyr_demo_slider = get_post_meta( $post->ID, 'spyr_demo_slider', true );
                $numero = 0;

                echo '<div id="portfolio_single_pager" class="fix">';
                foreach( $spyr_demo_slider as $slide ) {


                            echo '<a data-slide-index="'.$numero.'" class="pager" href=""><img src="'. $slide['image'] .'" alt="" /></a>';
                    $numero++;
                }

                echo '</div>';

                ?>
                <div class="portfolio_single_content fix">
                    <h2><?php the_title(); ?></h2>
                    <?php the_content(); ?>
                </div>
            </div>
            <!-- Portfolio Single Page Content End There -->

===========================================================
conditional query code for different post size by one query
===========================================================
<?php
$the_query = new WP_Query( array( 'posts_per_page' => 7 ) );
if ( $the_query->have_posts()) : ?>
<?php $count = 0; ?>
<?php while ($the_query->have_posts()) : $the_query->the_post(); ?>
<?php $count++; ?>


  <?php if ($count == 1) : ?>

    <div class="third_post single-latest">
       <a href="<?php the_permalink(); ?>"> <?php the_title(); ?></a>
        <?php the_post_thumbnail('post-image'); ?>
        <?php the_excerpt(); ?>
    </div>

  <?php elseif ($count == 2) : ?>
    <div class="fourth_post single-latest">

        <a href="<?php the_permalink(); ?>"> <?php the_title(); ?></a>
        <?php the_post_thumbnail('post-image'); ?>
        <?php the_excerpt(); ?>
    </div>
  <?php elseif ($count == 3) : ?>
    <div class="fourth_post single-latest">

        <a href="<?php the_permalink(); ?>"> <?php the_title(); ?></a>
        <?php the_post_thumbnail('post-image'); ?>
        <?php the_excerpt(); ?>
    </div>

   <?php else : ?>
    <div class="single_post single-latest">
         <a href="<?php the_permalink(); ?>"> <?php the_title(); ?></a>
          <?php the_excerpt(); ?>
    </div>

<?php endif; ?>
<?php endwhile; ?>
<?php endif; ?>



===========================
কাস্টম পোষ্ট টাইপ থেকে ৩টা ইভেন্ট এনে শো করাতে হবে, কিন্তু সমস্যা হল "featured" category কে প্রাধান্য দিতে হবে। "featured" category থেকে যদি ৩টা আপকামিং ইভেন্ট পেয়ে যাই তাহলে শো করবে, যদি "featured" category থেকে যদি ৩টা আপকামিং ইভেন্ট না পাই তখন অন্য category থেকে আপকামিং ইভেন্ট এনে শো করাতে হবে। যেমন- "featured" category থেকে ১টা আপকামিং ইভেন্ট পাইলে বাকি ২টা আপকামিং ইভেন্ট অন্য category থেকে এনে শো করবে।
===========================
$ev1 = [];
        $ev2 = [];

        $events1_args = array(
          'post_type'     => 'ctc_event',
          'meta_query' => array(
            array(
              'key' => '_ctc_event_end_date',
              'value' => date_i18n( 'Y-m-d' ),
              'compare' => '>=',
              'type' => 'DATE'
            ),
          ),
          'meta_key'      => '_ctc_event_start_date_start_time',
          'meta_type'     => 'DATETIME',
          'orderby'     => 'meta_value',
          'order'       => 'ASC',
          'posts_per_page' => 3,
          'fields' => 'ids',
          'tax_query' => array(
              array(
                  'taxonomy' => 'ctc_event_category',
                  'field'    => 'slug',
                  'terms'    => 'featured',
              ),
          ),
        );

        $events1 = new WP_Query( $events1_args );
        $e1count = $events1->post_count;
        $ev1 = $events1->posts;

        if($e1count < 3){
            $events2_args = array(
            'post_type'     => 'ctc_event',
            'meta_query' => array(
              array(
                'key' => '_ctc_event_end_date',
                'value' => date_i18n( 'Y-m-d' ),
                'compare' => '>=',
                'type' => 'DATE'
              ),
            ),
            'meta_key'      => '_ctc_event_start_date_start_time',
            'meta_type'     => 'DATETIME',
            'orderby'     => 'meta_value',
            'order'       => 'ASC',
            'posts_per_page' => (3 - $e1count),
            'fields' => 'ids',
            'tax_query' => array(
                array(
                    'taxonomy' => 'ctc_event_category',
                    'field'    => 'slug',
                    'terms'    => 'featured',
                    'operator' => 'NOT IN',
                ),
            ),
          );

          $events2 = new WP_Query( $events2_args );
          $ev2 = $events2->posts;
        }

        $event_ids = array_merge( $ev1, $ev2);
        $events = new WP_Query(array(
            'post_type' => 'ctc_event',
            'post__in'  => $event_ids,
            'meta_query' => array(
                array(
                  'key' => '_ctc_event_end_date',
                  'value' => date_i18n( 'Y-m-d' ),
                  'compare' => '>=',
                  'type' => 'DATE'
                ),
              ),
              'meta_key'      => '_ctc_event_start_date_start_time',
              'meta_type'     => 'DATETIME',
              'orderby'     => 'meta_value',
              'order'       => 'ASC',
        ));

        if ($events->have_posts()) :
          while ( $events->have_posts() ) : $events->the_post();
            // HTML here
          endwhile;
        endif;