Gecko [ www.stclareschooldimapur.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
vendors	[ DIR ]	drwxr-xr-x
activitycalendar.php	9.01 KB	-rw-r--r--
add10topper.php	7.01 KB	-rw-r--r--
add12topper.php	7.01 KB	-rw-r--r--
addaboutus.php	6.13 KB	-rw-r--r--
addaward.php	4.1 KB	-rw-r--r--
addbanner.php	5.38 KB	-rw-r--r--
adddetailmessage.php	6.19 KB	-rw-r--r--
addevent.php	7.61 KB	-rw-r--r--
addfacility.php	4.2 KB	-rw-r--r--
addfeesdata.php	8.46 KB	-rw-r--r--
addfeesheading.php	6.37 KB	-rw-r--r--
addgeninfo.php	5.12 KB	-rw-r--r--
addhistory.php	4.19 KB	-rw-r--r--
addintro.php	4.15 KB	-rw-r--r--
addmissionwithdrawal.php	9.05 KB	-rw-r--r--
addmoment.php	5.41 KB	-rw-r--r--
addnotice.php	6.29 KB	-rw-r--r--
addphotogallery.php	5.44 KB	-rw-r--r--
addphotos.php	4.89 KB	-rw-r--r--
addschoolinformation.php	4.26 KB	-rw-r--r--
addvision.php	4.19 KB	-rw-r--r--
admin.php	5.24 KB	-rw-r--r--
administration.php	8.99 KB	-rw-r--r--
assesment.php	8.94 KB	-rw-r--r--
booklist.php	8.93 KB	-rw-r--r--
cocurricular.php	9.01 KB	-rw-r--r--
contactlist.php	5.53 KB	-rw-r--r--
curriculum.php	9.36 KB	-rw-r--r--
dashboard.php	40.13 KB	-rw-r--r--
editfooter.php	18.56 KB	-rw-r--r--
examination.php	8.96 KB	-rw-r--r--
find.php	4.27 KB	-rw-r--r--
geninfo.php	5.03 KB	-rw-r--r--
index.php	31.9 KB	-rw-r--r--
list10topper.php	5.68 KB	-rw-r--r--
list12topper.php	5.68 KB	-rw-r--r--
listaboutus.php	5.36 KB	-rw-r--r--
listaward.php	5.23 KB	-rw-r--r--
listbanner.php	5.35 KB	-rw-r--r--
listdetailmessage.php	5.54 KB	-rw-r--r--
listevent.php	5.77 KB	-rw-r--r--
listfacility.php	5.25 KB	-rw-r--r--
listfeesdata.php	5.57 KB	-rw-r--r--
listfeesheading.php	5.37 KB	-rw-r--r--
listhistory.php	5.25 KB	-rw-r--r--
listintro.php	5.25 KB	-rw-r--r--
listmoment.php	5.36 KB	-rw-r--r--
listnotice.php	5.57 KB	-rw-r--r--
listphotogallery.php	5.4 KB	-rw-r--r--
listphotos.php	5.58 KB	-rw-r--r--
listschoolinformation.php	5.33 KB	-rw-r--r--
listvision.php	5.24 KB	-rw-r--r--
logout.php	302 B	-rw-r--r--
profile.php	9.74 KB	-rw-r--r--
rules.php	8.94 KB	-rw-r--r--
sportcorner.php	8.9 KB	-rw-r--r--
studenttcdetails.php	5.87 KB	-rw-r--r--

Code Editor : addphotos.php

<?php

require('include/header.php');

$photogallery_id = '';
$title = '';
$msg = '';
$image_required = 'required';

if (isset($_GET['id']) && $_GET['id'] != '') {
    $image_required = '';
    $id = get_safe_value($con, $_GET['id']);
    $res = mysqli_query($con, "SELECT * FROM photo WHERE id='$id'");
    $check = mysqli_num_rows($res);
    if ($check > 0) {
        $row = mysqli_fetch_assoc($res);
        $photogallery_id = $row['photogallery_id'];
        $title = $row['title'];
    } else {
        header('Location:listphotos.php');
        die();
    }
}

if (isset($_POST['submit'])) {
    $title = get_safe_value($con, $_POST['title']);
    $photogallery_id = get_safe_value($con, $_POST['photogallery_id']);
    $msg = "";

// Image format validation
    $allowed_types = ['image/png', 'image/jpg', 'image/jpeg'];
    foreach ($_FILES['images']['type'] as $type) {
        if (!in_array($type, $allowed_types)) {
            $msg = "Please select only png, jpg, or jpeg image formats.";
            break;
        }
    }

if ($msg == '') {
        if (isset($_GET['id']) && $_GET['id'] != '') {
            // Update existing record
            $update_sql = "UPDATE photo SET photogallery_id='$photogallery_id', title='$title' WHERE id='$id'";
            mysqli_query($con, $update_sql);

// Handle file uploads
            foreach ($_FILES['images']['name'] as $key => $name) {
                if ($_FILES['images']['error'][$key] == 0) {
                    $image = rand(111111111, 999999999) . '_' . $name;
                    move_uploaded_file($_FILES['images']['tmp_name'][$key], BANNER_IMAGE_SERVER_PATH . $image);
                    mysqli_query($con, "INSERT INTO photo (photogallery_id, title, image, status, date_created) VALUES ('$photogallery_id', '$title', '$image', 1, CURRENT_TIMESTAMP())");
                }
            }
        } else {
            // Insert new records
            foreach ($_FILES['images']['name'] as $key => $name) {
                if ($_FILES['images']['error'][$key] == 0) {
                    $image = rand(111111111, 999999999) . '_' . $name;
                    move_uploaded_file($_FILES['images']['tmp_name'][$key], BANNER_IMAGE_SERVER_PATH . $image);
                    mysqli_query($con, "INSERT INTO photo (photogallery_id, title, image, status, date_created) VALUES ('$photogallery_id', '$title', '$image', 1, CURRENT_TIMESTAMP())");
                }
            }
        }

echo "<script>window.location.href='listphotos.php';</script>";
        exit;
    }
}

<div class="col-lg-12">
    <div class="card">
        <div class="card-header">
            Add Photo
            <div class="page-header float-right">
                <div class="page-title">
                    <ol class="breadcrumb text-right">
                        <li><a href="listphotos.php">List Photo</a></li>
                    </ol>
                </div>
            </div>
        </div>
        <div class="card-body card-block">
            <form method="post" enctype="multipart/form-data">
                <div class="form-group">
                    <div class='input-group'>
                        <select name="photogallery_id" class="form-control" style="height:auto;width:100px;">
                            <option>Select Gallery Title</option>
                            <?php 
                            $gallery = mysqli_query($con, "SELECT id, htitle FROM photogallery ORDER BY htitle ASC");
                            while ($gallerytitle = mysqli_fetch_assoc($gallery)) {
                                if ($gallerytitle['id'] == $photogallery_id) {
                                    echo "<option selected value=".$gallerytitle['id'].">".$gallerytitle['htitle']."</option>";
                                } else {
                                    echo "<option value=".$gallerytitle['id'].">".$gallerytitle['htitle']."</option>";
                                }
                            }
                            ?>
                        </select>
                    </div>
                </div>

<div class="form-group">
                    <label for="images" class=" form-control-label">Images</label>
                    <input type="file" name="images[]" class="form-control" multiple>
                </div>

<div class="form-actions form-group">
                    <button type="submit" name="submit" class="btn btn-success btn-sm">Submit</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

${this.title}

Code Editor : addphotos.php