studenteventheadtablepaid.php

<?php 
session_start();
if(!isset($_SESSION['user']))
{
	header("Location: index.php");
}
$login_id=$_SESSION['login_id'];
$full_name=$_SESSION['full_name'];
$branch=$_SESSION['branch'];
$year=$_SESSION['year'];
$mobile_no=$_SESSION['mobile_no'];
$authority=$_SESSION['authority'];
$event_auth=$_SESSION['event_auth'];

include 'header.php';
include 'validation.php';
include 'studentsidenavbar.php';  
?>
<div class="col-sm-9">
<div class="main" id="logindiv">
	<center>
    <h1><?php echo $event_auth; ?>  Participants</h1>
		<h3>List Of Paid Participating Students</h3><br />
        <div class="table-responsive">
		<table class="headtable">
        	<tr>
            <th>Sr No</th>
            <th>Name</th>
            <th>Branch</th>
            <th>Year</th>
            <th>Date</th>
            <th>Paid</th></tr>
            <?php
			include_once 'dbconnect.php';
			$sql_query=mysqli_query($bd,"SELECT * FROM $event_auth WHERE paid='yes'");
			if(mysqli_num_rows($sql_query)>0)
			{
				$i=1;
				while($row=mysqli_fetch_row($sql_query))
				{?>
            		<tr>
                    <td><?php echo $i; ?></td>
            		<td><?php echo $row[2]; ?></td>
            		<td><?php echo $row[3]; ?></td>
            		<td><?php echo $row[4]; ?></td>
                    <td><?php echo $row[7]; ?></td>
                    <td><?php echo $row[6]; ?></td>
                    </tr>
                <?php
				$i++;
				}
			}
			else
			{?>
            	<tr>
                <td colspan="6">There are no Paid Participants!</td>
                </tr>
			<?php
            }
            ?>
		</table>
        </div>
    </center>
</div>
</div>
</div>
<?php include 'footer.php';?>