Need help creating a custom search WordPress

Lew Ayotte comments:

In functions.php:

//search by business name
//You may need to do a little more work here, if you want to include only certain categories, etc.
function get_business_name_posts( $search_term = '%' ) {
global $wpdb;

$search_term = preg_replace('/\s+/i', '%', trim(mysql_real_escape_string($search_term)));

$query = "SELECT DISTINCT p.ID " .
"FROM $wpdb->posts p " .
"WHERE post_status = 'publish' " .
"AND post_title LIKE '%" . $search_term . "%' " .
"ORDER BY post_title;";

$business_ids = $wpdb->get_results($query, OBJECT);

return $business_ids;
}

Then, I created a template called "Business Search" and set a Page to use it, but you can incorporate this code into your existing files...

<?php
/*
Template Name: Business Search
*/

get_header();

if ( isset($_GET['b']) ) {
$business_name = htmlspecialchars($_GET['b']);
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="<?php echo $business_name; ?>">
<input type="submit" name="submit" id="submit">
</form>

<?php
$businesses = get_business_name_posts( $business_name );

foreach ( $businesses as $business ) {
$post = get_post( $business->ID );

echo "<h3>" . $business->ID . $post->post_title . "</h3";
}
} else {
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="">
<input type="submit" name="submit" id="submit">
</form>

<?php
}

get_footer(); ?>

The working example is here: http://latest.phrugal.com/business-search/
I added a few "businesses" named Microsoft, MircoStuff, Fisher Price, AT&T

So if you search for "t" you'll get Microsoft, MicroStuff, and AT&T... if you search for "Microsoft" you'll get just Microsoft, etc.

I hope this helps...

Jill Chongva comments:

To ask it to only search category 17, where would I add that part? I only know enough php to be dangerous

Jill Chongva comments:

Here is the code for my page template:

<?php get_header(); ?>

<div id="content">

<div id="contentleft">

<div class="postarea">

<?php include(TEMPLATEPATH."/breadcrumb.php");?>

<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<h1><?php the_title(); ?></h1><br />

<?php the_content(__('Read more', 'studiopress'));?><div class="clear"></div><?php edit_post_link(__('(Edit)', 'studiopress'), '', ''); ?>
<?php endwhile; else: ?>

<p><?php _e('Sorry, no posts matched your criteria.', 'studiopress'); ?></p><?php endif; ?>

</div>

</div>

<?php include(TEMPLATEPATH."/sidebar.php");?>

</div>

<?php // The main column ends ?>

<?php get_footer(); ?>


To convert this to the search page, what needs to stay and what needs to go?

I took the code you gave me (thank you!) and made a business search page, but this is what happened [[LINK href="http://www.vipmagazine.com/search-spectacular-locations/?b=Celebrations&submit=Submit+Query"]][[/LINK]]

so I know I've mucked it up :)

j :)

Lew Ayotte comments:

Try changing the function to this (for category 17)

function get_business_name_posts( $search_term = '%' ) {
global $wpdb;

$search_term = preg_replace('/\s+/i', '%', trim(mysql_real_escape_string($search_term)));

$query = "SELECT DISTINCT p.ID " .
"FROM $wpdb->posts p " .
"LEFT JOIN $wpdb->term_taxonomy t on t.object_id = p.ID " .
"WHERE post_status = 'publish' " .
"AND post_title LIKE '%" . $search_term . "%' " .
"AND t.term_taxonomy_id = '17' " .
"ORDER BY post_title;";

$business_ids = $wpdb->get_results($query, OBJECT);

return $business_ids;
}

Your template (try this):

<?php
/*
Template Name: Business Search
*/

get_header(); ?>

<div id="content">

<div id="contentleft">

<div class="postarea">

<?php include(TEMPLATEPATH."/breadcrumb.php");

if ( isset($_GET['b']) ) {
$business_name = htmlspecialchars($_GET['b']);
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="<?php echo $business_name; ?>">
<input type="submit" name="submit" id="submit">
</form>

<?php
$businesses = get_business_name_posts( $business_name );

foreach ( $businesses as $business ) {
$post = get_post( $business->ID );

echo "<h1>" . $post->post_title . "</h1>";
}
} else {
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="">
<input type="submit" name="submit" id="submit">
</form>

<?php
}
?>

</div>

</div>

<?php include(TEMPLATEPATH."/sidebar.php");?>

</div>

<?php // The main column ends ?>

<?php get_footer(); ?>

Lew Ayotte comments:

Correction, the function should be:

