Showing a Search Result as a Single Record

The second “error” you’re getting isn’t actually an error at all, it’s just a warning because that code was really only meant as a proof-of-concept, it’s missing a way to handle the case where you have multiple results, or if there are no results (as you’re seeing). It will work, but it will complain.

If you want to avoid the warning, add a qualifier to the first statement so it will only execute if the correct type of value is present:

if (is_array($this->records)) {
  $id = key($this->records);
} else {
  $id = '';
}

The error on the first code is due to an open construct (such as a loop or set of brackets that was opened and not closed) somewhere in your code. I’m not seeing it, but that’s what that error means.

I closed the first error, it was missing an endif. But the search is not functional, something wrong with the code.
Moreover if I simply use the code from here https://xnau.com/showing-a-search-result-as-a-single-record/ and using the qualifier for the statement to suppress the warning, I still get the usual link to the record, and not the record itself.

Basically I have 2 concerns, one is that I want to implement this https://xnau.com/showing-a-search-result-as-a-single-record/
and secondly I want to hide the dropdown.

Please help.

OK, well, you need to copy the whole search/sort block from the pdb-list-detailed.php template in order for that to work. (that would be line 20 – 95) Then, replace the $this->column_selector() method (which produces the search field select dropdown) with a hidden field named “search_field” with the value set to the name of the field you want them to search on.

Thank you for replying.
That will solve the hiding of the dropdown.
But regarding the displaying single record, it still appears as a list rather than the record itself upon search. What am I missing?

Your help is appreciated, thank you.

If you are sure that your custom template is getting used, then I would probably need to see the entire template in order to answer why you’re still seeing the list.

Yes, the template is being used for sure, as it is able to hide the drop-down, this is the template code:

<?php
/*
 *
 * template for participants list single record output
 *
 */
if (is_array($this->records)) {
  $id = key($this->records);
} else {
  $id = '';
}
?>
<div class="wrap <?php echo $this->wrap_class ?>">
  <a name="<?php echo $this->list_anchor ?>" id="<?php echo $this->list_anchor ?>"></a>
  <?php
  if ( $filter_mode != 'none' && ! $filtering ) : ?>
  <div class="pdb-searchform">
    <div class="pdb-error pdb-search-error" style="display:none">
      <p class="search_field_error"><?php _e( 'Please select a column to search in.', 'participants-database' )?></p>
      <p class="value_error"><?php _e( 'Please type in something to search for.', 'participants-database' )?></p>
    </div>

    <?php
			$this->search_sort_form_top(); ?>

    <?php if ( $filter_mode == 'filter' || $filter_mode == 'both' ) : ?>

    <fieldset class="widefat">
      <legend><?php _e('Search', 'participants-database' )?>:</legend>
	<input type="hidden" name="search_field" value="client_name">

      <?php $this->search_form() ?>

    </fieldset>
    <?php endif ?>
    <?php if ( $filter_mode == 'sort' || $filter_mode == 'both' ) : ?>

    <fieldset class="widefat">
      <legend><?php _e('Sort by', 'participants-database' )?>:</legend>

      <?php
      $this->set_sortables(false, 'column');
      ?>

      <?php $this->sort_form() ?>

    </fieldset>
    <?php endif ?>
  </form>
  </div>
  <?php endif ?>

  <!-- showing record ID <?php echo $id ?> -->

  <div class="list-container" >
    <?php echo do_shortcode('[pdb_single id=' . $id . ']'); ?>
  </div>
</div>

Even if I use the few lines of code available on https://xnau.com/showing-a-search-result-as-a-single-record/ I still get to see the list, no idea why.

Thanks for your time.

Yeah, I don’t see why either. The template looks fine. When you load the page, you see the search form and then probably “Record not Found” which is being generated by the single shortcode. You see a list of records under that?

Perhaps another list shortcode in your content or in the WP page template?

Yes, when I load the page I see the message “Record not Found” being generated by the single shortcode. But when I enter the keyword and press on search, the “Record not Found” disappears and the list appears. So I think the search is generating it from somewhere?

There’s only one shortcode being used. Even if I use the few lines of code as provided on your website, I still get the same behaviour, so I suspect it is related to the search shortcode somehow?

This is my shortcode in WP: [pdb_list search=”true” template=”single” suppress=”true”]

Regards.

Edit: Further, after I enter keyword and press on search, I get the list of matching results, now if I click on the Reset button on search form, the keyword is cleared and all the records are visible, this thing overrides the filter=”id=0″ or suppress=”true”, so I think the best option would be to hide the Reset button, where is the code for search form where I can edit that out?

OK, figured it out. The problem with the list appearing is the AJAX search. You have to turn AJAX search off (settings under the advanced tab) because the AJAX isn’t set up to handle a special template like this. It’s an interesting problem for another day…

With regard to the list appearing after a “clear” this is a bug. No need to mess with the “clear” button, you can just fix the bug. I have it fixed in the 1.5.4.2 update, but if you’ve already updated, you’ll need to apply it manually.

Open classes/PDb_List.class.php an on line 358, you’ll find:

if (isset($_REQUEST['submit_button'])) $_GET['submit'] = $_REQUEST['submit_button'];

We change this to:

if (isset($_GET['submit_button'])) $_GET['submit'] = $_GET['submit_button'];
if (isset($_POST['submit_button'])) $_POST['submit'] = $_POST['submit_button'];

Now it should work as expected.

Regarding the clear button, even after updating the behavior was same, wasn’t it updated in the version 1.5.4.2? I updated today. But once I disabled AJAX, both the problems got solved.

Thank you so much!
That’s pretty much all!