<?php include'header.php';?>
     <?php include'sidebar.php';?>
	 <?php include 'conn.php';?>
<script>
function show_confirm() {
    return confirm("Are You Sure edit");
}
</script>

  <?php
  
$id=$_GET["id"];


 {
      $result = mysqli_query($conn,"SELECT * FROM recent_work WHERE id='$id'");
      $row1= mysqli_fetch_array($result);
        
    if(isset($_POST['submit']))

    {
       
        
        $image=$_POST['image'];
      $image="img/".$_FILES['image']['name']; 
      move_uploaded_file($_FILES['image']['tmp_name'],$image);
      $sql =mysqli_query($conn, "UPDATE recent_work SET image='$image' WHERE id='$id'");
        
        if($sql){
            echo "<script> alert ('data stored successfully')</script>";
            echo "<script> window.location.assign ('recent_work.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 Recent Work</h4>
							<br>
                            <h5 class="ml-1">Images</h5>
                        </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">Image Upload</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">
                                            
										   <div class="custom-file">
                                                <input type="file" value="<?php echo $row1['image'];?>"name="image" class="custom-file-input">
                                                <label class="custom-file-label">Choose file</label>
                                            </div>
											<br>
											<br>
											<div class="col-12">
                                                <button type="submit" value="UPLOAD" 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">Recent Work 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>Image</th>
                                                <th>Delete</th>
                                                <th>Edit</th>
                                            </tr>
                                        </thead>
                                        <tbody>
					                   <?php 
		                                 $x=1;
	                                    $display=mysqli_query($conn,"SELECT * From recent_work");
	                                     while ($row=mysqli_fetch_array($display))
	                                        {             ?>
                                        <tr>
                                        <td><?php echo $x;?></td>
                                        <td><img height="50px" class="annual"src="<?php echo $row['image'];?>" alt="image"></td> 
                                        <td><a href="recentdel.php?id=<?php echo $row['id'];?>"><img class="del-img"src="images/delete.png" alt="image"></a></td>
										 <td><a href="workedit.php?id=<?php echo $row['id'];?>"><img class="del-img"src="images/edit.png" alt="image"></a></td>
                       
                                       </tr>
					  
					  
                        <?php $x++; } ?>
					                    
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                <th>S.NO</th>                                   <th>Image</th>
                                                <th>Delete</th>
                                                <th>Edit</th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                </div>
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->



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