Jump to content

No keywords are highlights in PHP, Why ?

Recommended Posts

No keywords are highlight. for what reason behind that. please help me 

Here is my HTML code and at the bottom PHP.


<form id="nbc-searchblue1" method="post" enctype="multipart/form-data" autocomplete="off">
    <input type="text" id="wc-searchblueinput1" class="nbc-searchblue1" value="<?php echo $search; ?>" placeholder="Search Iconic..." name="search" type="search" autofocus>
    <input id='nbc-searchbluesubmit1' value="Search" type="submit" name="button">


    // We need to use sessions, so you should always start sessions using the below code.
    // If the user is not logged in redirect to the login page...
    if (!isset($_SESSION['loggedin']))
        header('Location: ../index.php');
    include 'connect.php';
    $search = $sql = '';
    if (isset($_POST['button'])){
        $numRows = 0;
        if (!empty($_POST['search'])){
            $search  = mysqli_real_escape_string($conn, $_POST['search']);
            $sql     = "select * from iconic19 where student_id like '%{$search}%'  || name_bangla like '%{$search}%' || name like '%{$search}%' || phone like '%{$search}%' || blood like '%{$search}%' || district like '%{$search}%'";
            $result  = $conn->query($sql);
            $numRows = (int) mysqli_num_rows($result);
        if ($numRows > 0)
            echo "<table>
            <th><b>Photo</th> <th><b>Student ID</th>  <th style='font-weight: 700;'><b>নাম</th>   <th><b>Name</th>  <th><b>Mobile No.</th>  <th><b>Blood Group</th>  <th><b>Email</th>  <th style=' font-weight: 700;'><b>ঠিকানা</th></tr></thead>";
            while ($row = $result->fetch_assoc()){
            $student_id = !empty($search)?highlightWords($row['student_id'], $search):$row['student_id'];
            $name = !empty($search)?highlightWords($row['name'], $search):$row['name'];
            $district = !empty($search)?highlightWords($row['district'], $search):$row['district'];
                echo "<tbody>";
                echo "<tr>";
                echo "<td>" . "<div class='avatar'><a class='fb_id'  target='_blank' href='https://www.facebook.com/" . $row['fb_id'] . "'><img  src='" . $row['photo'] . "'><img class='img-top' src='fb.png'></a>" . "</td>";
                echo "<td data-label='Student ID'>" . $row['student_id'] . "</td>";
                echo "<td data-label='নাম' style=' font-weight: 700;'>" . $row['name_bangla'] . "</td>";
                echo "<td data-label='Name' style='font-weight:bold;' >" . $row['name'] . "</td>";
                echo "<td data-label='Mobile No'>" . "<a href='tel:" . $row['phone'] . "'>" . $row['phone'] . "</a>" . "</td>";
                echo "<td data-label='Blood' style='color:red; font-weight:bold;' >" . $row['blood'] . "</td>";
                echo "<td data-label='Email'>" . "<a href='mailto:" . $row['email'] . "'>" . $row['email'] . "</a>" . "</td>";
                echo "<td data-label='ঠিকানা' style='font-weight: 700;'>" . $row['address_bangla'] . "</td>";
                echo "</tr>";
                echo "</tbody>";
            echo "<div class='error-text' style='font-weight: 700;'>No Result</div><br /><br />";
$result = $conn->query("SELECT * FROM iconic19 $sql ORDER BY id DESC");
function highlightWords($text, $word){
    $text = preg_replace('#'. preg_quote($word) .'#i', '<span style="background-color: #F9F902;">\\0</span>', $text);
    return $text;





Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...