<?php 
error_reporting(0);
include("common.php"); 
include("config.php"); 


?>
<style>
		
		.btn6{
			padding:2px;
			background-color:#4a3937;
			color:#fff;
			border-radius:2px;
			padding-left:10px;padding-right:10px;
			border:2px solid #4a3937;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:120px;	
			
		}
		</style>

        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
                <!-- START: Breadcrumbs-->
               
                <div class="row">
                    <div class="col-12 mt-3">
                        <div class="card">
                            <div class="card-header  justify-content-between align-items-center">                               
                                <h4 class="card-title"> <font color="blue">Today Anniversary List </font></h4> 
								           <span style="float:left">
  <a href="welcome.php"><button class="btn6">Back to page</button> </a></span>
              
       
                            </div>
							
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example1" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
											 <th>Sr.</th>
											<th>Customer Name</th>
										     <th></th>
											  
                                            </tr>
                                        </thead>
                                        <tbody>
										<?php
										error_reporting(0);
										include("config.php");
										$tdate = date("Y/m/d");
									 $query="select * from contact_book where annversary_date='$tdate' order by id desc";
    $result = $conn->query($query);
    while($enq=mysqli_fetch_assoc($result)){
		$count ++;
		
	?>
                                            <tr>
											<td><?php echo $count;?></td>
											<td><?php echo ucfirst($enq[first_name]);?> <?php echo ucfirst($enq[middle_name]);?> <?php echo ucfirst($enq[last_name]);?></b></td>
											 <td>
    <a href="https://wa.me/91<?php echo $enq['phone1']; ?>?text=<?php echo urlencode('Happy Anniversary ' . ucfirst($enq['first_name']) . '! Warm wishes to you on your marriage milestone!'); ?>" 
       target="_blank">
        Send Wishes
    </a>
</td>

                                     </tr>                        
	<?php } ?>
                                          
                                           
                                        </tbody>
                            
                                    </table>
                                </div>
                            </div>
                        </div> 

                    </div>                  
                </div>
              
                
                </div>
                <!-- END: Card DATA-->
            </div>
        </main>
        <!-- END: Content-->

      
     
      


        <!-- START: Template JS-->
        <script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
        <script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
        <script src="dist/vendors/moment/moment.js"></script>
        <script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script>    
        <script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
        <script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script> 
        <!-- END: Template JS-->
        
        <!-- START: APP JS-->
        <script src="dist/js/app.js"></script>
        <!-- END: APP JS-->

        <!-- START: Page Vendor JS-->
        <script src="dist/vendors/datatable/js/jquery.dataTables.min.js"></script> 
        <script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
        <script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->        
        <script src="dist/js/datatable.script.js"></script>
		
    </body>
 
</html>