highlighting search results in php/mysql

Posted by fusion on Stack Overflow See other posts from Stack Overflow or by fusion
Published on 2010-04-29T15:22:25Z Indexed on 2010/04/29 15:27 UTC
Read the original article Hit count: 356

Filed under:
|
|
|

how do i highlight search results from mysql query using php?

this is my code:

$search_result = "";

$search_result = $_GET["q"];

$result = mysql_query('SELECT cQuotes, vAuthor, cArabic, vReference FROM thquotes WHERE cQuotes LIKE "%' . $search_result .'%" ORDER BY idQuotes DESC', $conn)
  or die ('Error: '.mysql_error());


function h($s) {
    echo htmlspecialchars($s, ENT_QUOTES);
} 


?>

<div class="center_div">
<table>
<caption>Search Results</caption>
    <?php while ($row= mysql_fetch_array($result)) { ?>
        <tr>
            <td style="text-align:right; font-size:15px;"><?php h($row['cArabic']) ?></td>
            <td style="font-size:16px;"><?php h($row['cQuotes']) ?></td>
            <td style="font-size:12px;"><?php h($row['vAuthor']) ?></td>
            <td style="font-size:12px; font-style:italic; text-align:right;"><?php h($row['vReference']) ?></td>
        </tr>
    <?php } ?>
</table>
</div>

© Stack Overflow or respective owner

Related posts about highlighting

Related posts about php