4. MySQL PHP Search Programming : SQL MATCH AGAINST Fulltext Search Syntax UNION Tutorial

Part 4 of MySQL PHP Search Programming Exercises for database driven web sites. Search pages that allow advanced targeting and filtering of information. Learn to build HTML Search Forms and Advanced Search Filters, Various MySQL Search Query Methods, Joined Table Queries Targeting Multiple Tables, Natural Language Full-Text Search Queries and discuss fine tuning your search programming and adjusting search parameters.

[megadolphin.v]

Very good tutorial. Concise, easy to follow. Didn't have to say "Get on with it" once in the whole series.

Thx Adam.

[TheDD]

Cool tutorial, Adam! Thank you. I didn't even know about MATCH AGAINST existed. MS Access' query grid is very helpful; a good habit is to always see the SQL it generates therein.

[kollyajax]

Thank you for this great revelation!!! God bless

[JmanJam]

You da man Adam I know your not going to respond because it didn't turn your wheels but anyway awesome tutorials!!!

[stanesaduwha]

Hey Adam, U are a great tutor. Keep it up bro and thanks a lot!

[WillWarHero]

cheers buddy! you have help me out much with your video tuts.
im going to give you a donation when my first pay check comes in ;)

[ammaso]

Good work.
could you do something about Click column headings to sort and reverse sort php
Tanks
keep the good jab you do

[peterm.souzajr.]

this works great, im curently working on how i can apply this to the WI2 series, so that my users can search in any field on any profile

[lenfarneth]

Awesome! There is a lot I will use from this. My main problem though is that NOWHERE ON YOU-TUBE does anyone show a successful way to link this or any output to a Is it so simple that I am missing something? I only have one table to search and link. Nothing I tried works. 18 hours in! ugh. Thumbs up btw.

[Jayisnotbae]

Hi Adam, I know you've done so many already but would it be possible to extend this to build a multi category search engine like you would have on an ecommerce site looking for a product? its all there, i know, i just don't quite know how to yet! cheers

[sqwale]

Is there any method i can use that will return a result set even though more than 50% have the query and is there also away to search for words shorter then 4 characters?

[TongueAndGroove]

Hi, I'm building a website I remember you mentioning in one of the videos in this series that MATCH AGAINST only works if you input at least 4 characters into the search bar. I'm wondering if there is a way to use MATCH AGAINST but still include words that are less than 4 characters. I want relevancy searches within my website but whenever I search for words with less than 4 characters, it doesn't give me any results. Any tips hints that might help me. If so, that would be awesome.

[nurainihidayahsulaiman]

hye..can i ask u something...if i want to do blibrary management system..
if the student want to search the book from the database...how is it?

[EvieMarieSingerGirl]

Hi Adam, thank you for this awesome video series!  So glad I found it.  Hope this question will get you to elaborate on this video so that your search results turn up ONLY what is searched...so if "dead bird" is searched..it will ONLY find items with both of those terms, not one or the other.  My shot at it works..but not consistently so has me scratching my head (column is full text indexed):  $sql = "SELECT field1 FROM table1 WHERE MATCH (field1) AGAINST ('+$kw0 +$kw1 +$kw2 +kw3 +kw4' IN BOOLEAN MODE) ";  >>> How about a video #5 in this series????

[humble]

i have created a db already with tables and when i connect to your tutorial it give me this erroe "The used table type doesn't support FULLTEXT indexes"

please can you kindly explain to me how to avoid this and use my already created tables?. thanks

[SagunManandhar]

Hi Adam,
How do I sort by date ? when I added ORDER BY `date_added` DESC, it's not working. Can not be order by relevence be changed ??

[MrHanzlo]

Adam, how do i transfer my search results and show them in another page.php., something like you have on | developphp | . You type in words and it redirects you to another page and shows you the results of the search. What am i missing :( . Please help .

[kalpesh]

Hello .... I am trying to make a search for a website like OLX and gumtree... Need to know logic behind building a quer for that .. lemme knw

[NikolayMollovSeeinvesting]

Can you tell me how to fix this problem

[knpp]

Cant get it working even if i got 100% search match. :(

0 results