Have been unable to get this working on my site. Can you please give a working example. I have followed the instructions above with no success 🙁

This is my search.php code

<?php get_header(); ?>

<img src="/wp-content/themes/brightonss/images/internal_header.jpg" alt="" />

<div id="content">

<?php if ( have_posts() ) : ?>

<h1 class="page-title"><?php printf( __( 'Search Results for: %s', 'Brighton Secondary School' ), '<span>' . get_search_query() . '</span>' ); ?></h1>

<?php

/* Run the loop for the search to output the results.

* If you want to overload this in a child theme then include a file

* called loop-search.php and that will be used instead.

*/

get_template_part( 'loop', 'search' );

?>

<?php else : ?>

<div id="post-0" class="post no-results not-found">

<h2 class="entry-title"><?php _e( 'Nothing Found', 'Brighton Secondary School' ); ?></h2>

<div class="entry-content">

<p><?php _e( 'Sorry, but nothing matched your search criteria. Please try again with some different keywords.', 'Brighton Secondary School' ); ?></p>

<?php get_search_form(); ?>

</div><!-- .entry-content -->

</div><!-- #post-0 -->

<?php endif; ?>

</div><!--#content -->

</div><!--#contentwrap -->

<?php get_footer(); ?>

what must be changed?

Argh. I’m a different poster from the above, but I can’t get this to work either. Here’s mine. I’ve tried swapping $s for the_search_query but I can’t get anything to appear.

<?php

global $options;

foreach ($options as $value) {

if (get_settings( $value ) === FALSE) { $$value = $value; } else { $$value = get_settings( $value ); }

}

$dateformat = get_option(‘date_format’);

$timeformat = get_option(‘time_format’);

get_header();

if(get_query_var(‘author_name’)) :

$curauth = get_userdatabylogin(get_query_var(‘author_name’));

else :

$curauth = get_userdata(get_query_var(‘author’));

endif;

?>

<div id=”content”>

<div class=”wrap”>

<div class=”sep sepinside”> </div>

<div class=”column column-narrow”> </div><!– end .column-narrow –>

<div class=”column column-double column-content column-last”>

<?php $post = $posts[0]; // Hack. Set $post so that the_date() works. ?>

<h1>Search Results for: <?php the_search_query(); ?></h1>

</div><!– end .column-double –>

<div class=”clear”> </div>

<div class=”column column-narrow”>

<?php if ( !function_exists(‘dynamic_sidebar’) || !dynamic_sidebar(‘Sidebar: Archive Pages’) ) : ?> <?php endif; ?>

</div><!– end .column-narrow –>

<div class=”column column-double column-last”>

<div class=”posts”>

<?php

/* Patched 3/2012 from Events Made Easy docs at http://www.e-dynamics.be/bbpress/topic.php?id=197 to include EME events in search */

$table = $wpdb->prefix.”dbem_events”;

$s = mysql_real_escape_string($_REQUEST); // The search key words

$found_event = false;

$query = “SELECT * FROM $table WHERE (event_name LIKE ‘%”.$s.”%’) OR

(event_notes LIKE ‘%”.$s.”%’) ORDER BY event_start_date”;

$events = $wpdb->get_results ( $query, ARRAY_A );

foreach ($events as $row) {

print “<h2>“.$row.” “.$row.”</h2>”;

print substr($row,0,250).”[…]”;

print “<div style=’clear:both;’></div>”;

$found_event = true;

}

/* END OF EME PATCH */

?>

<?php

wp_reset_query();

$i = 0;

if (have_posts()) : while (have_posts()) : the_post();

$i++;

update_post_caches($posts);

?>

<div class=”post”>

<?php

unset($img);

if ( current_theme_supports( ‘post-thumbnails’ ) && has_post_thumbnail() ) {

$attachedFile = wp_get_attachment_image_src( get_post_thumbnail_id($post->ID), ” );

$img = $attachedFile[0];

}

else{

if ($proud_cf_use == ‘Yes’)

{

$img = get_post_meta($post->ID, $proud_cf_photo, true);

} // if CF used

else

{

if (!$img)

{

$img = catch_that_image($post->ID);

}

} // if CF not used

}

if ($img)

{

?>

<div class=”thumb”>” rel=”bookmark” title=”Permanent Link to <?php the_title(); ?>”><img src=”<?php bloginfo(‘template_directory’); ?>/scripts/timthumb.php?h=80&w=120&zc=1&src=<?php echo $img ?>” alt=”<?php the_title(); ?>” class=”bordered” /></div>

<?php

}

?>

<h2>” rel=”bookmark” title=”Permanent Link to <?php the_title_attribute(); ?>”><?php the_title(); ?></h2>

<p class=”postmetadata”><?php the_time(“$dateformat $timeformat”); ?> / #commentspost” title=”Jump to the comments” rel=”nofollow”><?php comments_number(‘no comments’,’1 comment’,’% comments’); ?><?php edit_post_link( __(‘EDIT’), ‘ / ‘, ”); ?></p>

<div class=”info”><?php the_excerpt(); ?></div>

<div class=”clear”> </div>

</div><!– end .post –>

<?php endwhile;

else:

?>

<h2>Sorry, there are no posts in this category.</h2>

<?php

endif; ?>

<div class=”navigation”>

<p><span class=”older”><?php next_posts_link(‘< older entries’) ?></span> <span class=”latest”><?php previous_posts_link(‘newer entries >’) ?></span></p>

</div>

</div><!– end .posts –>

</div><!– end .column-content –>

<div class=”clear”> </div>

</div><!– end .wrap –>

</div><!– end #content –>

<?php get_footer(); ?>

Bingo. Thanks, Franky!

Smaller bug — there’s a JPG image in the body of my test event, and the search result summary tries to show it, but returns a broken image icon instead.

The event is a six word sentence, with an image below it. It’s a regular image in one of my WordPress upload directories, but the broken image URL is this:

http://mysite.example.org/wp-content/uploads/2012/03/Beginning-of-Image-Name[...]%3Cdiv%20style='clear:both;'%3E%3C/div%3E%20%20%20%20%20%20%20%20%20%20%3Ch2%3ESorry,%20there%20are%20no%20posts%20in%20this%20category.%3C/h2%3E%20%20%20%20%20%20%20%20%20%20%20%20%20%20%3Cdiv%20class=

