Re: [php-49] MySQL FULLTEXT Search Question
| From: | Jd D. |
| Sent on: | Tuesday, May 1, 2012, 4:06 PM |
Hey HEY H E Y....
I don't drive no stankin Pinto....
--
On Tue, May 1, 2012 at 4:02 PM, Tim Piele <[address removed]> wrote:
Any bodies?
On Tue, May 1, 2012 at 1:43 PM, Tim Piele <[address removed]> wrote:--Maybe a herpa derp... but:
Say I have a Where clause like below for doing FULLTEXT searching: (it's in CodeIgniter syntax)
$this->db->where('MATCH (engines.engine, makes.make, models.model) AGAINST ('+first_word +second_word +third_word' IN BOOLEAN MODE');
The words the user searched for are passed in as a variable named $search_term
$search term may be several words like "2002 BMW 540i" or "JD Daniels drives a 1979 Ford Pinto" or just one word like "Honda"...
so how do I split that (explode?) and get them into the
first-word, second_word, third-word spots etc. knowing there could be any number of words?
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Tim Piele ([address removed]) from The Seattle PHP Meetup Group.
To learn more about Tim Piele, visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages
Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]
--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Tim Piele ([address removed]) from The Seattle PHP Meetup Group.
To learn more about Tim Piele, visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages
Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]
Jd Daniel
SS DEV | BKWLD
1932 1st Ave Suite 803, Seattle, WA 98101
[address removed] | www.bkwld.com
T. [masked]
C. [masked]
SS DEV | BKWLD
1932 1st Ave Suite 803, Seattle, WA 98101
[address removed] | www.bkwld.com
T. [masked]
C. [masked]
People in this
group are also in:
-
Content Strategy Seattle
5,096 content wonks
-
Google Developer Group (GDG) Seattle
6,890 Geeks
-
Seattle JS
7,942 JavaScripters
-
Seattle Spark+AI Meetup
3,882 Spark Enthusiasts
-
Women Who Code Seattle
5,805 Coders
-
Seattle Outdoor Adventurers (SOA)
27,179 Outdoor Adventurers