<html>
<head>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
   
      <link rel="stylesheet" type="text/css" href="styles.css">
  <style type="text/css">
    p
    {
      text-align: justify;
      font-family: Corbel;
      font-size: 19px;
      font-color:gold;
      color:black
    }
    #looo{
text-align: center;
color: #FDFEFE      ;
background-color:#1F618D;
font-family:Monotype Corsiva;
font-size: 27px;"
 }
  </style>
</head>
<body>
   <?php include 'heder.php';?>
      <br><br><br><br><br><br>
<div class="container " style=" border-radius: 20px; background-color:  #4682B4   " >
   <?php
  error_reporting(0);
     $conn = new mysqli("localhost","root","","event");
   
     //$query=" SELECT * FROM book join SELECT id FROM book";
      $query="select * from book ";
      $query1="select * from signup ";
     $data=mysqli_query($conn,$query);
  $total =mysqli_fetch_assoc($data);
      $data1=mysqli_query($conn,$query1);
  $total1 =mysqli_fetch_assoc($data1);
     
     
      ?>
  <center>
<table ><tr><td>
      <h3 class="text-red" style="text-align: center;color: #8B0000      ;font-family:Monotype Corsiva;font-size: 45px;"><b>Event Management Report </b></h3>
        <br>
        <h3 id="looo" class="text-red" ><b>Bill </b></h3>
 
        <table class="table table-striped table-hover" id="myTable">
    



      <tbody>
      <tr>
      
      <tbody>
  <tr>  
          <td><b>Name:</b></td> <td><?php echo $total1['fname']." ".$total1['lname']?>
      </td> <td ><b>Email:</b></td> <td><?php echo $total1['email']?></td> <td><b>Phone No:</b></td> <td><?php echo $total1['phone']?></td>
         </tr>
           <tr>  
          <td><b>Address:</b></td> <td><?php echo $total1['address']." ".$total1['lname']?>
      </td> <td ><b>City:</b></td> <td><?php echo $total1['city']?></td> <td><b>Country:</b></td> <td><?php echo $total1['country']?></td>
         </tr>
      <tr>  
          <td><b>Event Name:</b></td> <td><?php echo $total['name']?>
      </td> <td ><b>Booking Date:</b></td> <td><?php echo $total['date_']?></td> <td><b>Event Place:</b></td> <td><?php echo "<img style='height:100px;width:100px' src='".$total['place']."'>"?></td>
         </tr>
        <tr>  
          <td><b>Event Eqi1:</b></td> <td><?php echo $total['eqi1']?>
      </td>
      <td><b>Event Eqi2:</b></td> <td><?php echo $total['eqi2']?>
      </td>
       <td ><b>Guests:</b></td> <td><?php echo $total['guests']?></td> 
         </tr>

          <tr>  
          	<td></td>	<td></td>	<td></td>	<td></td>	
          <td ><b>Total:</b></td> <td><?php echo $total['rs']?>
      </td>
      
         </tr>
       

    </tbody>

</table>

     
       
   
      </div>
     

</div>
<br>
 

</body>
</html>
