Search

[rashmi_k28]

Hi,

 

How to add the search a word from my website. Not the google's search.

Please provide me the idea or any links how to implement this technique.

 

[waynew]

$string = mysql_real_escape_string($string);
mysql_query("SELECT * FROM tablename WHERE columname LIKE '%$string%'") or die(mysql_error());

 

Hope that helps.

[rashmi_k28]

Hey I word is not stored in the database.

It is like a search button which is in most of the websites.

When characters are entered in the search text box, it displays the pages which contains that word within the web site

[JonnoTheDev]

How can it possibly know the pages if the page text is not stored anywhere?

[dennismonsewicz]

you could use an indexing script like this one:

 

http://www.sphider.eu/index.php

 

You need a DB tbl setup to run the actual program but it indexes your site instead of using a DB for the search to work

[JonnoTheDev]

Lucene can do this. Part of the Zend Framework.

Requires no db, uses file storage. Will need to implement methods of updating the index.