search engine

[Rod]

Hi,

i am doing a ecommerce website and would like to implement a search engine
to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many relationship).
Actually, the search should also be in the "category" name of the product
which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like "the,
some..." and numbers etc etc.

Do you have an idea?
Do you know a script which allow me to do that on both windows and uniw
environement?

thanks you very much

rod

[Fernando André]

Rod wrote:

Hi,

i am doing a ecommerce website and would like to implement a search engine
to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many relationship).
Actually, the search should also be in the "category" name of the product
which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like "the,
some..." and numbers etc etc.

Do you have an idea? You should not be doing a e-commerce website.
But if you really whant to , try learning SQL first. Do you know a script which allow me to do that on both windows and uniw
environement?

thanks you very much

rod

[John Smith]

"Rod" <we****@hotmail.com> wrote in message
news:41*********************@news.club-internet.fr...

Hi,

i am doing a ecommerce website and would like to implement a search engine
to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many relationship). Actually, the search should also be in the "category" name of the product
which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like "the, some..." and numbers etc etc.

Do you have an idea?
Do you know a script which allow me to do that on both windows and uniw
environement?

thanks you very much

rod

You could use a FULLTEXT index, check the docs at http://mysql.org

-- John
http://www.i-rate.org

[Rod]

don't you have something more interresting to say?
I think I have some good knowledge in sql (even if i am not the best like
you).
But the solution to this problem is not only in SQL (i am using innodb table
so i can't use fulltext index!!).

So, anything else?

"Fernando André" <an***@netcrash.no-ip.com> a écrit dans le message de
news:41**********************@news.telepac.pt...

Rod wrote:

Hi,

i am doing a ecommerce website and would like to implement a search engine to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many relationship). Actually, the search should also be in the "category" name of the product which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like "the, some..." and numbers etc etc.

Do you have an idea?

You should not be doing a e-commerce website.
But if you really whant to , try learning SQL first.

Do you know a script which allow me to do that on both windows and uniw
environement?

thanks you very much

rod

[Rod]

Hi,

thanks you very much.

Actually, I know this functionnality but all my tables are InnoDB, and it
doesnot work with these tables.

do you have another solution?

"John Smith" <[e-mail]> a écrit dans le message de
news:ce**********@newshispeed.ch...

"Rod" <we****@hotmail.com> wrote in message
news:41*********************@news.club-internet.fr...

Hi,

i am doing a ecommerce website and would like to implement a search engine to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many

relationship).

Actually, the search should also be in the "category" name of the product which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like

"the,

some..." and numbers etc etc.

Do you have an idea?
Do you know a script which allow me to do that on both windows and uniw
environement?

thanks you very much

rod

You could use a FULLTEXT index, check the docs at http://mysql.org

-- John
http://www.i-rate.org

[Rod]

a last thing about fulltext.
Suppose you are searching for "foo".
Suppose this:
ID TITLE DESCRIPTION
1 hello foo
2 foo hello

the result will be:
1 hello foo
2 foo hello
because the have the same rating

but I would like
2 foo hello
1 hello foo

because it's more important to find the word in the title!!

I don't think you can customize that.
"John Smith" <[e-mail]> a écrit dans le message de
news:ce**********@newshispeed.ch...

"Rod" <we****@hotmail.com> wrote in message
news:41*********************@news.club-internet.fr...

Hi,

i am doing a ecommerce website and would like to implement a search engine to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many

relationship).

Actually, the search should also be in the "category" name of the product which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like

"the,

some..." and numbers etc etc.

Do you have an idea?
Do you know a script which allow me to do that on both windows and uniw
environement?

thanks you very much

rod

You could use a FULLTEXT index, check the docs at http://mysql.org

-- John
http://www.i-rate.org

[Pjotr Wedersteers]

Rod wrote:

Hi,

i am doing a ecommerce website and would like to implement a search
engine to find products.
All the serach engine I have found on the web are parsing html page!
This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which
contains more description about a specific product: 1 to many
relationship). Actually, the search should also be in the "category"
name of the product which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title
for product B, product B should be displayed first (because i think
title is more important than description). So it should rate each
result.

A last thing, it should use boolean expression, and ignore words like
"the, some..." and numbers etc etc.

Do you have an idea?
Do you know a script which allow me to do that on both windows and
uniw environement?

thanks you very much

rod

A product search in a db should not be the toughest challenge. Of course you
could write it yourself, using PHP and mysql queries, but I bet
http://www.scriptwiz.com/ has got some stuff you might like.

[Gary]

Scriptwiz.com is really helpful!
Gary, http://www.ratingportal.ch

[steve]

"Rod" wrote:

Hi,

i am doing a ecommerce website and would like to implement a search
engine
to find products.
All the serach engine I have found on the web are parsing html page! This is not what i want.
i want to search within my mysql database.
But using:
- several columns (title, description)
- several tables (the product table is linked with another table which contains more description about a specific product: 1 to many
relationship).
Actually, the search should also be in the "category" name of the
product
which is in another table

Also, i would like to sort the products like this:
- if the word is in the description for product A, and in the title
for
product B, product B should be displayed first (because i think title is
more important than description). So it should rate each result.

A last thing, it should use boolean expression, and ignore words like "the,
some..." and numbers etc etc.

Do you have an idea?
Do you know a script which allow me to do that on both windows and
uniw
environement?

thanks you very much

rod

Rod, true that outside type search engine parse html pages, BUT you
are presenting your database results in html pages anyways, for your
users to view. So all your data is available in html (or could be)
for search engines to spider.

Is it really worth your time and money to implement something vs.
getting one of a number of free search engines that would spider your
site, and the price is having their search engine button on your site.
Suggest all the fancy stuff are hard to do from user interface
standpoint, and 99% of people won’t use them (even most people using
google don’t use advanced functions, let alone learning stuff about a
new /small site).

Just trying to save your time.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-search-e...ict133715.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=457667