Location: PHPKode > projects > EasyFest > new/viewAllBooth.php
<?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">&nbsp;</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;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
Return current item: EasyFest