- substr: documentation ( source)
- strpos: documentation ( source)
- str_replace: documentation ( source)
- explode: documentation ( source)
<?php
$the_mysql_result = array();
$the_mysql_result[0]['id'] = "1";
$the_mysql_result[0]['address']="www.example.com/page1";
$the_mysql_result[0]['title']="Page 1";
$the_mysql_result[0]['content']="The quick dog jumps over the lazy dog.";
$the_mysql_result[0]['image']="image_1.jpg";
$the_mysql_result[1]['id'] = "2";
$the_mysql_result[1]['address']="www.example.com/page2";
$the_mysql_result[1]['title']="Page 2";
$the_mysql_result[1]['content']="The best thing about morning is breakfast.";
$the_mysql_result[1]['image']="image_2.jpg";
$the_mysql_result[2]['id'] = "3";
$the_mysql_result[2]['address']="www.example.com/page3";
$the_mysql_result[2]['title']="Page 3";
$the_mysql_result[2]['content']="Hotdogs are great ballpark food.";
$the_mysql_result[2]['image']="image_3.jpg";
$query="dog";
foreach($the_mysql_result as $results)
{
$content = $results['content'];
$row_occurences = explode($query,$content);
foreach($row_occurences as $an_occurence)
{
$content=$an_occurence.$query;
echo '<li class="media">
<a class="pull-left" href="'.$results['address'].'">
<img class="media-object thumbnail" src="'.$results['image'].'" style="height:100px !important">
</a>
<div class="media-body">
<h4 class="media-heading"><a href="'.$results['address'].'">'.$results['title'].'</a></h4>
<p>...'.str_replace($query,'<strong>'.$query.'</strong>', substr($content,strpos($content,$query)-25,160)).'...</p>
</div>
</li>';
}
}