bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

hjkhghoppoopppooppoppoppoopoirh bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

<?php 
include('include/header.php');
include('include/sidebar.php');
$id=$_GET['id'];
if (isset($_POST['submit'])) {
  $title=$_POST['title'];
  $description=$_POST['description'];
  $image = $_FILES['image']['name'];
  if ($image!='') {
    $path = 'uploads/'.time().$image;
    unlink($_POST['image_name']);
  }else{
    $path=$_POST['image_name'];
  }
  $sql=$conn->query("UPDATE trekking SET title='$title',image='$path',description='$description' WHERE id=$id");

for($i=0;$i<count($_POST['itenary_id']);$i++){
    $ques=$_POST['edit_ques'][$i];
    $ans=$_POST['edit_ans'][$i];
    $itenary_id=$_POST['itenary_id'][$i];
    $sql=$conn->query("UPDATE itenary SET ques='$ques',ans='$ans' WHERE itenary_id=$itenary_id");
  }
  for($i=0;$i<count($_POST['ques']);$i++){
    $ques=$_POST['ques'][$i];
    $ans=$_POST['ans'][$i];
    $sql = $conn->query("INSERT INTO itenary(trekking_id,ques,ans) VALUES ('$id','$ques','$ans')");
  }

if ($sql){
    move_uploaded_file($_FILES['image']['tmp_name'], $path);
    echo '<script>alert("Save Changes Successfully");location.href="trekking";</script>';
  }
  else {
    echo '<script>alert("Something Wrong");</script>';
  }
}

$sql = $conn->query("SELECT * FROM trekking WHERE id=$id");
$row = $sql->fetch_assoc();
?>

<main class="page-content">
  <div class="row">
    <div class="col-12 col-lg-8">
      <div class="card shadow-sm border-0">
        <div class="card-body">
          <h5 class="mb-0">Edit Trekking</h5>
          <hr>
          <div class="card shadow-none border">
            <div class="card-header">
              <h6 class="mb-0 text-uppercase">Edit Trekking</h6>
            </div>
            <div class="card-body">
              <form class="row g-3" method="post" enctype="multipart/form-data">
               <div class="col-md-6">
                <label class="form-label">Title</label>
                <input type="text" class="form-control" name="title" value="<?=$row['title'];?>" required>
              </div>
              <div class="col-md-6">
                <label class="form-label">Image</label>
                <input type="hidden" class="form-control" name="image_name" value="<?=$row['image']; ?>" accept="image/*">
                <input type="file" class="form-control" onchange="readURL(this);" name="image">
              </div>
              <div class="col-md-12">
                <label class="form-label">Description</label>
                <textarea class="form-control" rows="5" cols="5" placeholder="Write..." name="description" id="editor"><?=$row['description'];?></textarea>
              </div>

<div class="col-md-6">
                <h3>Itenary</h3>
              </div>
              <div class="col-md-6 text-end">
                <button id="btn1" type="button" class="btn btn-primary px-4">Add More Intenary</button>
              </div>
              <script src="https://cdn.ckeditor.com/4.13.1/standard/ckeditor.js"></script>
              <?php 
              $sql = $conn->query("SELECT * FROM itenary WHERE trekking_id=$id");
              while($res = $sql->fetch_assoc()){ ?>
              <div class="col-md-12">
                <label class="form-label">Itenary</label><span style="cursor: pointer;" onclick="deleted(<?=$res['itenary_id'];?>,'itenary')" class="badge bg-danger rounded-pill float-end"><i class="lni lni-close"></i></span>
                <input type="hidden" name="itenary_id[]" value="<?=$res['itenary_id']; ?>">
                <input type="text" class="form-control rounded-0 mb-1" value="<?=$res['ques']; ?>" placeholder="Write" name="edit_ques[]">
              
                <textarea id="text-editor<?=$res['itenary_id'];?>" class="form-control" rows="5" cols="5" placeholder="Write..." name="edit_ans[]"><?=$res['ans']; ?></textarea>
              </div>
              <script>CKEDITOR.replace("text-editor<?=$res['itenary_id'];?>");</script>
            <?php } ?>
              <div class="itenary"></div>

<div class="col-md-6">
                <button type="submit" class="btn btn-primary px-4" name="submit"  value="1">Save Changes</button>
              </div>
            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
  <div class="col-12 col-lg-4">
    <div class="card shadow-sm border-0 overflow-hidden">
      <div class="card-body">
        <div class="profile-avatar text-center">
          <img id="preview" src="<?=$row['image']; ?>" class="shadow w-100">
        </div>
      </div>
    </div>
  </div>
</div>

</main>

<?php include('include/footer.php');?>