1#@!#!123s

: / home / jnclnmuac / www / web /
Filename : show_all.php
back
	<!-- Header Start -->
		<?php
			include("headernew.php");
		?>
	<!-- Header End -->
	<!-- Inner Banner Wrapper Start -->
		<div class="inner-banner">
			<div class="container">
				<div class="col-sm-12">
					<h2>Notices</h2>
				</div>
				<div class="col-sm-12 inner-breadcrumb">
					<ul>
						<li><a href="index.html">Home</a></li>
						<li>Notices</li>
					</ul>
				</div>
			</div>
		</div>
	<!-- Inner Banner Wrapper End -->
	
	
	<section class="inner-wrapper">
		<div class="container">
			<div class="row offset">
				<h2>Notices</h2>
				<div class="inner-wrapper-main offset-top-30">
					<div class="col-sm-12 col-sm-offset col-xs-offset table-responsive">
						<table class="table-custom striped table-color">	
							<tbody>
								<tr>
									<th>S.No.</th>
									<th>Notice</th>
									<th>File Name</th>
									<th>Date</th>
								</tr>
								
								<?php 
									include("admin/connection.php");
									$sql= "select * from tbl_notice";
									$date="";
									$pdf="";
									$query=mysqli_query($dbCon,$sql);
									//$result=mysqli_num_rows($query);
									//echo $result;
									//if($result>0)
									{
									while($row=mysqli_fetch_array($query,MYSQLI_BOTH))
									{
										$fileid=$row['file_id'];
										$notice=$row['notice'];
										$pdf=$row['file_name'];
										$date=$row['date'];
										?>
										<tr>
								<td><?php echo $fileid ?></td>
								<td><?php echo $notice ?></td>
								<td><a href="admin/notice/<?php echo $row['file_name'];?>" target="_blank">Click Here</a></td>
								<td><?php echo $date ?></td>					
								</tr>
										<?php 
																	
									}
									}
								?>					
								
								
							</tbody>
						</table>
					</div>
				</div>
			</div>
		</div>
	</section>	


	<!--<table>
		<tr>
			<th>Date</th>
			<th>Notice</th>
			<th>Click here to view</th>
		</tr>
		<tr>
			<td><?php echo $date; ?></td>
			<td><?php echo $notice; ?></td>
			<td><a href="admin/notice/<?php echo $pdf; ?>" target="_blank">Click here to view</a></td>
		</tr>
	</table>-->
	
<!-- Footer Links Start-->
<?php include 'footernew.php';?>