<?php include('header.php'); 


$sql_event  = "SELECT id FROM post WHERE category='event'";
$query_event = mysqli_query($conn,$sql_event) or die(mysqli_error($conn));
$count_event = mysqli_num_rows($query_event);

$sql_exhibit  = "SELECT id FROM post WHERE category='media'";
$query_exhibit = mysqli_query($conn,$sql_exhibit) or die(mysqli_error($conn));
$count_exhibit = mysqli_num_rows($query_exhibit);

$sql1  = "SELECT id FROM feedback_tbl";
$query1 = mysqli_query($conn,$sql1) or die(mysqli_error($conn));
$count1 = mysqli_num_rows($query1);
?>
  
  

      
      <!--main content start-->
      <section id="main-content">
          <section class="wrapper">            
              <!--overview start-->
			  <div class="row">
				<div class="col-lg-12">
					<h3 class="page-header"> welcome</h3>
					<ol class="breadcrumb">
						<li><a href="home.php">Home</a></li>
						<li>Dashboard</li>						  	
					</ol>
				</div>
			</div>
              
          
			
			
			 <div class="row">
            
            	 
              	<div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
		              
							<div class="info-box blue-bg">
								<div class="count">Events <?php print $count_event; ?></div>					
							</div><!--/.info-box-->	
		                   		
				</div><!--/.col-->
				
				
				<div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
		                
							<div class="info-box green-bg">
								<div class="count">Media <?php print $count_exhibit; ?></div>					
							</div><!--/.info-box-->	
		                    	
				</div><!--/.col-->	
				
				<div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
		                
							<div class="info-box yellow-bg">
								<div class="count">Feedbacks <?php print $count1; ?></div>					
							</div><!--/.info-box-->	
		                    	
				</div><!--/.col-->	
				
			</div>
			
			
          </section>
      </section>
      
  </section>  
  </body>
</html>
