<?php
include("include/connection.php");
$bid=$_GET['id'];
 if($_POST['Save']!='')
 {
		if(empty($_FILES['im']['name'])){
          $file_name = $_POST['old_image'];
        }else{
    $errors = array();
    $file_name = $_FILES['im']['name'];
    $file_size = $_FILES['im']['size'];
    $file_tmp = $_FILES['im']['tmp_name'];
    $file_type = $_FILES['im']['type'];
   
    // $file_ext = end(explode(".",$file_name));
    $tmp = explode('.', $file_name);
    $file_ext = end($tmp);
    $extensions = array("jpeg", "jpg", "png","webp");
    // $query = mysqli_query($con, "select max(sid) as stid from student_details");
    // $result = mysqli_fetch_array($query);
    // $student_id = $result['stid'] + 1;
    // $dir = "images/student-images/$student_id";
    // mkdir($dir);
    if (in_array($file_ext, $extensions) === false) {
      $errors[] = "This extension file not allowed, Please choose a JPG or PNG file.";
      header("location:blog.php");
    }
    if ($file_size > 2097152) {
      $rerrors[] = "File size must be 2mb or lower.";
      $_SESSION['status'] = "File size must be 10mb or lower!";
      $_SESSION['status_code'] = "error";
      header("location:blog.php");
    }
    if (empty($errors) == true) {
      move_uploaded_file($file_tmp, "../assets/images/blog/". $file_name);
    } else {
      print_r($errors);
      header("location: blog.php");
    }
        }
	    $title=trim(addslashes($_POST['tname']));
	    $slug=strtolower(trim(addslashes($_POST['slug'])));
	    $sdesc=trim(addslashes($_POST['sdesc']));
	    $desc=trim(addslashes($_POST['desc']));
	    $mt=trim(addslashes($_POST['mt']));
	    $mk=trim(addslashes($_POST['mk']));
	    $mdesc=trim(addslashes($_POST['mdesc']));
	    date_default_timezone_set("Asia/Kolkata");
          $date = Date('Y-m-d H:i:s');
	   // echo "Update  blogs set slug='$slug',name='$title',short_description='$sdesc',description='$desc',meta_title='$mt',meta_description='$mdesc',keywords='$mk',banner='$file_name',created_at='$date' where id='$bid' ";
		$q=mysqli_query($con,"Update  blogs set slug='$slug',name='$title',short_description='$sdesc',description='$desc',meta_title='$mt',meta_description='$mdesc',keywords='$mk',banner='$file_name',created_at='$date' where id='$bid' ");
		if($q){
		    header("location:blog.php");
		}
  
		
 }
     $id=$_GET['id'];
     $qry_all="SELECT * FROM blogs where id='$id'";
	 $rsc_all=mysqli_query($con,$qry_all);
	 $row=mysqli_fetch_array($rsc_all);
?>
<!DOCTYPE html>
<html lang="en">
<head>
   <?php include("element/css_js.php"); ?>
</head>
<body class="hold-transition dark-mode sidebar-mini layout-fixed layout-navbar-fixed layout-footer-fixed">
<div class="wrapper">
  <!-- Preloader -->
   <?php include("element/header.php"); ?>
  <!-- Main Sidebar Container -->
<?php include("element/menu.php"); ?>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Manage Blog</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="#">Home</a></li>
              <li class="breadcrumb-item active"> Menu</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>
    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <!-- left column -->
          <div class="col-md-12">
            <!-- general form elements -->
            <div class="card card-primary">
              <div class="card-header">
                <h3 class="card-title"> Blog</h3>
              </div>
              <!-- /.card-header -->
              <!-- form start -->
              <form method="post" enctype="multipart/form-data">
                <div class="card-body">
                    <div class="row">
                     <div class="col-md-9 mx-auto">
                          <div class="form-group">
                            <label for="exampleInputEmail1">Title</label>
                            <input type="text" value="<?php echo $row['name']; ?>" name="tname" class="form-control">
                          </div>
                          <div class="form-group">
                            <label for="exampleInputEmail1">Short Description</label>
                            <textarea id="w3review" value="" class="form-control" rows="5" name="sdesc"><?php echo $row['short_description']; ?></textarea>
                          </div>
                          <div class="form-group">
                            <label for="exampleInputEmail1">Description</label>
                            <textarea id="editor1" value="" class="form-control" rows="10" name="desc"><?php echo $row['description']; ?></textarea>
                          </div>
                           <div class="form-group">
                            <label for="exampleInputEmail1">Slug</label>
                            <input type="text" value="<?php echo $row['slug']; ?>" name="slug" class="form-control">
                          </div>
                          <div class="form-group">
                            <label for="exampleInputEmail1">Meta Title</label>
                            <input type="text" value="<?php echo $row['meta_title']; ?>" name="mt" class="form-control">
                          </div>
                          
                          <div class="form-group">
                            <label for="exampleInputEmail1">Meta keywords</label>
                            <input type="text" value="<?php echo $row['keywords']; ?>" name="mk" class="form-control">
                          </div>
                          <div class="form-group">
                            <label for="exampleInputEmail1">Meta Description</label>
                            <input type="text" value="<?php echo $row['meta_description']; ?>" name="mdesc" class="form-control">
                          </div>
                          
                           <div class="form-group">
                            <label for="exampleInputEmail1">Image</label>
                            <input type="file" name="im" class="form-control">
                            <input type="hidden" name="old_image" value="<?php echo $row['banner']; ?>" class="form-control">
                          </div>
                          <div class="form-group">
                            <button type="submit" name="Save" value="Save" class="mt-2 btn btn-primary">Save</button>
                         </div>
                     </div>
                <!-- /.card-body -->                    </div>
                    </div>
              </form>
              
            </div></div></div></div></section></div>
  <!-- /.content-wrapper -->
  <footer class="main-footer">
    <strong>Copyright &copy; 2021-2022 <a href="#">koscove Admin</a>.</strong>
    All rights reserved.
    <div class="float-right d-none d-sm-inline-block">
     <!-- <b>Version</b> 3.1.0-->
    </div>
  </footer>
  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
  $.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparklines/sparkline.js"></script>
<!-- JQVMap -->
<script src="plugins/jqvmap/jquery.vmap.min.js"></script>
<script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
<!-- jQuery Knob Chart -->
<script src="plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="plugins/moment/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<!-- overlayScrollbars -->
<script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard.js"></script>
<script>
		$(document).ready(function() {
	        $('#editor1').summernote({
	        	height: 300
	        });
	        $('#editor2').summernote({
	        	height: 300
	        });
	        $('#editor3').summernote({
	        	height: 300
	        });
	        $('#editor4').summernote({
	        	height: 300
	        });
	        $('#editor5').summernote({
	        	height: 300
	        });
	    });
		$(".top-cat").on('change',function(){
			var id=$(this).val();
			var dataString = 'id='+ id;
			$.ajax
			({
				type: "POST",
				url: "get-mid-category.php",
				data: dataString,
				cache: false,
				success: function(html)
				{
					$(".mid-cat").html(html);
				}
			});			
		});
		$(".mid-cat").on('change',function(){
			var id=$(this).val();
			var dataString = 'id='+ id;
			$.ajax
			({
				type: "POST",
				url: "get-end-category.php",
				data: dataString,
				cache: false,
				success: function(html)
				{
					$(".end-cat").html(html);
				}
			});			
		});
	</script>
</body>
</html>