Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

my sql text search

i am using mysql and php and i am doing search in a field which is of type text. i would like a part of sentence to be displayed with the search string highlighted.  
example:

i search for ->    bob

text field has --> this is test. this is test. my name is bob. this is test. this is test.

result --> my name is bob, with bob highlighted
0
nandananushil1
Asked:
nandananushil1
1 Solution
 
BardobraveCommented:
Make a select that return you a record if the text contains search string or null if it doesn't contain it.

Once you have the record you'll need to strip it, use split to convert the string into an array of phrases separated by ".". Now loop through that array seeking in every element if the search string is present, when you find an element of the array with the search string present exit the loop and return to your page the string contained on that array's element with <strong></strong> inserted before and after the search string.
0
 
JermTheWormCommented:
Since you don't explain how you are 'doing search' or how you are doing your displaying, I'm going to assume that you are doing an echo of a retuned value from a php mysql query that uses a 'like %$srchvar%'.

Assuming:
  echo $result;
would print your result normally you can do:
   echo str_replace($srchvar,'<em>'.$srchvar.'</em>',$result);
replace the '<em>' and '</em'> with whatever html tags you want to use to highlight the searched for term.

HTH
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now