Den här sökfunktionen funkar helt korrekt förutom att replace funktionen som ska highlighta sökordet i resultatet inte fungerar, här är koden... hoppas någon kan hjällpa mig:
<?php
include("includes/db.php");
// Print on the page
$get = mysql_query("SELECT * FROM news WHERE news.writer LIKE '%$searchword%' OR news.topic LIKE '%$searchword%' OR news.date LIKE '%$searchword%' OR news.news LIKE '%$searchword%' AND checked = '1' ORDER BY news.date DESC", $open) or die (mysql_error());
function colorit ( $get, $searchword )
{
$get = preg_replace ( "/(.*?)(" . $searchword . ")(.*?)/is", "\\1<span class=search>\\2</span>\\3", $get );
return $get;
}
$rowCount = mysql_numrows($get);
if ($rowCount == 0)
{
echo("Nothing matched your search.");
echo("<br><br>");
}
else
{
echo("You searched for <b>$searchword</b>, and this is your result:<br><br>");
while ($userRow = mysql_fetch_array($get))
{
echo("<span class=topic><b>".$userRow['topic']."</b></span> by ".$userRow['writer']."<br>");
echo("<img src=gfx/dots.gif><br>");
// Replace enter with <br>
$break = $userRow['news']."";
$break = nl2br($break);
echo("$break<br>");
echo("<img src=gfx/dots.gif><br>");
echo("<span class=date>".$userRow['date']." | ".$userRow['time']."</span><br><br><br>");
}
echo("<a href=news.php><span class=topic><b>< New search</b></span></a>");
}
// Close database connection
mysql_close($open);
?>
Tack på förhand.