<?php
include('header.php');
$news_letter_class = "newsletter-area-2";
?>
<section class="page-banner">
    <div class="page-banner-bg bg_cover" >
        <div class="container">
            <h2 class="about-title custom_title"><span>Documents</span></h2>
        </div>
    </div>
</section>
<section class="">
	<div class="container">
		<div class="event-details-content mb-50">
			<div class="event-schedule-table table-responsive" style="margin-top:20px;">
			     <?php
			     $query_mng = mysqli_query($con,"select category from documents where is_active=1 group by category"); 
			     while($res_mng = mysqli_fetch_array($query_mng))
			     {
			         $cname = $res_mng['category'];
			     ?>
			    <h6 class="mb-10 mt-20"><?php echo $cname; ?></h6>
				<table class="table">
					<thead>
						<tr>
						
							<th>Title</th>
							<th>File</th>
						</tr>
					</thead>
					<tbody>
					    <?php
                        $query_mng1 = mysqli_query($con,"select * from documents where category='$cname' order by id desc"); 
                        while($res_mng1 = mysqli_fetch_array($query_mng1))
                        {
                        ?>
						<tr>
						
							<td><?php echo $res_mng1['title']; ?></td>
						
							<td><a href="adminweb/<?php echo $res_mng1['file']; ?>" target="_blank">View</a></td>
						</tr>
						<?php
						    }
						?>
					</tbody>
				</table>
				<?php
			     }
				?>
			</div>
		</div>
	</div>
</section>
<?php include('footer.php'); ?>