<?php
include_once("include/db_connection.php");
session_start();
if($_SESSION["adminloggedIn"] == FALSE){
header("Location:admin_login.php");
exit;
}
include('header.php');
include('left1.php');
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Premium Series by Free CSS Templates</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>Untitled Document</title>
</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"> </h2>
<div class="entry">
<?php
$dbHostname = "localhost";
$dbUsername = "root";
$dbPassword = "admin";
$dbName = "EasyFest";
$dblink = MYSQL_CONNECT($dbHostname, $dbUsername, $dbPassword) OR DIE("Error !! Unable to connect to database");
// Select database or print error message if unsuccessful
mysql_select_db($dbName) or die( "Unable to select database ".$dbName);
$counter = mysql_fetch_array(mysql_query("SELECT COUNT(BoothId) FROM booths"));
//echo "$counter[0]"."<br/>";
$temp=mysql_query("SELECT BoothId FROM booths ORDER BY (BoothId) DESC ");
?>
<table width="600" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<th width="123" height="27" scope="col" bgcolor="#E6E6E6">BoothType</th>
<th width="132" scope="col" bgcolor="#E6E6E6">Company</th>
<th width="136" scope="col" bgcolor="#E6E6E6">PhoneNo.</th>
<th width="136" scope="col" bgcolor="#E6E6E6">Price</th>
<th width="132" scope="col" bgcolor="#E6E6E6">Added By</th>
</tr>
<?php
$income=0;
while($counter[0]>0)
{
$result6 = mysql_fetch_array($temp);
//echo $result6[0]."<br/>";
$counter[0]=$counter[0]-1;
$result2 = mysql_fetch_array(mysql_query("SELECT BoothType,CompanyName,CompanyPhoneNo,Charge,UserName FROM booths WHERE BoothId = $result6[0]"));
//print_r($result2);
//echo "$result2[0]"."$result2[1]"."$result2[2]"."$result2[3]"."$result2[4]";
$income = $income + $result2[3];
?>
<tr>
<td><?php echo $result2[0]; ?></td>
<td><?php echo $result2[1]; ?></td>
<td><?php echo $result2[2]; ?></td>
<td><?php echo $result2[3]; ?></td>
<td><?php echo $result2[4]; ?></td>
</tr>
<?php
}
?>
</table>
<?php
echo "TOtal income ";
echo $income;
?>
</p>
</div>
</div>
</div>
</div>
<!-- end content -->
<!-- start sidebars -->
<!-- end sidebars -->
<div style="clear: both;"> </div>
</div>
<!-- end page -->
</div>
</html>
<?php
include('footer.php');
?>