如何在php mysql搜索中加粗关键字？

Question

I want want my output like this when I search a keyword like

"programming"

php programming language

How to do this in php mysql?

Any idea?

Answer 1

Just perform a str_replace on the returned text.

$search = 'programming';
// $dbContent = the response from the database

$dbContent = str_replace( $search , '<b>'.$search.'</b>' , $dbContent );

echo $dbContent;

Any instance of "programming", even if as part of a larger word, will be wrapped in <b> tags.

For instances where more than one word are used

$search = 'programming something another';
// $dbContent = the response from the database

$search = explode( ' ' , $search );
function wrapTag($inVal){
  return '<b>'.$inVal.'</b>';
}
$replace = array_map( 'wrapTag' , $search );

$dbContent = str_replace( $search , $replace , $dbContent );

echo $dbContent;

This will split the $search into an array at the spaces, and then wrap each match in the <b> tags.

You could use <b> or <strong> tags (See What's the difference between <b> and <strong>, <i> and <em>? for a dicussion about them).