<?php 
include("includes/db_config.php"); 

if (isset($_POST['submit'])) {
 //var_dump($_FILES);exit();
extract($_POST);

    $tmp_file = $_FILES['image']['tmp_name'];
    $ext = pathinfo($_FILES["image"]["name"], PATHINFO_EXTENSION);
    $rand = md5(uniqid().rand());
    $bn_image = $rand.".".$ext;
    move_uploaded_file($tmp_file,"banner/".$bn_image);

   

$sql="INSERT into slider(name,image) values ('$name','$bn_image')";
//echo $sql; exit();
$res=mysqli_query($conn,$sql) or die(mysqli_error());
if($res)
{
 echo "<script>window.location.href='banner.php'</script>";
}
}


if(isset($_POST['update']))
{
	//var_dump($_FILES);exit();
extract($_POST);
$id=$_POST["ban_id"];

$sql1 ="UPDATE  slider  SET name='$name'  WHERE id='$id'"; 
$res=mysqli_query($conn,$sql1) or die(mysqli_error());
if($res){
$sqlg = "SELECT * from slider where id = $id";
  $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
  $resg = mysqli_fetch_object($resultg);
  
  if($_FILES["ban_img"]["name"] != ""){
	$oname=$_FILES["ban_img"]["name"];
	$pos = strrpos($oname, ".");
	$extension=substr($oname,$pos+1);
	$tn = $_FILES["ban_img"]["tmp_name"];
	$path = "banner/".$resg->id.'.'.$extension;
	$upath = "banner/".$resg->image;
	unlink($upath);
	 move_uploaded_file($tn,$path);
	  $image = $resg->id.'.'.$extension;
	} else {
	  $image = $resg->image;
	}

$sqlup = "UPDATE slider SET  image =  '$image'
			 WHERE  id = $resg->id";
	$resultup = mysqli_query($conn,$sqlup) or die(mysqli_error());


}
}

?>


<!DOCTYPE html>
<html lang="en-IN">
<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Orange Groceries</title>
	<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
	<?php include("includes/css.php")?>
</head>
<body class="hold-transition skin-blue sidebar-mini">
	<div class="wrapper">
		<?php include("includes/header.php")?>
		<?php include("includes/sidebar.php")?>
		<!-- Content Wrapper. Contains page content -->
		<div class="content-wrapper">
			<!-- Content Header (Page header) -->
			<!-- Main content -->
			<section class="content">
				<div class="row">
					<div class="col-md-7">
						<div class="box box-danger">
							<div class="box-header with-border">
								<h3 class="box-title">Banner</h3>
							</div>
							<!-- /.box-header -->
							<div class="box-body table-responsive">
								<table class="table table-bordered example2">
									<thead>
										<tr>
											<th>S. No</th>
											<th>Banner Name</th>
											<th>Images</th>
											<th>Edit</th>
											<th>Delete</th>
										</tr>
									</thead>
									<tbody>
										<?php
											 $j=1;
										            $sql2="SELECT * from slider";
										            $exe2=mysqli_query($conn,$sql2);
										            while ($res=mysqli_fetch_array($exe2))
										            { ?>
										<tr>
											<td><?php echo $j; $j++; ?></td>
											<td><?php echo $res['name']; ?></td>
											<td><img src="banner/<?php echo $res['image'];?>" width="100px"></td>
											<td><input type="button" name="edit" value="Edit" id="<?php echo $res["id"]; ?>" class="btn btn-md btn-success edit_data" /></td> 
											 <td><a href="javascript:delete_ban_by_ID('<?php echo $res['id']; ?>');" class="ask"><i class="fa fa-trash-o"></i></a></td>
										</tr>

									<?php } ?>
									</tbody>
								</table>
							</div>
							<!-- /.box-body -->
						</div>
					</div>
					<div class="col-md-5">
						<div class="box box-danger">
							<div class="box-header">
								<h3 class="box-title">Add New Banner</h3>
							</div>
							<div class="box-body">
								<form method="post" action="" enctype="multipart/form-data">
									<div class="form-group">
										<label>Banner Name:</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="name" class="form-control" placeholder="Enter Banner Name">
										</div>
									</div>
									<div class="form-group">
										<label>Image:<span class="text-red">(Size : 1500 px x 392 px)</span></label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="File" name="image" class="form-control" placeholder="Choose Image">
										</div>
									</div>
									<div class="form-group">
										<div class="input-group">
											<input type="submit" name="submit" class="btn btn-success btn-md" value="Submit">
										</div>
									</div>
								</form>
							</div>
							<!-- /.box-body -->
						</div>
					</div>
				</div>
				<!-- Modal Banner --> 
				
				<div id="add_data_Modal" class="modal fade">  
      <div class="modal-dialog">  
           <div class="modal-content">  
                <div class="modal-header">  
                     <button type="button" class="close" data-dismiss="modal">&times;</button>  
                     <h4 class="modal-title">Update Banner</h4>  
                </div>  
                 <form method="post" id="insert_form" enctype="multipart/form-data">  
                <div class="modal-body">  
                    
                          <div class="form-group">
                          <label>Banner Name</label>  
                          <input type="text" name="name" id="name" class="form-control" placeholder="Category Name">
                          </div>
                         <div class="form-group">
                         <label>Banner Image <span class="text-red">(Size : 1500 px x 392 px)</span></label>  
                          <input type="file" name="ban_img" class="form-control" placeholder=" Photo" >
						 </div> 

                          <input type="hidden" name="ban_id" id="ban_id" /> 
                    
                </div>  
                <div class="modal-footer">  
                	 
                          <input type="submit" name="update" id="insert" value="Insert" class="btn btn-success" />  
                     <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>  
                </div> 
                 </form>   
           </div>  
      </div>  
 </div>  
			
			<!-- ./Modal Banner -->
			</section>
		</div>
		<?php include("includes/footer.php")?>
	</div>
	<?php include("includes/js.php")?>
	<script>
		$(function() {
			$('#example1').DataTable()
			$('#example2').DataTable({
				'paging': true,
				'lengthChange': false,
				'searching': false,
				'ordering': true,
				'info': true,
				'autoWidth': false
			})
		})
        function delete_ban_by_ID(id)
		{
			if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
				window.location.href = 'delete_banner.php?id=' + id;
			}
		}

		$(document).ready(function(){  
     
      $(document).on('click', '.edit_data', function(){  
           var ban_id = $(this).attr("id");  
           $.ajax({  
                url:"edit_banner.php",  
                method:"POST",  
                data:{ban_id:ban_id},  
                dataType:"json",  
                success:function(data){  
                     $('#name').val(data.name); 
                     $('#ban_id').val(data.id);  
                     $('#insert').val("Update");  
                     $('#add_data_Modal').modal('show');  
                }  
           });  
      });  
     
 });  
	</script>
</body>

</html>
