[PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Ron Piggott
I wanted to also ask about how you would build a web site search engine with
php and mySQL.

I had thought of setting up a table with a few columns ---

one for the URL of the specific page (This could become a link when a match
is found for that page)
second with the page title --- used in displaying the search results
third with the plain text from the page --- for searching purposes

and then having one line of the table per web page on the site

Then setting up a PHP form that would search the text from the page and make
some type of matching results page for each entry that found the words the
user typed in.

Any other thoughts?  There is no compression this way,. but maybe there
doesn't need to be.  I don't know how to automate populating a table, but I
could use the cut / paste feature.

Any other thoughts?  I know how to do the above and the PHP commands to
use --- I wanted to ask before I got started for any tips instead of
re-starting.

Ron

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Peter Ellis
Well, this is from the why reinvent the wheel department -- have you
looked at htdig://?

http://www.htdig.org/

Might save you some work.  Just a thought :)  More constructive replies
regarding actual code are forthcoming, I'm sure.
-- 
Peter Ellis - [EMAIL PROTECTED]
Web Design and Development Consultant
naturalaxis | http://www.naturalaxis.com/

On Tue, 2004-09-07 at 21:10 -0400, Ron Piggott wrote:
 I wanted to also ask about how you would build a web site search engine with
 php and mySQL.
 
 I had thought of setting up a table with a few columns ---
 
 one for the URL of the specific page (This could become a link when a match
 is found for that page)
 second with the page title --- used in displaying the search results
 third with the plain text from the page --- for searching purposes
 
 and then having one line of the table per web page on the site
 
 Then setting up a PHP form that would search the text from the page and make
 some type of matching results page for each entry that found the words the
 user typed in.
 
 Any other thoughts?  There is no compression this way,. but maybe there
 doesn't need to be.  I don't know how to automate populating a table, but I
 could use the cut / paste feature.
 
 Any other thoughts?  I know how to do the above and the PHP commands to
 use --- I wanted to ask before I got started for any tips instead of
 re-starting.
 
 Ron

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread zareef ahmed
Hi,

http://www.zend.com/php5/casestudies/php5-orase.php

You may have some lead.

zareef ahmed



--- Ron Piggott [EMAIL PROTECTED] wrote:

 I wanted to also ask about how you would build a web
 site search engine with
 php and mySQL.
 
 I had thought of setting up a table with a few
 columns ---
 
 one for the URL of the specific page (This could
 become a link when a match
 is found for that page)
 second with the page title --- used in displaying
 the search results
 third with the plain text from the page --- for
 searching purposes
 
 and then having one line of the table per web page
 on the site
 
 Then setting up a PHP form that would search the
 text from the page and make
 some type of matching results page for each entry
 that found the words the
 user typed in.
 
 Any other thoughts?  There is no compression this
 way,. but maybe there
 doesn't need to be.  I don't know how to automate
 populating a table, but I
 could use the cut / paste feature.
 
 Any other thoughts?  I know how to do the above and
 the PHP commands to
 use --- I wanted to ask before I got started for any
 tips instead of
 re-starting.
 
 Ron
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 


=
Homepage :: http://www.zasaifi.com



___
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php