Jump to content

MySql full-text search script


88guy

Recommended Posts

I recently created a database and table, using a tutorial, that allows for full text searching.  One field is called "content" and the other is called "URL".  I want to build a simple search page that will match words against each other and return URLs, in hyperlink form, so that visitors can find products (I run a small store).  I actually managed to write an online script that allows me to copy and paste content, along with the associated URL, into a form and it's shot directly into the database/table.  I'm an idiot with this stuff - that took me about 3 days (although it works famously).

 

The syntax for a command line search is something like:

 

select url from mytable where match(contents, url) against('Dell Optiplex');

 

I'm an old fart and it took me 5 days to get this far.....ARGH!

 

Obviously, I know that the top of the page has to contain directives for connecting to mysql and the database. 

 

If anyone could throw me a bone, here (for the rest of a script), I would be eternally grateful.

 

 

Thanks,

 

Guy Merritt

Link to comment
https://forums.phpfreaks.com/topic/54759-mysql-full-text-search-script/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.