88guy Posted June 8, 2007 Share Posted June 8, 2007 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 More sharing options...
fenway Posted June 8, 2007 Share Posted June 8, 2007 full-text indexing is annoying to implement, but there are 3-rd party soluions. Link to comment https://forums.phpfreaks.com/topic/54759-mysql-full-text-search-script/#findComment-271068 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.