gallery_photo_edit.php

<?php include('includes/header.php'); ?>

<?php

if($_SESSION['super_id'] == '')

{
        echo "<script>window.location.href='login.php'</script>";
    }
     $super_id = $_SESSION['super_id'];
?>

<?php

$photo_id = $_GET['photo_id'];

$query = mysqli_query($conn,"SELECT * FROM iv_photo_gallery WHERE gallery_id='$photo_id'");

$row = mysqli_fetch_assoc($query);

if(isset($_POST['gallery']))

{

$main_cat_id = $_POST['main_cat_id'];
                $sub_cat_id = $_POST['sub_cat_id'];
                $title = $_POST['title'];
                $discription = mysqli_real_escape_string($conn,$_POST['discription']);
                $upload_id = $_POST['upload_id'];

$sub_images_file = $_FILES['gallery_image']['name'];

if($sub_images_file != '')

{

$extension = pathinfo($_FILES["gallery_image"]["name"], PATHINFO_EXTENSION);
                    $sub_images = $_FILES['gallery_image']['name'];
                    $temp_sub_img =$_FILES['gallery_image']["tmp_name"];
                    $newImageName = 'imi_'.round(microtime(true)).'_'.".".$extension;
                    $folder = "../assets/images/photo_gallery/gallery_images/".$newImageName;
                    move_uploaded_file($temp_sub_img,$folder);
                }

else

{
                    $newImageName = $row['gallery_image'];
                }

date_default_timezone_set('Asia/Kolkata');
                 $created_date = date('d-m-Y H:i:s');

$update = "UPDATE iv_photo_gallery SET gallery_main_id='$main_cat_id',gallery_sub_id='$sub_cat_id',gallery_title='$title',
                gallery_description='$discription',gallery_image='$newImageName',upload_by='$upload_id',
                gallery_updated_date='$created_date' WHERE gallery_id='$photo_id'";

$query1 = mysqli_query($conn,$update);

if($query1 == 1)

{

$_SESSION['photo_sub'] = 'Gallery Edited Successfully';

echo "<script> window.location.href='gallery_photos_table.php' </script>";

}

else

{

$_SESSION['photo_sub'] = 'Something Went Wrong';

echo "<script> window.location.href='gallery_photos_table.php' </script>";

}

<h1 class="page-title">Edit Gallery</h1>

<div>

<li class="breadcrumb-item"><a href="javascript:void(0)">Gallery</a></li>

<li class="breadcrumb-item active" aria-current="page">Edit Gallery</li>

</ol>

</div>

<h4 class="card-title">Edit Gallery</h4>

</div>

<label class="form-label"> Main Category Name</label>
                                    
                                    <select class="form-control form-select" name="main_cat_id" onchange="subCategory(this.value);" required>
                                        <?php 
                                        $query1 = mysqli_query($conn,"SELECT * FROM iv_photo_gallery_main");
                                        while($row1 = mysqli_fetch_assoc($query1))
                                        {
                                        ?>
                                        <option value="<?php echo $row1['iv_image_cat_id'] ?>"
                                        <?php if($row1['iv_image_cat_id']==$row['gallery_main_id']){ echo 'selected';} ?>>
                                            <?php  echo $row1['iv_image_cat_name'] ?></option>
                                        <?php
                                        }
                                        ?>
                                    </select>

<div class="valid-feedback">Looks good!</div>

</div>
                                <div class="form-group">

<label class="form-label"> Sub Category Name</label>
                                    
                                    <select class="form-control form-select" name="sub_cat_id" required id="main">

<?php

$main_id = $row['gallery_main_id'];

$query2 = mysqli_query($conn,"SELECT * FROM iv_photo_gallery_sub WHERE iv_image_cat_id='$main_id'");

while($row2 = mysqli_fetch_assoc($query2))

{

<?php

}

</select>

<div class="valid-feedback">Looks good!</div>

</div>

<label class="form-label">Title</label>

<input type="text" name="title" class="form-control" value="<?php echo $row['gallery_title'] ?>" required>

<div class="valid-feedback">Looks good!</div>

</div>
                                
                                <div class="form-group">

<label class="form-label">Discription</label>

<div class="valid-feedback">Looks good!</div>

</div>

<label class="form-label">Image</label>
                                    <img id="output" src="../assets/images/photo_gallery/gallery_images/<?php echo $row['gallery_image']; ?>" width="80px" height="80px"/>
                                    <input type="file" class="form-control" name="gallery_image" onchange="loadFile(event)">
                                    <input type="hidden" class="form-control" name="upload_id" value=<?php echo $super_id; ?>>

<div class="valid-feedback">Looks good!</div>

</div>

<input type="submit" class="form-control btn btn-primary" name="gallery"

value="submit">

</div>

</form>

</div>

</div>

</div>

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

function subCategory(val) {

$.ajax({

type: "POST",

url: "ajax/image_gallery_cat.php",

data: 'main_id=' + val,

success: function (data) {

document.getElementById('main').innerHTML = data;

}

});

}

</script>

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/superadmin

	.	8192
	..	4096
	ajax	104
X	error_log	2654
X	file_down_sub_edit.php	4784
X	gallery_edit_sub_photo.php	5120
X	gallery_edit_sub_video.php	5287
X	gallery_photo_edit.php	9182
X	gallery_photo_main_table.php	5070
	includes	4096
X	online_meeting_create.php	6878
X	tamilenam_setting_add.php	3984
X	tamilenam_setting_edit.php	6426