<?php include("includes/db_config.php"); 
if(isset($_POST['update']))
{
    //var_dump($_FILES);exit();
    extract($_POST);
    $id="1";
    extract($_POST);
	$sql1 ="UPDATE  whatsapp_add  SET url='$ads_Name'  WHERE id='$id'"; 
	$res=mysqli_query($conn,$sql1) or die(mysqli_error());
	if($res){
	$sqlg = "SELECT * from whatsapp_add where id = $id";
	$resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
	$resg = mysqli_fetch_object($resultg);

	if($_FILES["image"]["name"] != ""){
	$oname=$_FILES["image"]["name"];
	$pos = strrpos($oname, ".");
	$extension=substr($oname,$pos+1);
	$tn = $_FILES["image"]["tmp_name"];
	$path = "img/ads/".$resg->id.'32'.'.'.$extension;
	$upath = "img/ads/".$resg->image;
	unlink($upath);
	move_uploaded_file($tn,$path);
	$image = $resg->id.'32'.'.'.$extension;
	} else {
	$image = $resg->image;
	}
	$sqlup = "UPDATE whatsapp_add 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-12">
						<div class="box box-danger">
							<div class="box-header with-border">
								<h3 class="box-title">Whatsapp Ads</h3>
							</div>
							<?php  $sqlg = "SELECT * from whatsapp_add ";
							$resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
							$res= mysqli_fetch_array($resultg); ?>
							<!-- /.box-header -->
							<div class="box-body table-responsive">
								<form method="post" action="" enctype="multipart/form-data">
									<div class="form-group">
										<label>Ads URL :</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" value="<?php echo $res['url']; ?>" placeholder="Enter Whatsapp Ads Name">
										</div>
									</div> 
									<div class="form-group">
										<label>Top Ads Banner : <span class="text-red">Size(1140px * 129px)</span></label>
										<img src="img/ads/<?php echo $res['image']; ?>" style="height:65px;"><br/>
										<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="Category">
										</div>
									</div> 

									<div class="form-group">
										<div class="input-group">
											<input type="submit" name="update" class="btn btn-success btn-md" value="Update">
										</div>
									</div>
								</form>
							</div> 
						</div>
					</div> 
				</div> 
			</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_enq_by_ID(id)
		{
			if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
				window.location.href = 'delete_enquiry.php?id=' + id;
			}
		}

	</script>
</body>

</html>
