<?php include'header.php';?>
<?php include'sidebar.php';?>


        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <div class="container-fluid">
                <div class="row page-titles mx-0">
                    <div class="col-sm-6 p-md-0">
                        <div class="welcome-text">
                            <h4>Studio 7 Eleven Beauty Salon</h4>
							<br>
                            <h3 class="ml-1">Appointment</h3>
                        </div>
                    </div>
                   
                </div>
                <!-- row -->


                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Appointment Datatable</h4>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display" style="min-width: 845px">
                                        <thead>
                                            <tr>
                                                <th>S.NO</th>
                                                <th>Name</th>
                                                <th>Address</th>
                                                <th>Phone</th>
                                                <th>Date</th>
                                                <th>Service</th>
                                                <th>Delete</th>
                                            </tr>
                                        </thead>
                                        <tbody>
										
					                   <?php include 'conn.php';?>
             
					<?php 
					 
	   
		   $x=1;
	   $display=mysqli_query($conn,"SELECT * From appointment");
	   while ($row=mysqli_fetch_array($display))
	   {             ?>
                      <tr>
                   
                        <td><?php echo $x;?></td>
                        <td><?php echo $row['name'];?></td>
                        <td><?php echo $row['address'];?></td>
                        <td><?php echo $row['phone'];?></td>
                        <td><?php echo $row['date'];?></td>
                        <td><?php echo $row['service'];?></td>
                        <td><a href="delete.php?id=<?php echo $row['id'];?>"><img class="del-img"src="images/delete.png" alt="image"></a></td>
                       
                       
                      </tr>
					  
					  
                        <?php $x++; } ?>
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                <th>S.NO</th>
                                                <th>Name</th>
                                                <th>Address</th>
                                                <th>Phone</th>
                                                <th>Date</th>
                                                <th>Service</th>
                                                <th>Delete</th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->

    <?php include'footer.php';?>