Search Engine - Codewalkers

Codewalkers Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

January 21st, 2003, 08:55 PM

liaaam

Join Date: Apr 2007

Posts: 9

Time spent in forums: < 1 sec
Reputation Power: 0

Search Engine

I am in need of building a search engine for a intranet. I would have worked it out myself given more time, unfortunatly I have limited time < 7 days so if anyone could point me in the right direction it would be appreicated. Searching would be performed on client data (ie: Name, Email, Phone, Address, Last contact, etc)

Thanks
liaaam

January 22nd, 2003, 01:20 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Search Engine

search the database with the using the LIKE clause:

select * from database where name LIKE '%something%'

or you could use MySQL's fulltext searching if you are using MySQL...

January 23rd, 2003, 08:20 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: Search Engine

I used this select query to search within the table that contains ULRs (fields: url, title, keywords, description, name_category).

Example of query if search word is 'hobby'

Select
IF(POSITION('hobby' IN CONCAT_WS('',url,title,keywords,description, name_category)),1,0), id, name_category as cat, url, title, description, id_category
from urls
WHERE CONCAT_WS('',url,title,keywords,description, name_category) LIKE '%hobby%' ORDER BY 1 desc, cat desc,title

This select I create dinamycally regarding amount of search words.
I tried this select on table with 30 000 records, and it works fast.

January 27th, 2003, 04:01 PM

jonathen

Join Date: Apr 2007

Location: Essex, UK

Posts: 44

Time spent in forums: < 1 sec
Reputation Power: 2

RE: Search Engine

I use the following script - obviously you will need to change the fields to reflect your own, but it works well:

php Code:

Original - php Code

 
<?php 
 if ($search)   // perform search only if a string was entered. 
   { 
    mysql_connect("localhost","user","pass") or die ("Problem connecting to Database"); 
    mysql_select_db("mydb") or die( "Unable to select database");
    $srch="%".$search."%"; 
       $query = "SELECT * from mytable WHERE name LIKE '$srch' || address  LIKE '$srch' || link LIKE '$srch' || website LIKE '$srch' || email  LIKE '$srch' ORDER by name DESC"; 
 
    $result = mysql_db_query("mydb", $query) 
or print ">>> MySQL-Error: ".mysql_errno()." -> ".mysql_error()."<br>n";
 
    if(mysql_num_rows($result) <= 0){
        echo "Sorry - no matches were found. Please <a href="search.php">go back</a> and try some different search terms.";
 
} else {
    
    echo "Search Results:"; 
 
        while ($r = mysql_fetch_array($result)) {     // Begin while 
   $company = $r["name"];  
   $address = $r["address"];   
   $link = $r["link"];   
   $website = $r["website"];  
   $email = $r["email"];     
echo "<table width="65%" border="1" cellspacing="0" cellpadding="3" bordercolor="#ABABAB">";
echo "<tr>";
echo "<td">";
echo "$name<br>";
echo "$address<br>";
echo "$link<br>";
echo "$website<br>";
echo "$email<br>";
echo "</td>";
echo "</tr>";
echo "<br>";
        }                  // end while 
echo "</table>"; 
echo "<br>";
} 
   } else { 
   echo "You did not enter anything to search for. Please <a href="search.php">go back</a> and enter a search word.
 
?>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: