Filtering Records To Be Displayed With PHP Include

Hi,

The category field is a multi select check box, records can have and in all cases do have multiple categories.

Thanks!

Hi Kent, 

Thanks for clarifying, this solution should make the records load:

// load records from 'all_classes'
list($all_classesRecords, $all_classesMetaData) = getRecords(array(
 'tableName'   => 'all_classes',
 'perPage'     => '10',
 'loadUploads' => true,
 'allowSearch' => false,
 'where'       => "`categories` LIKE '\t". mysql_escape($category) ."\t'",
));

So multi select list options are stored in a tab separated string, for example: 

    3   6   4   2   9    

The code above searches and returns records where the $category value between two tab characters is found.

Let me know if you have any questions. 

Cheers,

Greg

Hey Greg,

Well, I'm still not getting any records to load on the page and there's no error.

Sorry for all the trouble.

My current code is below -

On the page:

<?php
  $category = "nikka-nadia"; // name of category to load
  include("includes/nikka-nadia-classes.php");
?>

On the include:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */
  
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/web/sites/greywood/yogamerge.com/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  // load records from 'all_classes'
list($all_classesRecords, $all_classesMetaData) = getRecords(array(
 'tableName'   => 'all_classes',
 'perPage'     => '10',
 'loadUploads' => true,
 'allowSearch' => false,
 'where'       => "`categories` LIKE '\t". mysql_escape($category) ."\t'",
));

?>

also on the include:

<?php foreach ($all_classesRecords as $record): ?>

I wanted to mention that I uses includes on a variety of pages for navigation menus, etc. and I have always had to use a full url path to the include file if the page was buried within a variety of folders, yogamerge.com/classpages/nikkanadia/restorative-flow-test.php

However, that didn't help in this instance.

Hi Kent, 

I think the issue might be that nikka-nadia isn't a valid option. Would it be possible to post an image of how you've got the list field set up? I've attached an example screenshot of what I'm looking for. 

Then I can see what options you have the drop down field.

Cheers,

Greg

Hi Grey,

Sure, I attached a screen shot of that area of the admin.

Thanks much.

Kent

Hey Kent,

Looking at the screenshot, it seems the first letter of each word is capitalized in the CMS, I guess this is the case for Nikka-Nadia as well? Perhaps the code needs to be:

<?php
  $category = "Nikka-Nadia"; // name of category to load
  include("includes/nikka-nadia-classes.php");
?>

This is because MySQL LIKE is case sensitive. 

Cheers,

Greg

Hey Greg,

Yeah, I thought of that last night and tried it, but it still didn't load any records.

Looks like I have stumbled across a frustrating issue, lol

Sorry for all the trouble, what do you suggest next?

Hi,

Can you send in a Support Request with CMS Builder and FTP details so we can take a closer look:
https://www.interactivetools.com/support/email_support_form.php?priority=free

Thanks!