Searching

Ogden2k · 06-14-2005, 11:03 PM

Is creating a search script difficult? I would want to use MySQL fulltext search if possible.

Would I have to create a table of keywords ?

I have 1 DB, and 3 tables that have an auto increment ID that is the primary key.

CreativeLogic · 06-14-2005, 11:19 PM

Would you be searching all columns or would you be searching just one column.

What version MySQL do you have too?

Ogden2k · 06-14-2005, 11:21 PM

I would probably search just the title. I have the latest version of MySQL and PHP.

AlEast · 06-15-2005, 12:00 AM

fulltext search in version 4.0 is very good. Take a look at the mysql docs and you can take a look at how to use the built in fulltext search provided.

CreativeLogic · 06-15-2005, 01:24 AM

Well in that case you would just use MySQL's search function and you're all set as AlEast stated before! :)

jaswinder_rana · 06-15-2005, 01:47 AM

Here are some links for you, same thing you want
http://www.zend.com/zend/tut/tutorial-ferrara1.php
http://www.phpfreaks.com/tutorials/129/0.php

hope this helps

Ogden2k · 06-26-2005, 08:19 PM

Ok, I've got the search working, but I do not care about the fulltext scoring being displayed. Here's the code:

PHP Code:


			
 <?php  if(!$c) {  ?> 
 <form action="index.php?c=1" method="post"> 
  <input type="text" length="50" name="any" />&nbsp;
  <input type="submit" value="Search" /> 
 </form> 
 <? 
 } else if($c) { 
 MySQL_connect("localhost", "", ""); 
 MySQL_select_db("ogden2k_iedb"); 
  if((!$all) || ($all == "")) { $all = ""; } else { $all = "+(".$all.")"; } 
  if((!$any) || ($any == "")) { $any = ""; }   
 $query = " 
  SELECT *,
  MATCH(title, keyword) AGAINST ('$all $any' IN BOOLEAN MODE) AS score  
          FROM movies  
        WHERE MATCH(title, keyword) AGAINST ('$all $any' IN BOOLEAN MODE)"; 
 $artm1 = MySQL_query($query); 
 if(!$artm1) {  
         echo MySQL_error()."<br />$query<br />";  
        } 
 echo "<strong>Matches:</strong><br />"; 
        if(MySQL_num_rows($artm1) > 0) { 
         echo "<table>"; 
         echo "<tr><td>Score </td><td>Title </td></tr>"; 
            while($artm2 = MySQL_fetch_array($artm1)) { 
           $val = round($artm2['score'], 3); 
           $val = $val*100; 
           echo "<tr><td>$val</td>"; 
           echo "<td>{$artm2['title']}</td>"; 
         } 
         echo "</table>"; 
  } 
 else {  
 echo "<em>No Results were found in this category.</em><br />";  
 } 
 echo "<br />";  
 }
 ?>

jaswinder_rana · 06-27-2005, 10:10 PM

I haven't looked at the code, coz security wise its not good. you are using global variables, which are a NO NO. DONT USE GLOBALS.

if you have to access c then you should be doing ($_GET['c']).

if its your server, then TURN OFF the globals, and if its not your, then advise your host to do so.
its BAD.

EVEN php.net suggests not to use if you can.
try this link
http://www.google.com/search?hs=WjL&...hp&btnG=Search