<?php include'header.php';?>
     <?php include'sidebar.php';?>
	 <?php include 'conn.php';?>
<?php
 
  
 if(isset($_POST['submit']))

 {
       $category=$_POST['category'];
	

	 $sql =mysqli_query($conn,"INSERT INTO gallery_category(category) VALUES ('$category')");
        
        if($sql){
            echo "<script> alert ('data stored successfully')</script>";
            echo "<script> window.location.assign ('category.php')</script>";
 
           
        } else{
            echo "ERROR: Hush! Sorry ";
       
        }
 }
 
 ?>

        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body recent-imgheight">
            <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 Gallery category</h4>
							<br>
                            
                        </div>
                    </div>
                    
                </div>
                <!-- row -->
                <div class="row">
                    <div class="col-xl-6 col-xxl-12">
                        
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Category Insert</h4>
                            </div>
							 
                            <div class="card-body">
                                <div class="basic-form custom_file_input">
                                    <form action="" method="POST" enctype="multipart/form-data">
                                        
									  <div class="form-group row">
                                                    <label class="col-lg-2 col-form-label" for="val-email">Category<span
                                                            class="text-danger">*</span>
                                                    </label>
                                                    <div class="col-lg-9">
                                                        <input type="text" class="form-control" name="category" placeholder="Enter Categorys">
                                                    </div>
                                                </div>
											<br>
											<br>
											<div class="col-12">
                                                <button type="submit" name="submit"class="btn btn-primary mb-2">Submit</button>
                                            </div>
											
											
                                            
                                        </div>
                                        
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->
		 <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <div class="container-fluid">
                


                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Category 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>Categorys</th>
                                                <th>Delete</th>
                                            </tr>
                                        </thead>
                                        <tbody>
					                   <?php 
		                                 $x=1;
	                                    $display=mysqli_query($conn,"SELECT * From gallery_category");
	                                     while ($row=mysqli_fetch_array($display))
	                                        {             ?>
										<tr>
                                        <td><?php echo $x;?></td>
                                        <td><?php echo $row['category'];?></td>
                                        <td><a href="catedelete.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>Categorys</th>
                                                <th>Delete</th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->



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