function get_business_name_posts( $search_term = '%' ) {
global $wpdb;

$search_term = preg_replace('/\s+/i', '%', trim(mysql_real_escape_string($search_term)));

$query = "SELECT DISTINCT p.ID " .
"FROM $wpdb->posts p " .
"LEFT JOIN $wpdb->term_relationships t on t.object_id = p.ID " .
"WHERE p.post_status = 'publish' " .
"AND p.post_title LIKE '%" . $search_term . "%' " .
"AND t.term_taxonomy_id = '17' " .
"ORDER BY post_title;";

$business_ids = $wpdb->get_results($query, OBJECT);

return $business_ids;
}

Jill Chongva comments:

So close - it's searching only post titles, but it's only showing the post title for the returned info. Can it show the entire post instead?

[[LINK href="http://www.vipmagazine.com/search-spectacular-locations/"]][[/LINK]]

Lew Ayotte comments:

Try changing the foreach in the template file to this:


foreach ( $businesses as $business ) {
$post = get_post( $business->ID );
?>

<h1><?php echo $post->post_title; ?></h1><br />

<?php echo $post->post_content; ?>
<div class="clear"></div>
<?php edit_post_link(__('(Edit)', 'studiopress'), '', ''); ?>

<?php
}


Jill Chongva comments:

Can you post the whole template page code? I'm breaking it again :(

Lew Ayotte comments:

here you go :)

<?php
/*
Template Name: Business Search
*/

get_header();

if ( isset($_GET['b']) ) {
$business_name = htmlspecialchars($_GET['b']);
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="<?php echo $business_name; ?>">
<input type="submit" name="submit" id="submit">
</form>

<?php
$businesses = get_business_name_posts( $business_name );

foreach ( $businesses as $business ) {
$post = get_post( $business->ID );
?>

<h1><?php echo $post->post_title; ?></h1><br />

<?php echo $post->post_content; ?>
<div class="clear"></div>
<?php edit_post_link(__('(Edit)', 'studiopress'), '', ''); ?>

<?php
}
} else {
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="">
<input type="submit" name="submit" id="submit">
</form>

<?php
}

get_footer(); ?>

Lew Ayotte comments:

oh wait, i pasted the wrong one... :)

Lew Ayotte comments:

<?php get_header(); ?>

<div id="content">

<div id="contentleft">

<div class="postarea">

<?php include(TEMPLATEPATH."/breadcrumb.php");

if ( isset($_GET['b']) ) {
$business_name = htmlspecialchars($_GET['b']);
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="<?php echo $business_name; ?>">
<input type="submit" name="submit" id="submit">
</form>

<?php
$businesses = get_business_name_posts( $business_name );

foreach ( $businesses as $business ) {
$post = get_post( $business->ID );
?>

<h1><?php echo $post->post_title; ?></h1><br />

<?php echo $post->post_content; ?>
<div class="clear"></div>
<?php edit_post_link(__('(Edit)', 'studiopress'), '', ''); ?>

<?php
}
} else {
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="">
<input type="submit" name="submit" id="submit">
</form>

<?php
}
?>

</div>

</div>

<?php include(TEMPLATEPATH."/sidebar.php");?>

</div>

<?php // The main column ends ?>

<?php get_footer(); ?>

Jill Chongva comments:

Awesome - thank you! The results page is now not showing the Google map and the info below the map.

Where do I look to change that?

Lew Ayotte comments:

Try this:

<?php get_header(); ?>

<div id="content">

<div id="contentleft">

<div class="postarea">

<?php include(TEMPLATEPATH."/breadcrumb.php");

if ( isset($_GET['b']) ) {
$business_name = htmlspecialchars($_GET['b']);
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="<?php echo $business_name; ?>">
<input type="submit" name="submit" id="submit">
</form>

<?php
$businesses = get_business_name_posts( $business_name );

foreach ( $businesses as $business ) {
$post = get_post( $business->ID );
?>

<h1><?php echo $post->post_title; ?></h1><br />

<?php echo apply_filters('the_content', $post->post_content); ?>
<div class="clear"></div>
<?php edit_post_link(__('(Edit)', 'studiopress'), '', ''); ?>

<?php
}
} else {
?>

Search by Business Name:
<form action="<?php echo htmlspecialchars( $_SERVER['REDIRECTX_URL'] ); ?>" method="get">
<input type="text" name="b" id="b" value="">
<input type="submit" name="submit" id="submit">
</form>

<?php
}
?>

</div>

</div>

<?php include(TEMPLATEPATH."/sidebar.php");?>

</div>

<?php // The main column ends ?>

<?php get_footer(); ?>