search.php

   1 <?php
   2
   3 require('includes/header.php');
   4 update_activity('search');
   5 $page_title = 'Search';
   6 $onload_javascript = 'focusId(\'phrase\'); init();';
   7
   8 if( ! empty($_POST['phrase']))
   9 {
  10         if($_POST['deep_search'])
  11         {
  12                 $redirect_to = DOMAIN . 'deep_search/' . urlencode($_POST['phrase']);
  13         }
  14         else
  15         {
  16                 $redirect_to = DOMAIN . 'quick_search/' . urlencode($_POST['phrase']);
  17         }
  18
  19         header('Location: ' . $redirect_to);
  20         exit;
  21 }
  22
  23 ?>
  24
  25 <p>The "quick" option searches only topic headlines, while the "deep" option searches both headlines and bodies.</p>
  26
  27 <form action="" method="post">
  28         <div class="row">
  29                 <input id="phrase" name="phrase" type="text" size="80" maxlength="255" value="<?php echo htmlspecialchars($_GET['q']) ?>" class="inline" />
  30                 <input type="submit" value="Quick" class="inline" />
  31                 <input type="submit" value="Deep" name="deep_search" class="inline" />
  32         </div>
  33 </form>
  34
  35 <?php
  36
  37 if( ! empty($_GET['q']))
  38 {
  39         $search_query = addcslashes( trim($_GET['q']), '%_' );
  40         $common_words = array('the', 'and', 'are', 'that', 'for', 'with', 'lol', 'what', 'where', 'when', 'why');
  41
  42         if(strlen($search_query) < 3)
  43         {
  44                 add_error('Your query must be at least 3 characters.');
  45         }
  46         else if(in_array($search_query, $common_words))
  47         {
  48                 add_error('Your search query is too common a word.');
  49         }
  50         if($_SERVER['REQUEST_TIME'] - $_SESSION['last_search'] < 5)
  51         {
  52                 add_error('Wait at least 5 seconds between searches.');
  53         }
  54
  55         if( ! $erred)
  56         {
  57                 $_SESSION['last_search'] = $_SERVER['REQUEST_TIME'];
  58
  59                 $search_query = '%' . $search_query . '%';
  60                 if($_GET['deep_search'])
  61                 {
  62                         $search_topics = $link->prepare('SELECT id, time, replies, visits, headline FROM topics WHERE headline LIKE ? OR body LIKE ? ORDER BY id DESC LIMIT 50');
  63                         $search_topics->bind_param('ss', $search_query, $search_query);
  64                 }
  65                 else
  66                 {
  67                         $search_topics = $link->prepare('SELECT id, time, replies, visits, headline FROM topics WHERE headline LIKE ? ORDER BY id DESC LIMIT 50');
  68                         $search_topics->bind_param('s', $search_query);
  69                 }
  70                 $search_topics->execute();
  71                 $search_topics->store_result();
  72
  73                 if($search_topics->num_rows > 0)
  74                 {
  75                         echo '<h4 class="section">Topics</h3>';
  76
  77                         $search_topics->bind_result($topic_id, $topic_time, $topic_replies, $topic_visits, $topic_headline);
  78
  79                         $topics = new table();
  80                         $columns = array(
  81                                 'Headline',
  82                                 'Replies',
  83                                 'Visits',
  84                                 'Age ▼'
  85                         );
  86                         $topics->define_columns($columns, 'Headline');
  87                         $topics->add_td_class('Headline', 'topic_headline');
  88
  89                         while($search_topics->fetch())
  90                         {
  91                                 $values = array
  92                                 (
  93                                         '<a href="/topic/' . $topic_id . '">' . str_ireplace( $_GET['q'], '<em class="marked">' . htmlspecialchars($_GET['q']) . '</em>', htmlspecialchars($topic_headline) ) . '</a>',
  94                                         replies($topic_id, $topic_replies),
  95                                         format_number($topic_visits),
  96                                         '<span class="help" title="' . format_date($topic_time) . '">' . calculate_age($topic_time) . '</span>'
  97                                 );
  98
  99                                 $topics->row($values);
 100                         }
 101                         $num_topics_fetched = $topics->num_rows_fetched;
 102                         echo $topics->output('', true);
 103
 104                         if($num_topics_fetched == 50)
 105                         {
 106                                 echo '<p class="unimportant">(Tons of results found; stopping here.)</p>';
 107                         }
 108                 }
 109                 else
 110                 {
 111                         echo '<p>(No matching topic headlines';
 112                         if($_GET['deep_search'])
 113                         {
 114                                 echo ' or bodies';
 115                         }
 116                         echo '.)</p>';
 117                 }
 118                 $search_topics->close();
 119
 120                 if($_GET['deep_search'])
 121                 {
 122                         $search_replies = $link->prepare('SELECT replies.id, replies.parent_id, replies.time, replies.body, topics.headline, topics.time FROM replies INNER JOIN topics ON replies.parent_id = topics.id WHERE replies.body LIKE ? ORDER BY id DESC LIMIT 50');
 123                         $search_replies->bind_param('s', $search_query);
 124                         $search_replies->execute();
 125                         $search_replies->store_result();
 126
 127                         if($search_replies->num_rows > 0)
 128                         {
 129                                 $search_replies->bind_result($reply_id, $parent_id, $reply_time, $reply_body, $topic_headline, $topic_time);
 130
 131                                 $replies = new table();
 132                                 $columns = array
 133                                 (
 134                                         'Reply snippet',
 135                                         'Topic',
 136                                         'Age ▼'
 137                                 );
 138                                 $replies->define_columns($columns, 'Topic');
 139                                 $replies->add_td_class('Topic', 'topic_headline');
 140                                 $replies->add_td_class('Reply snippet', 'reply_body_snippet');
 141
 142                                 while($search_replies->fetch())
 143                                 {
 144                                         $values = array
 145                                         (
 146                                                 '<a href="/topic/' . $parent_id . '#reply_' . $reply_id . '">' . str_ireplace( $_GET['q'], '<em class="marked">' . htmlspecialchars($_GET['q']) .  '</em>', snippet($reply_body) ) .'</a>',
 147                                                 '<a href="/topic/' . $parent_id . '">' . htmlspecialchars($topic_headline) . '</a> <span class="help unimportant" title="' . format_date($topic_time) . '">(' . calculate_age($topic_time) . ' old)</span>',
 148                                                 '<span class="help" title="' . format_date($reply_time) . '">' . calculate_age($reply_time) . '</span>'
 149                                         );
 150
 151                                         $replies->row($values);
 152                                 }
 153                                 $num_replies_fetched = $replies->num_rows_fetched;
 154                                 echo $replies->output('', true);
 155
 156
 157                                 if($num_replies_fetched == 50)
 158                                 {
 159                                         echo '<p class="unimportant">(Tons of results found; stopping here.)</p>';
 160                                 }
 161                         }
 162                         else
 163                         {
 164                                 echo '<p>(No matching replies.)</p>';
 165                         }
 166                         $search_replies->close();
 167                 }
 168         }
 169 }
 170
 171 print_errors();
 172
 173 require('includes/footer.php');
 174
 175 ?>