<?php 
  // include shared code
  include '../lib/common.php';
  include '../lib/db.php';
  include '../lib/functions.php';
  
  // accept incoming search terms if the form has been submitted
  $words\; =\; array();\; if\; (isset($_GET['query']) && trim($\_GET[\text{'}query\text{'}]))\; \{$words = explode_items($\_GET[\text{'}query\text{'}],\; \text{'}\; \text{'},\; false);$// remove stop words from query
      query = sprintf('SELECT TERM_VALUE FROM \%sSEARCH_STOP_WORD',
          DB_TBL_PREFIX);
      $result\; =\; mysql\_query($query, $GLOBALS[\text{'}DB\text{'}]);$stop_words = array();
      while ($row\; =\; mysql\_fetch\_assoc($result))
      {
          $stop\_words[$row['TERM_VALUE']] = true;
      }
      mysql_free_result($result);$words_removed = array();
      foreach ($words\; as$index => $word)\; \{\; if\; (isset($stop_words[strtolower($word)]))\; \{$words_removed[] = $word;\; unset($words[$index]);\; \}\; \}\; \}$// generate HTML form
  ob_start();
  ?>
  <form method="get"
   action="<?php echo htmlspecialchars(_SERVER['PHP_SELF']); ?>">
   <div>
    <input type="text" name="query" id="query" value="<?php
     echo (count($words))\; ?\; htmlspecialchars(join(\text{'}\; \text{'},$words)) : '';?>"/>
    <input type="submit" value="Search"/>
   </div>
  </form>
  <?php
  
  // begin processing query
  if (count($words))\; \{$// spell check the query words
      spell_error = false;
      $suggest\_words\; =\; array();$ps = pspell_new('en');
      foreach ($words\; as$index => $word)\; \{\; if\; (!pspell\_check($ps, $word))\; \{\; if\; ($s = pspell_suggest($ps,$word))
              {
                  if (strtolower($s[0])\; !=\; strtolower($word))
                  {
                      // (ignore capitalization-related spelling errors)
                      $spell\_error\; =\; true;$suggest_words[$index]\; =$s[0];
                  }
              }
          }
      }
  
      // formulate the search query using provided terms and submit it
      $join\; =\; \text{'}\text{'};$where = '';
      $query\; =\; \text{'}SELECT\; DISTINCT\; D.DOCUMENT\_URL,\; D.DOCUMENT\_TITLE,\; \text{'}\; .\; \text{'}D.DESCRIPTION\; FROM\; WROX\_SEARCH\_DOCUMENT\; D\; \text{'};\; foreach\; ($words as $index\; =>$word)
      {
          $join\; .=\; sprintf(\; \text{'}JOIN\; WROX\_SEARCH\_INDEX\; I$\%d ON D.DOCUMENT_ID = I\%d.DOCUMENT_ID ' .
              'JOIN WROX_SEARCH_TERM T\%d ON I\%d.TERM_ID = T\%d.TERM_ID ',
              index, $index,$index, $index,$index);
      
          $where\; .=\; sprintf(\text{'}T$\%d.TERM_VALUE = "\%s" AND ', index, 
              mysql_real_escape_string(strtolower($word),$GLOBALS['DB']));
      }
      $query\; .=$join . 'WHERE ' . $where;$// trimmed 4 characters o remove trailing ' AND'
      query = substr($query,\; 0,\; strlen($query) - 4);
      $result\; =\; mysql\_query($query, $GLOBALS[\text{'}DB\text{'}]);$// display results
      echo '<hr/>';
      num_rows = mysql_num_rows($result);\; echo\; \text{'}$<p>Search for <b>' . htmlspecialchars(join(' ', words)) . 
          '</b> yielded ' . $num\_rows\; .\; \text{'}\; result\text{'}\; .\; (($num_rows != 1) ? 's' : '') . ':</p>';
  
      // show suggested query if a possible misspelling was found
      if ($spell\_error)\; \{\; foreach\; ($words as $index\; =>$word)
          {
              if (isset($suggest\_words[$index]))
              {
                  $words[$index] = $suggest\_words[$index]; 
              }
          }
          echo '<p>Possible misspelling.  Did you mean <a href="' . 
              htmlspecialchars($\_SERVER[\text{'}PHP\_SELF\text{'}])\; .\text{'}?query=\text{'}\; .\; urlencode(htmlspecialchars(join(\text{'}\; \text{'},$words))) . '">' . 
              htmlspecialchars(join(' ', $words))\; .\; \text{'}$</a>?</p>';
      }
  
      echo '<ul>';
      while (row = mysql_fetch_assoc($result))\; \{\; echo\; \text{'}$<li><b><a href="' . 
              htmlspecialchars(row['DOCUMENT_URL']) . '">' .
              htmlspecialchars($row[\text{'}DOCUMENT\_TITLE\text{'}])\; .\; \text{'}$</a></b>- ' . 
              htmlspecialchars(row['DESCRIPTION']) . '<br/><i>' .
              htmlspecialchars($row[\text{'}DOCUMENT\_URL\text{'}])\; .\; \text{'}$</i></li>';
      }
      echo '</ul>';
  }
  GLOBALS['TEMPLATE']['content'] = ob_get_clean(); 
  
  // display the page
  include '../templates/template-page.php';
  ?>