<?php include("includes/css.php")?>
<?php
session_start();
 include("includes/db_config.php");
if (isset($_POST['submit'])) {
extract($_POST);
    $tmp_file = $_FILES['banner']['tmp_name'];
    $ext = pathinfo($_FILES["banner"]["name"], PATHINFO_EXTENSION);
    $rand = md5(uniqid().rand());
    $bimg = $rand.".".$ext;
    move_uploaded_file($tmp_file,"banner/".$bimg);

    $ads_Name=mysqli_real_escape_string($conn,$_POST['ads_Name']);
    
$sql="INSERT into top_ads(ads_name,banner) values ('$ads_Name','$bimg')";
//echo $sql; exit();
$res=mysqli_query($conn,$sql) or die(mysqli_error());
if($res){
     echo "<script>window.location.href='add-ads.php'</script>";
}
}

if(isset($_POST['update']))
{
extract($_POST);
$id=$_POST["ads_id"];
	$sql1 ="UPDATE  top_ads  SET ads_name='$ads_name' WHERE id='$id'"; 
	$res=mysqli_query($conn,$sql1) or die(mysqli_error());

	if($res){
	$sqlg = "SELECT * from top_ads where id = $id";
	  $resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
	  $resg = mysqli_fetch_object($resultg);

		 if($_FILES["banner"]["name"] != ""){
		$oname=$_FILES["banner"]["name"];
		$pos = strrpos($oname, ".");
		$extension=substr($oname,$pos+1);
		$tn = $_FILES["banner"]["tmp_name"];
		$path = "banner/".$resg->id.'.'.$extension;
		$upath = "banner/".$resg->banner;
		unlink($upath);
		move_uploaded_file($tn,$path);
		 $image_ban = $resg->id.'.'.$extension;
		} else {
		  $image_ban = $resg->banner;
		}

		$sqlup = "UPDATE top_ads SET  banner='$image_ban'
					 WHERE  id = $resg->id";
		$resultup = mysqli_query($conn,$sqlup) or die(mysqli_error());
		}
}
?>
<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-6">
						<div class="box box-danger">
							<div class="box-header with-border">
								<h3 class="box-title">Ads Banner</h3>
							</div> 
							<div class="box-body table-responsive">
								<table class="table table-bordered example1">
									<thead>
										<tr>
											<th>S.No</th>
											<th>Name</th>
											<th>Ads Banner</th>
											<th>Edit</th>
											<th>Delete</th>
										</tr>
									</thead>
										<?php
									$sql="select * from top_ads";
									$result = mysqli_query($conn, $sql);
                                    $j=1;
									while($res= mysqli_fetch_array($result))
									{ 
									?>
										<tr>
											<td><?php echo $j; $j++; ?></td>
											<td><?php echo $res['ads_name']; ?></td> 
												<td><img src="banner/<?php echo $res['banner']; ?>" class="img-responsive" style="width:50px" alt=""> </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_ads_by_ID('<?php echo $res['id'] ?>');" class="ask"><i class="fa fa-trash-o"></i></a></td>
										</tr>  
									<?php } ?>
									</tbody>
								</table>
							</div> 
						</div>
					</div>
					<div class="col-md-6">
						<div class="box box-danger">
							<div class="box-header">
								<h3 class="box-title">Add Ads Banner</h3>
							</div>
							<div class="box-body">
								<form method="post" action="" enctype="multipart/form-data">
									<div class="form-group">
										<label>Ads Name :</label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="text" name="ads_Name" class="form-control" placeholder="Enter Ads Name">
										</div>
									</div> 
									<div class="form-group">
										<label>Top Ads Banner : <span class="text-red">Size(728px * 900px)</span></label>
										<div class="input-group">
											<div class="input-group-addon">
												<i class="fa fa-suitcase"></i>
											</div>
											<input type="file" name="banner" class="form-control" placeholder="Category">
										</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> 
						</div>
					</div>
				</div>
				<!-- Modal Category --> 
				<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 Ads Banner</h4>  
		                </div>  
		                 <form method="post" enctype="multipart/form-data">  
		                <div class="modal-body">                      
		                          <div class="form-group">
												<label>Top Ads Name :</label>
												<div class="input-group">
													<div class="input-group-addon">
														<i class="fa fa-suitcase"></i>
													</div>
													<input type="text" name="ads_name" id="ads_name" class="form-control" placeholder="Enter Ads Name">
												</div>
											</div> 
											<div class="form-group">
												<label>Top Ads Banner : <span class="text-red">Size(728px * 90px)</span></label>
												<div class="input-group">
													<div class="input-group-addon">
														<i class="fa fa-suitcase"></i>
													</div>
													<input type="file" name="banner" class="form-control" placeholder="Category">
												</div>
											</div>                     
		                </div>  
		                   <input type="hidden" name="ads_id" id="ads_id" /> 
		                <div class="modal-footer">  
		                	<input type="submit" name="update" id="insert" value="Update" class="btn btn-success" />  
		                     <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>  
		                </div> 
                 </form>   
           </div>  
      </div>  
 </div>  
			<!-- ./Modal Category -->
			</section>
		</div>
		<?php include("includes/footer.php")?>
	</div>
	<?php include("includes/js.php")?>
</body> 
<script language="javascript">

 $(document).ready(function(){  
     
      $(document).on('click', '.edit_data', function(){  
           var ad_id = $(this).attr("id");  
           $.ajax({  
                url:"edit_adstop.php",  
                method:"POST",  
                data:{ad_id:ad_id},  
                dataType:"json",  
                success:function(data){  
                     $('#ads_name').val(data.ads_name); 
                     $('#ads_id').val(data.id);  
                     $('#insert').val("Update");  
                     $('#add_data_Modal').modal('show');  
                }  
           });  
      });  
     
 });  

 function delete_ads_by_ID(id)
{
	if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
		window.location.href = 'delete_ads.php?id=' + id;
	}
}

</script>
</html>
