Database Articles

  Home arrow Database Articles arrow Page 28 - Creating a Search Application
DATABASE ARTICLES

Creating a Search Application
By: Matt Wade
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 3 stars3 stars3 stars3 stars3 stars / 16
    2003-07-15

    Table of Contents:
  • Creating a Search Application
  • Database Usage
  • Creating a Search Application
  • Searching
  • Conclusion

  •  
     

    SEARCH CODEWALKERS

    TOOLS YOU CAN USE

    advertisement

    Creating a Search Application -


    (Page 28 of 29 )

    Now, we can create a script called search.php and actually do some searching. In this script, we will display a text box to allow for search terms to be entered. When the form is submitted, we will first do an exact keyword match. If that does not yield any results, we will perform a fuzzy search.

    <?php
    &lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
       "http://www.w3.org/TR/html4/strict.dtd"
    &gt;
    &
    lt;html&gt;
    &
    lt;head&gt;
    &
    lt;title&gt;Search&lt;/title&gt;
    &
    lt;/head&gt;
    &
    lt;body&gt;
    &
    lt;h1&gt;Search&lt;/h1&gt;
    &
    lt;p&gt;Enter keywords to search for:&lt;/p&gt;
    &
    lt;form method=POST action="&lt;?= $_SERVER['PHP_SELF'] ?&gt;"&gt;
    &
    lt;p&gt;&lt;input type="text" name="search_term" size="20"&gt;
    &
    lt;input type="submit" name="submit" value="Submit"&gt;&lt;/p&gt;
    &
    lt;/form&gt;
    &
    lt;?php

    require('searchclass.php');

    if (isset (
    $_POST['submit'])) {
        
    $search = new Search($_POST['search_term']);
        
    $results $search-&gt;doSearch();
        if(
    $results) {
            echo 
    "&lt;p&gt;&lt;b&gt;Your search results:&lt;/b&gt;&lt;/p&gt;\n";
            echo 
    "&lt;p&gt;";
            foreach(
    $results as $row) {
                echo 
    "&lt;a href=\"{$row['url']}\"&gt;"
                     
    "{$row['url']}&lt;/a&gt;&lt;br /&gt;\n";
            }
            echo 
    "&lt;/p&gt;\n";
        } else {
            
    $results $search-&gt;doFuzzy();
            echo 
    "&lt;p&gt;&lt;b&gt;No matches! ";
            if(
    $results) {
                echo 
    "These pages contain similar words "
                     
    "to what you searched for:&lt;/b&gt;&lt;/p&gt;\n";
                echo 
    "&lt;p&gt;&lt;i&gt;(Similar terms are in parentheses)&lt;/i&gt;&lt;/p&gt;\n";
                echo 
    "&lt;p&gt;";
                foreach(
    $results as $row) {
                    echo 
    "&lt;a href=\"{$row['url']}\"&gt;{$row['url']}"
                         
    "&lt;/a&gt;&amp;nbsp;({$row['keyword']})&lt;br /&gt;\n";
                }
                echo 
    "&lt;/p&gt;\n";
            } else {
                echo 
    "No similar words either.&lt;/b&gt;&lt;/p&gt;\n";
            }
        }
    }
    ?&
    gt;
    &
    lt;/body&gt;
    &
    lt;/html&gt;
    ?>

    More Database Articles Articles
    More By Matt Wade

    blog comments powered by Disqus

    DATABASE ARTICLES ARTICLES

    - Completing a Book Inventory Management System
    - Uploading Images for a Book Inventory Manage...
    - Finishing the Add Book Story for a Book Inve...
    - Integration Testing for a Book Inventory Man...
    - User Stories for a Book Inventory Management...
    - Unit Testing a Book Inventory Management Sys...
    - Testing a Book Inventory Management System
    - Implementing Models for a Book Inventory Man...
    - Book Inventory Application: Publishers and B...
    - Handling Publishers in a Book Inventory Mana...
    - Publisher Administration for Book Inventory ...
    - Book Inventory Management
    - Using the SQL Reference Manual
    - Using Oracle SQL Developer with SQL Statemen...
    - Fixing Errors with Oracle SQL Developer


    © 2003-2012 by Developer Shed. All rights reserved. DS Cluster 3 - Follow our Sitemap