addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcredit-cardcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1launch-new-window--smalllight-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Re: [php-49] MySQL FULLTEXT Search Question

From: Tim P.
Sent on: Tuesday, May 1, 2012 4:01 PM
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]


People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy