jnunemaker / wordpress_live_search_plugin

live search plugin for wordpress that just works (with prototype)

This URL has Read+Write access

wordpress_live_search_plugin / addicted_live_search / search_results.php
100755 32 lines (28 sloc) 0.86 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

<?php 
require('../../../wp-blog-header.php'); 
 
if (isset($_GET['s']) && trim($_GET['s']) != '') {
  
  $term = mysql_real_escape_string(trim($_GET['s']));
  $sql = "SELECT 
            * 
          FROM 
            wp_posts wp 
          WHERE 
            wp.post_type = 'post' AND 
            wp.post_status = 'publish' AND 
            wp.post_date <= '" . date('Y-m-d H:i:s', time()) . "' AND
            ((wp.post_title LIKE '%${term}%') OR (wp.post_content LIKE '%${term}%')) 
          ORDER BY 
            wp.post_date DESC 
          LIMIT 10";
  $posts = $wpdb->get_results($sql);
  
  if (count($posts) > 0) {
    echo '<ul>';
    foreach($posts as $post) {
      echo '<li><a href="' . get_permalink($post->ID) . '">' . the_title('', '', false) . '</a></li>';
    }
    echo '</ul>';
  } else {
    echo '<p>No results found.</p>';
  }
  
}
?>