Girls Who Geek Forums

coding, designing, scripting, rocking.

1. 

   beckiparsons
   Member

   anyone know how to add a search bar?

   Posted 7 months ago #
2. 

   Vera
   Member

   http://www.google.com/cse/ ?

   Adding the search bar per se is not the difficult thing: that's just a simple form with an input field and a button. It's actually doing the search.

   You can use a google search bar, or tell us more what you want from this search function (example of searches and what is should find), so we can help guide you writing your own.

   Lianko[dot]com

   Posted 7 months ago #
3. 

   beckiparsons
   Member

   well...it's for my husband's blog. He needs a basic keyword search that will turn up results of posts that include a specific word or phrase. Does that make sense?

   Thanks,
   Becki

   Posted 7 months ago #
4. 

   Vera
   Member

   Well the HTML part is pretty simple:
   

   <form method="GET" action="search.php">
      <input type="text" name="searchQuery" />
      <input type="submit" value="Search!" />
   </form>

   As for search.php:
   

   if(count($_GET)>0 && isset($_GET['searchQuery'])){
     //sanitize user submitted data (VERY IMPORTANT!)
     $srcQuery = strip_html(addslashes(trim($_GET['searchQuery'])));
   
     $sql = "SELECT * FROM <code>php_blog</code>
             WHERE title LIKE '%".$srcQuery."%' OR entry LIKE '%".$srcQuery."%'";
   
     //connect to the DB
     mysql_connect ('localhost', 'db_username', 'db_password') ;
     mysql_select_db ('db_name');
   
     $result = mysql_query($sql) or
               print ("Can't select entries from table php_blog.<br />" . $sql . "<br />" . mysql_error());
   
     mysql_close(); 
   
     $resultCount = mysql_num_rows($result);
   
     if($resultCount > 0){
       //parse list of results
       while($row = mysql_fetch_array($result)) {
          //display entry and format it nicely
       }
     } else {
        //didn't find anything
     }
   
   } else {
     //stuff to do if search query is missing
   }

   The article http://girlswhogeek.com/tutorials/2004/part-3-display-entries shows you how to display the list of entries formatted in a nice manner.

   Lianko[dot]com

   Posted 7 months ago #
5. 

   beckiparsons
   Member

   Sorry this took so long...but it's not working. Keeps telling me that I have a syntax error on the line that says,

   $resultCount = mysql_num_rows($result);

   Not sure why...any ideas?

   Posted 6 months ago #
6. 

   beckiparsons
   Member

   nevermind...I figured it out...nothing was being echoed.

   Thanks

   Posted 6 months ago #

RSS feed for this topic

Reply

You must log in to post.