Home » Topics » Pods 1.x » Display Pod Objects with a Specific Pick Field

Display Pod Objects with a Specific Pick Field

This topic is: not resolved

This topic contains 2 replies, has 2 voices, and was last updated by Duane Cilliers 2 years, 2 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts

February 27, 2011 at 7:41 am #165276

Duane Cilliers

Member

Hey everyone.

I have two pods. One for Trainers and one for Classes. There are several trainers in the trainers pod and several classes in the Classes pod.

I have created a "multi-select pick" column for Trainers that is related to classes. So when adding a new trainer you can select which classes they teach.

What I need to do is filter and display all trainers that teach say for example "puppy classes".

Does anyone know how to go about doing this?

February 27, 2011 at 8:34 am #165277

Kamil Grzegorczyk (Owi)

Participant

Post count: 14

here You are

$class_name = &quot;puppy classes&quot;;
$trainers = new Pod('trainers');
//set order
$orderby = 't.name ASC';

//add where condition - IF YOUR PICK FIELD IS CALLED CLASS
$where = 'class.name =' $class_name;

$trainers->findRecords($orderby, $limit = -1, $where);
while($trainer = $trainers->fetchRecord())
{
//access each trainer in here
}

$class_name = "puppy classes";

$trainers = new Pod('trainers');

//set order

$orderby = 't.name ASC';

//add where condition - IF YOUR PICK FIELD IS CALLED CLASS

$where = 'class.name =' $class_name;

$trainers->findRecords($orderby, $limit = -1, $where);

while($trainer = $trainers->fetchRecord())

{

//access each trainer in here

}

February 27, 2011 at 9:13 am #165278

Duane Cilliers

Member

Okay, the comment came out horribly…

So I’m going to post it as an answer…

Thanks for the speedy reply. I’m sorry, but I’m a complete Pods noob, so I don’t quite understand how this code fits in.

Here’s an example: On the general classes page (called "what we offer") I have a sidebar listing all the trainers. Here is the code…

<?php
      $trainer = new Pod('trainer');
      $trainer->findRecords('name ASC');
      $total_trainers = $trainer->getTotalRows();
    ?>

    <?php if( $total_trainers>0 ) : ?>
      <?php while ( $trainer->fetchRecord() ) : ?>

        <?php
          // set our variables
          $trainer_id              = $trainer->get_field('id');
          $trainer_name            = $trainer->get_field('name');
          $trainer_photo           = $trainer->get_field('photo');
          $trainer_slug                = $trainer->get_field('slug');

          // data cleanup
          $trainer_photo               = $trainer_photo[0]['guid'];        
        ?>

        <div class=&quot;trainer-sidebar&quot; id=&quot;trainer<?php echo $trainer_id; ?>&quot;>
          <a href=&quot;<?php echo get_permalink(); ?><?php echo $trainer_slug; ?>/&quot;>
            <h3><?php echo $trainer_name; ?></h3>
          </a>
          <?php if( !empty( $trainer_photo ) ) : ?>
          <a href=&quot;<?php echo get_permalink(); ?><?php echo $trainer_slug; ?>/&quot;>
            <img src=&quot;<?php echo $trainer_photo; ?>&quot; alt=&quot;Photo of <?php echo $trainer_name; ?>&quot; />
          </a>

          <?php endif ?>
        </div>
        <!-- /.trainer-sidebar -->

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

<?php

$trainer = new Pod('trainer');

$trainer->findRecords('name ASC');

$total_trainers = $trainer->getTotalRows();

<?php if( $total_trainers>0 ) : ?>

<?php while ( $trainer->fetchRecord() ) : ?>

<?php

// set our variables

$trainer_id = $trainer->get_field('id');

$trainer_name = $trainer->get_field('name');

$trainer_photo = $trainer->get_field('photo');

$trainer_slug = $trainer->get_field('slug');

// data cleanup

$trainer_photo = $trainer_photo[0]['guid'];

</a>

<?php if( !empty( $trainer_photo ) ) : ?>

<img src="<?php echo $trainer_photo; ?>" alt="Photo of <?php echo $trainer_name; ?>" />

</a>

<?php endif ?>

</div>

<?php endwhile ?>

<?php endif ?>

When someone selects a class, they are taken to a single class page. The single class page sidebar uses conditional tags to determine which class is being viewed.

So if for instance, if Puppy Classes is being viewed I would like all the trainers that teach Puppy Classes listed in the sidebar. As mentioned before I use multi-select PICK relationship to relate classes to trainers.

Thanks again.

Author

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.