bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg

hjkhhrterwefdgdfgdfgdfgdgdfgdfgdsvstertrt bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg

<?php
session_start();
if(!isset($_SESSION['loginid']) && !isset($_SESSION['UserName'])){
  header("Location:index.php");
}
include("leftmenu.php");
include("db.php");

// Fetch Category
$qy1 = "SELECT id, category_name FROM categories WHERE status=1";
$res1 = mysqli_query($db, $qy1);

while($rec1 = mysqli_fetch_assoc($res1)){
    $result1[] = $rec1;
}

$category_id = $img = $id = $description = "";
if(isset($_REQUEST["id"]) && $_REQUEST["id"] == 'Edit' && isset($_REQUEST["action"]) && $_REQUEST["action"] == 'Edit') {
  $id = $_GET['id'];
  $sql = "SELECT * FROM gallerys WHERE id=$id";
  $res = mysqli_query($db, $sql);
  $rec = mysqli_fetch_assoc($res);
  $id = $rec['id'];
  $category_id = $rec['category_id'];
  $img = $rec['gallery_image'];
  $description = $rec['description'];
}
if(isset($_POST['submit'])){
  $folder = "images/gallerys/";
  $img_file = $_FILES['image']['name'];
  if($img_file != '' && $img_file != NULL) {
    $file = $_FILES['image']['tmp_name'];
    $path = $folder . $img_file;  
    $target_file = $folder . basename($img_file);
    $FileType = pathinfo($target_file, PATHINFO_EXTENSION);
    // Allow only JPG, JPEG, PNG & GIF etc formats
    if($FileType != "jpg" && $FileType != "png" && $FileType != "jpeg" && $FileType != "gif" ) {
      $error[] = 'Sorry, only JPEG, JPG AND PNG images are allowed';   
    }
    // Move image in folder 
    move_uploaded_file($file, $target_file);
  }
  $category_id = $_POST['category_id'];
  $description = mysqli_real_escape_string($db, $_POST['description']);
  
  if($id == "") {
    $query = "INSERT INTO gallerys (category_id, gallery_image, description) VALUES ('$category_id', '$img_file', '$description')";
  } else {
    if($img_file != '' && $img_file != NULL) {
      $fileupd = $img_file;
    } else {
      $fileupd = $img;
    }
    $query = "UPDATE gallerys SET category_id='$category_id', gallery_image='$fileupd', description='$description' WHERE id=$id";  
  }
  $result = mysqli_query($db, $query);
  if($result) {
    $_SESSION['add_msg'] = "<h5 id='success_message' style='color:green;padding:10px;text-align:center;'>Gallery Saved Successfully</h5>";
  } else {
    echo "Error: " . mysqli_error($db);
  }
}
?>

<div class="content-wrapper">
    
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Gallery</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
              <li class="breadcrumb-item active">Add Gallery</li>
            </ol>
          </div>
        </div>
      </div>
    </section>

<section class="content">
      <div class="container-fluid">
        
        <div class="card card-primary">
          <div class="card-header">
            <h3 class="card-title">Gallery</h3>

<div class="card-tools">
              <a href="view-gallery.php"><button type="button" class="btn btn-warning">View Gallery</button></a>
            </div>
          </div>

<form id="quickForm" method="POST" autocomplete="off" action="" enctype="multipart/form-data">
          <?php
            if(isset($_SESSION['add_msg'])){
                echo $_SESSION['add_msg'];
                unset($_SESSION['add_msg']);
            }
            ?>
          <div class="card-body">
            <div class="row">
              <div class="form-group col-lg-6 col-md-6">
                <input type="hidden" name="id" id="id" class="form-control" value="<?php echo $id;?>">
                  <label for="name">Category</label>
                  <select name="category_id" id="category_id" class="form-control">
                    
                    <?php foreach($result1 as $key1=>$value1){ ?>
                        <option value="<?php echo $value1['id'];?>" ><?php echo $value1['category_name'];?></option>
                        
                        
                    <?php } ?>
                  </select>
              </div>
              <div class="form-group col-lg-6 col-md-6">
                  <label for="image">Gallery</label>
                  <input type="file" name="image" id="image" class="form-control" <?php if(isset($_REQUEST["id"]) && $_REQUEST["id"] == 'Edit' && isset($_REQUEST["action"]) && $_REQUEST["action"] == 'Edit') { echo "";}else{echo "required";} ?>> <?php echo $img;?>
              </div>
              <div class="form-group col-lg-6 col-md-6">
  <label for="description">Description</label>
  <input type="text" name="description" id="description" class="form-control" placeholder="Enter description">
</div>

</div>
          </div>

</div>
          
          <div class="card-footer">
             <button type="submit" name="submit" class="btn btn-primary">Submit</button>
            <a href=""><button type="button" class="btn btn-danger">Cancel</button></a>
          </div>
        </form>
        </div>

</div>
      
    </section>
    
  </div>
  
<?php
include("footer.php");
?>
<script>
$('#success_message').fadeIn().html();
    setTimeout(function() {
  $('#success_message').fadeOut("slow");
}, 3000 );
</script>