Location: PHPKode > projects > EasyFest > new/viewReports.php
<?php
	include_once("include/db_connection.php");
	header("Expires: Thu, 17 May 2001 10:17:17 GMT");    // Date in the past
	header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	header ("Cache-Control: no-cache, must-revalidate");  // HTTP/1.1
	header ("Pragma: no-cache");                          // HTTP/1.0              
	session_start();
		if($_SESSION["adminloggedIn"] == FALSE){
		header("Location:admin_login.php");
		exit;
	}
	include('header.php');
	include('left1.php');
	
	$counter = mysql_fetch_array(mysql_query("SELECT COUNT(ReportId) FROM uploads"));

$temp=mysql_query("SELECT * FROM uploads ORDER BY (ReportId) DESC ");
	
	?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>View All reports</title>
<meta name="keywords" content="" />
<meta name="Premium Series" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />

<script language="JavaScript" src="gen_validatorv31.js" type="text/javascript"></script>

<title>View All reports</title>
<style type="text/css">
<!--
.style1 {color: #00FF00}
-->
</style>
</head>

<body>

<div id="wrapper">
	<!-- start page -->
	<div id="page">
    	  <!-- start content -->
        <div id="prtCnt" align="center">
		<div id="content" align="center">
		  <div class="post">
	    <h2 class="title">&nbsp;</h2>
	    <div class="entry">

        <table width="104%" border="0" align="left" cellpadding="4" cellspacing="1" bgcolor="#CCCCCC">
  <tr>
    <td bgcolor="#E6E6E6">ReportName </td><td bgcolor="#E6E6E6">uploaded by</td><td bgcolor="#E6E6E6">Date</td><td>status</td></tr>
<?php 
while($counter[0]>0)
  {
$result6 = mysql_fetch_array($temp);

  ?><tr>
    <td bgcolor="#FFFFFF"><a href="download_file.php<?php echo "?f=".$result6['ReportName']; ?>" ><?php  echo $result6['ReportName']; ?></a></td>
	<td bgcolor="#FFFFFF"><?php echo $result6['UserName'];?>
	<td bgcolor="#FFFFFF"><?php echo $result6['Date'];?></td>
	<?php if($result6['Status']==0){//0->pending 1->approved 2->rejected
	?>
	<td bgcolor="#FFFFFF"><?php echo pending;?>
	  <p><a href="approveReports.php?id=<?php echo $result6['ReportId']."&Status=1";?>" class="style1">approve 
	    </a><a href="approveReports.php?id=<?php echo $result6['ReportId']."&Status=2";?>">reject</a></p>
	  </td>
	<?php }
	if($result6['Status']==1){//0->pending 1->approved 2->rejected
	?>
	<td bgcolor="#FFFFFF"><?php echo approved;?></td>
	<?php }
	 if($result6['Status']==2){//0->pending 1->approved 2->rejected
	?>
	<td bgcolor="#FFFFFF"><?php echo rejected;?></td>
	</tr>
	<?php }
$counter[0]--;
  }
 
?>
</table>
                    </p>
				</div>
		  </div>
		</div>
        </div>
        <!-- end content -->
		<!-- start sidebars -->
		<!-- end sidebars -->
	  <div style="clear: both;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
	
	
    
Return current item: EasyFest