keyword.php

<?php 
include('../../includes/config.php');

if(isset($_POST['keyword']))
{
    $keyword = $_POST['keyword'];

$select = "SELECT * FROM iv_events WHERE '$keyword' IN (iv_events_temple_username,iv_events_event_title,iv_events_category,
    iv_events_event_head,iv_events_name_numbers,
    iv_events_address,iv_events_seat_permit,iv_events_seat_available,iv_events_fees_mem,iv_events_book_last,iv_events_start_date,iv_events_end_date,
    iv_events_mimi_sponsor,iv_events_full_sponsor)";
   
    $sql = mysqli_query($conn,$select);

$count = mysqli_num_rows($sql);

if($count==0) echo "<tr><td colspan='6' class='alert alert-danger w-100 text-center'>No Results Found</td></tr>";

else

{
        $i = 1;
		while($row = mysqli_fetch_assoc($sql))

{

?>
                    <tr>
                            <td><?php echo $i; ?></td>
                            <td><?php echo $row['iv_events_event_title']; ?></td>
                           <td>
                            <a class="elem w-100 border-0" style="background:transparent;"
            				href="assets/images/events/<?php echo $row['iv_events_photo'];?>"
            				title="<?php echo $row['iv_events_photo'];?>"
            				data-lcl-thumb="assets/images/events/<?php echo $row['iv_events_photo'];?>">
                            <img src="assets/images/events/<?php echo $row['iv_events_photo'];?>" width="100px" height="100px"/>
                            </a>
                            </td>
                            <td><?php echo $row['iv_events_event_head']; ?></td>
                            <td><?php echo $row['iv_events_name_numbers']; ?></td>
                            <td><?php echo $row['iv_events_start_date']; ?></td>
                            <td><a href="detailed_event.php?e_id=<?php echo $row['iv_events_id'] ?>"
                                class='text-primary'>View <i class='fa fa-eye'></i></a></td>
                        </tr>
        <?php

$i++;

}
    }

}

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/ajax/event_search

	.	41
	..	4096
X	date.php	1934
X	keyword.php	2057