Search labels

Hi Samsam,

What I would do is I will build a where clause for all the fields and related list fields because I don't think that using the allowSearch => true will include the searching of list fields from another table.

Here's an example:

  $where = '';
  if (@$_REQUEST['searchKeyword']){
    $where               .= 'title LIKE "%'.mysql_escape($_REQUEST['searchKeyword']).'%" OR content LIKE "%'.mysql_escape($_REQUEST['searchKeyword']).'%"';
    
    $loadGemTypeRecords   = mysql_select('gem_type', 'title LIKE "%'.mysql_escape($_REQUEST['searchKeyword']).'%"');
    $loadShapeCutRecords  = mysql_select('shape_cut', 'title LIKE "%'.mysql_escape($_REQUEST['searchKeyword']).'%"');
    
    if (@$loadGemTypeRecords){
      $gemTypeRecordNums = array_pluck($loadGemTypeRecords, 'num');
      $where .= ' OR gem_type IN ('.mysql_escapeCSV($gemTypeRecordNums).')';
    }
    
    if (@$loadShapeCutRecords){
      $shapeCutRecordNums = array_pluck($loadShapeCutRecords, 'num');
      $where .= ' OR shape_cut IN ('.mysql_escapeCSV($shapeCutRecordNums).')';
    }
    
    // load records from 'products'
    list($productsRecords , $productsMetaData) = getRecords(array(
      'tableName'   => 'products',
      'loadUploads' => false,
      'allowSearch' => false,
      'where'       => $where,
    ));
  }

Hope this helps!

Cheers!

Hi Daryl

Thanks so much for taking the time. We'll give a shot and let you know!

Hi samsam, 

The best way to do this is using a getRecords with a leftjoin variable. I've set up a demo of how you could implement the system below:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php

  // load viewer library
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/home/greg/www/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }


  if(@$_REQUEST['searchTerm']){
  

    $searchTerm = @$_REQUEST['searchTerm'];

    // load records from 'cars'
    list($carsRecords, $carsMetaData) = getRecords(array(
      'tableName'   => 'cars',
      'where'       => "brands.`title` LIKE '%$searchTerm%' OR cars.`title` LIKE '%$searchTerm%' OR cars.`content` LIKE '%$searchTerm%'" ,
      'loadUploads' => true,
      'allowSearch' => true,
      'leftJoin'    => array('brands' => 'brand'),
    ));

  }

?>
<form method="get" action="scratch.php">
<input type="text" name="searchTerm" value="<?php echo @$_REQUEST['searchTerm']; ?>" />
<input type="submit" name="go" value="Go!" />
</form>
<ul>
<?php if(@$carsRecords): ?>
  <?php foreach($carsRecords as $car): ?>
    <li><?php echo $car['title']; ?></li>
  <?php endforeach; ?>
<?php endif; ?>
</ul>

I set up my sections so that each car has a brand, which is linked via its num value to the brand section.

https://docs.google.com/a/interactivetools.com/file/d/0BwTyoYnBEdlANTA1dy1yRWRaNG8/edit?usp=drivesdk

Firstly I told the getRecords function that brand field was linked to the brands section by adding a leftJoin (highlighted in orange). The getRecords function will link on the num value stored in the brand field to the num value of the a brands section record. You can add as many left joins to the leftJoins array as you require. 

Then I added a where statement that will search the title field of the brand as well as the title field of the car, and its content field (highlighted in green). If you do a left join, you have to start each field in your where statement with the section that the item is stored in.

The results returned by the getRecords function are displayed at the bottom of the page in the $carsRecords for each loop.

Let me know if you have any questions about using this method.  

Thanks!

Greg

This is amazing, thanks Greg!