As a workaround I was able to change the length of your line to “print substr($row,0,100” but of course that won’t work if the image appears before any text does.

I would probably rather have it suppress the image anyway, but a broken image icon is bad form… Any advice?

More importantly, it seems that unless I specify a /a tag AFTER your routine, currently at the beginning of my “Searching Posts” div, then there’s a hanging href reference going on (which explains the above — it’s pulling more from the next result). I’ve also added separators to distinguish between the Events search and the Pages/Posts search, as follows:

<?php

/* Patched 3/2012 from Events Made Easy docs at http://www.e-dynamics.be/bbpress/topic.php?id=197 to include EME events in search */



print "<div class='sep'> </div><h1>Searching Events...</h1><br>";



$table = $wpdb->prefix."eme_events";

$s = mysql_real_escape_string($_REQUEST['s']); // The search key words

$found_event = false;



$query = "SELECT * FROM $table WHERE (event_name LIKE '%".$s."%') OR

(event_notes LIKE '%".$s."%') ORDER BY event_start_date";

$events = $wpdb->get_results ( $query, ARRAY_A );

foreach ($events as $row) {

print "<h2>".$row['event_name']." ".$row['event_start_date']."</h2>";

print substr($row['event_notes'],0,100)."...<br><br>";

print "<div style='clear:both;'></div>";

$found_event = true;

}

?>



<div class="post">

<?php

print "</a><div class='sep'> </div><h1>Searching Posts and Pages...</h1>";

/* END OF EME PATCH */

?>

</div>

Obviously I’d like to get rid of the /a kludge — but I don’t really know PHP! Is this a bug in your routine?

Cool, that works. Thank you Franky! (It turns out that the misbehavior was keeping additional event results from appearing too.)

I also cleaned up my code a little and made the Event returns format more like my Posts and Pages returns. If anyone needs it, here’s my current working code:

<?php

/* Patched 3/2012 from Events Made Easy docs at http://www.e-dynamics.be/bbpress/topic.php?id=197 to include EME events in search */

print "<div class='post'><div class='sep'> </div><h1>Searching Events...</h1></div>";

$table = $wpdb->prefix."eme_events";

$s = mysql_real_escape_string($_REQUEST['s']); // The search key words

$found_event = false;

$query = "SELECT * FROM $table WHERE (event_name LIKE '%".$s."%') OR

(event_notes LIKE '%".$s."%') ORDER BY event_start_date";

$events = $wpdb->get_results ( $query, ARRAY_A );

foreach ($events as $row) {

print "<div class='post'><h2><a href='".eme_event_url($row)."'>".$row['event_name']."</a> ".$row['event_start_date']."</h2>";

print substr(eme_strip_tags($row['event_notes']),0,250)."...</div>";

print "<div style='clear:both;'></div>";

$found_event = true;

}

print "<div class='post'><div class='sep'> </div><h1>Searching Posts and Pages...</h1></div>";

/* END OF EME PATCH */

?>

Hello

I’m having trouble with implementing any of the suggested code for including search events in search results.

Any time I add any of the suggested code to the search.php file (I’m using the code posted by Franky above on July 25, 2011 at 13:50), I get the following errors displayed when I test in the search field on the website:

Parse error: syntax error, unexpected T_STRING in /home/culturen/public_html/wp-content/themes/duena/search.php on line 1

I wonder is it perhaps a clash with my theme’s PHP (I’m using Duena – https://wordpress.org/themes/duena), or is this code outdated (I noticed the last post on this topic was over two years ago)?

Any thoughts would be appreciated

Cheers
Jamie

Error returned is:
Parse error: syntax error, unexpected T_VARIABLE in /home/culturen/public_html/wp-content/themes/duena/search.php on line 9

My search.php file is the below code:

<?php

/**

 * The template for displaying Search Results pages.

 *

 * @package duena

 */

get_header(); ?>

<?php

$table = $wpdb->prefix."eme_events";

$s = mysql_real_escape_string($_REQUEST['s']); // The search key words

$found_event = false;

$query = "SELECT * FROM $table WHERE (event_name LIKE '%".$s."%') OR

(event_notes LIKE '%".$s."%') ORDER BY event_start_date";

$events = $wpdb->get_results ( $query, ARRAY_A );

foreach ($events as $row) {

print "<h2><a href='".eme_event_url($row)."'>".$row['event_name']."</a> ".$row['event_start_date']."</h2>";

print substr($row['event_notes'],0,250)."[...]";

print "<div style='clear:both;'></div>";

$found_event = true;

}

?>

	<div id="primary" class="col-md-8 <?php echo esc_attr( of_get_option('blog_sidebar_pos') ) ?>">

		<div id="content" class="site-content" role="main">

		<?php if ( have_posts() ) : ?>

			<header class="page-header">

				<h1 class="page-title"><?php printf( __( 'Search Results for: %s', 'duena' ), '<span>' . get_search_query() . '</span>' ); ?></h1>

			</header><!-- .page-header -->

			<?php /* Start the Loop */ ?>

			<?php while (have_posts()) : the_post(); 			

				// The following determines what the post format is and shows the correct file accordingly

				$format = get_post_format();

				get_template_part( 'post-formats/'.$format );					

				if($format == '')

				get_template_part( 'post-formats/standard' );					

			endwhile; ?>

		<?php else : ?>

			<?php get_template_part( 'no', 'results' ); ?>

		<?php endif; ?>

		<?php get_template_part('post-formats/post-nav'); ?>

		</div><!-- #content -->

	</div><!-- #primary -->

<?php get_sidebar(); ?>

<?php get_footer(); ?>

Hi Franky

Yes, I had edited it a bit between posts – hence the different error messages.

Regardless, it now works. You were correct (as always), I had my editor set in a way that was messing up the windows and linux line endings.

Thanks again for all your help

Jamie

I just wanted to ask how to filter events that it only shows future ones, but I figured it out in the meantime. After all, there is an SQL query m( 😀

This does the triock for me, so I want to share that:
$query = “SELECT * FROM $table WHERE (event_start_date >= CURDATE()) AND ((event_name LIKE ‘%”.$s.”%’) OR (event_notes LIKE ‘%”.$s.”%’)) ORDER BY event_start_date”;

After integrating this in the used theme it becomes clear, why there isn’t a generic approach in EME to include events in search results. If that were possible, it would be marvellous! But I don’t see that comin – too many different approches in different themes. Thanks for all the code examples from you and aothers and your comments!

Best regards
Floutsch