<?php
$_SESSION['active'] = 'homeWhyChooseUs';
    include 'header.php';
    include 'sidelinks.php';
    include ('include/functions.php');
      $query = select_whychooseUs();

if(!empty($_POST['submit'])){ 
    whychooseUs_insert();
}

 if(!empty($_GET['failed'])){
     ?>
   <div align="center"><h4 style="color:red;">Fail Inserted </h4></div>
     <?php
  }
?>

 <?php
   if(!empty($_GET['succ'])){
     ?>
  <!--    <div align="center">
      <h4 style="color:green;">Data Insert Successfully </h4>
    </div> -->
    <script>alert("Data Inserted Successfully");</script>
     <?php
  }

   if(!empty($_GET['delId'])){
       delete_whychooseUs($_GET['delId']);
    }
?>

<div class="pcoded-content">

<div class="page-header card">
<div class="row align-items-end">
<div class="col-lg-8">
<div class="page-header-title">
<i class="feather icon-clipboard bg-c-blue"></i>
<div class="d-inline">
<h5>Why Choose Us Form Inputs</h5>
<span>To Change Why Choose Us Image and Content Here</span>
</div>
</div>
</div>
<div class="col-lg-4">
<div class="page-header-breadcrumb">
<ul class=" breadcrumb breadcrumb-title">
<li class="breadcrumb-item">
<a href="#"><i class="feather icon-home"></i></a>
</li>
<li class="breadcrumb-item"><a href="#">Form Components</a>
</li>
<li class="breadcrumb-item">
<a href="#">Why Choose Us Form Inputs</a>
</li>
</ul>
</div>
</div>
</div>
</div>

<div class="pcoded-inner-content">

<div class="main-body">
<div class="page-wrapper">

<div class="page-body">
<div class="row">
<div class="col-sm-12">

<div class="card">
<div class="card-header">
<h5>Why Choose Us Form Inputs</h5>
<span>Add class of <code>.form-control</code> with <code>&lt;input&gt;</code> tag</span>
</div>
<div class="card-block">
<h4 class="sub-title">Why Choose Us Inputs</h4>
<form method="post" enctype="multipart/form-data">
<div class="form-group row">
<label class="col-sm-2 col-form-label">Image</label>
<div class="col-sm-10">
    <img id="image_preview1"  src="assets/uploads/user.png" style="height:100px;width:100px;" />
<input type="file" class="form-control" name="formFile" name="imgUp" id="imgUp" onchange="readURL1(this);">
</div>
</div> 
 <div class="form-group row">
<label class="col-sm-2 col-form-label">Content</label>
<div class="col-sm-10">
<input type="text" class="form-control" name="content" placeholder="Enter Content Here">
</div>
</div>  
  
 <div class="form-group row">
<div class="col-sm-3"> </div>
<div class="col-sm-6">
    <p style="text-align: center;">
        <input type="submit" name="submit" value="Update" class="btn waves-effect waves-light btn-grd-success">
    </p>
</div>
<div class="col-sm-3"> </div>
</div>  
</form>  
</div>
  <?php
                if(!empty($_GET['del']))
                {
            ?>
              <!-- <div align="center" style="color:green;"> <h4>Data Delete Successfully</h4></div> -->
              <script>alert("Deleted Successfully");</script>
              <?php
              }
            ?>
<div class="card-block">
<h4 class="sub-title">Reports</h4>

              <table class="table datatable">
                <thead>
                  <tr>
                    <th scope="col">#</th>
                    <th scope="col">Image</th>
                    <th scope="col">Content</th>
                  
                    <th scope="col">Action</th>
                  </tr>
                </thead>

                <tbody>
                 <?php
                 $i=1;
                   while($row = mysqli_fetch_array($query)){
                    
                 ?>
                
                  <tr>
                  <td><?php echo $row['id'] ;?></td>
                  <td><?php echo $row['image'] ?></td>
                  <td><?php echo $row['content']?></td>
                  

                  
                  <td>
                    <a href="whyChooseUsEdit.php?editId=<?php echo $row['id']?>" class="btn btn-success">Edit</a>
                    <a href="whyChooseUs.php?delId=<?php echo $row['id']?>" class="btn btn-danger">Delete</a>
                  </td>
                  </tr>
                  <?php 
                  $i++;
              }?>
                </tbody>
                
              </table>

</div>
 
</div>
</div>
</div>

</div>
</div>


<script type="text/javascript">
function readURL1(input) {
  if (input.files && input.files[0]) {
    var reader = new FileReader();
    reader.onload = function(e) {
      $('#image_preview1').attr('src', e.target.result);
    }
    reader.readAsDataURL(input.files[0]);
  }
}
$("#imgUp").change(function() {
  readURL1(this);
});
</script>

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