creating search engine

Anon

Hi, how to create search engine with PHP ? Any technique to share with me please ??

Anon

I am using php4 with MySQL and i want display my search result as page wise
which consist of specific nomber of records . How can i do this think?

thanks
subhranil Basu

Anon

Well,

It´s complex to explain here, but, you may create a simple search engine starting like it:

table sites (
id_site serial,
category char(30),
subcategory char(30),
title char(100),
url char(100),
description text,
wordkeys char(200));

So you may search this table on the fiels title, url, description and wordkeys using sql structures like 'like %word%'.

Anon

What kind of search engine?

Anon

I'd like a search engine that would search a table for keywords and then display the results on the page in order of relevance. (how closely it matches to the keywords). How do I do this?

Anon

First, you must count all records returned from your query (e.g:SELECT COUNT(*)FROM your_tables WHERE your_criteria), and then you do your actual query using keyword LIMIT (SELECT field FROM your_tables WHERE your_criteria LIMIT start_point, end_point). Further information about LIMIT, just read the manual, and you'll understand what i mean.

Anon

Dear Lola,
it appeared to be that we have the same problem here. I would like to ask a favor from u that is if u already got the answer to this problem would u be kind enough to mail to me....your help is much appreciated as i am due to past my assignment in two days time.
thank u very much.

                                    wati

Anon

Dear Habibi,

I am interesting to know the matter mentioned in the subject.

Tuhin

Anon

I have the same question. I need to know how to create a search engine. Any kind is fine with me.

Anon

You can use the get_meta_tags function (see manual) to grab the meta tags, description and keywords, etc, and if you can just get a script to run through all your pages, get those tags and then put them in the db and the query off of those tables, you can get the meta tags. Unfortunately, I think I keep running in to the problem of an infinite loop when I am running through my pages....any suggestions?

Thanks.