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 : addgeninfo.php

<?php

require('include/header.php');

// Initialize variables
$items = [];
$msg = '';

// Check if an ID is provided in the URL for updating
if (isset($_GET['id']) && $_GET['id'] != '') {
    $id = get_safe_value($con, $_GET['id']);
    $res = mysqli_query($con, "SELECT * FROM geninfo_items WHERE geninfo_id='$id'");
    while ($row = mysqli_fetch_assoc($res)) {
        $items[] = $row;
    }
}

// Handle form submission
if (isset($_POST['submit'])) {
    $titles = array_map(function($title) use ($con) {
        return get_safe_value($con, $title);
    }, $_POST['title']);
    
    $descriptions = array_map(function($description) use ($con) {
        return get_safe_value($con, $description);
    }, $_POST['description']);

if (isset($_GET['id']) && $_GET['id'] != '') {
        $id = get_safe_value($con, $_GET['id']);
        // Update existing record
        mysqli_query($con, "DELETE FROM geninfo_items WHERE geninfo_id='$id'");
        
        foreach ($titles as $index => $title) {
            $description = $descriptions[$index];
            mysqli_query($con, "INSERT INTO geninfo_items (geninfo_id, title, description) VALUES ('$id', '$title', '$description')");
        }
    } else {
        // Insert new record
        mysqli_query($con, "INSERT INTO geninfo (status, date_created) VALUES (1, current_timestamp())");
        $new_id = mysqli_insert_id($con);

foreach ($titles as $index => $title) {
            $description = $descriptions[$index];
            mysqli_query($con, "INSERT INTO geninfo_items (geninfo_id, title, description) VALUES ('$new_id', '$title', '$description')");
        }
    }
    echo "<script>window.location.href='geninfo.php';</script>";
    exit;
}
?>

<div class="col-lg-12">
    <div class="card">
        <div class="card-header">Edit Geninfo
            <div class="page-header float-right">
                <div class="page-title">
                    <ol class="breadcrumb text-right">
                        <li><a href="geninfo.php">List Geninfo</a></li>
                    </ol>
                </div>
            </div>
        </div>
        <div class="card-body card-block">
            <form id="geninfoForm" method="post">
                <div id="fieldsContainer">
                    <?php foreach ($items as $index => $item): ?>
                        <div class="form-group">
                            <label for="title<?php echo $index; ?>" class="form-control-label">Title <?php echo ($index + 1); ?></label>
                            <input type="text" id="title<?php echo $index; ?>" name="title[]" placeholder="Title <?php echo ($index + 1); ?>" class="form-control" value="<?php echo htmlspecialchars($item['title'], ENT_QUOTES, 'UTF-8'); ?>">
                        </div>
                        <div class="form-group">
                            <label for="description<?php echo $index; ?>" class="form-control-label">Description <?php echo ($index + 1); ?></label>
                            <textarea id="description<?php echo $index; ?>" name="description[]" class="form-control"><?php echo htmlspecialchars($item['description'], ENT_QUOTES, 'UTF-8'); ?></textarea>
                        </div>
                    <?php endforeach; ?>
                </div>
                <div class="form-group">
                    <button type="button" id="addFieldButton" class="btn btn-primary">Add More</button>
                </div>
                <div class="form-actions form-group">
                    <button type="submit" name="submit" class="btn btn-success btn-sm">Save All</button>
                </div>
            </form>
        </div>
    </div>
</div>

// Add more fields dynamically
    document.getElementById('addFieldButton').addEventListener('click', function() {
        var container = document.getElementById('fieldsContainer');
        var index = container.children.length / 2; // Since each entry has two children

// Initialize CKEditor for the new textarea
        CKEDITOR.replace(`description${index}`);
    });
});
</script>

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

${this.title}

Code Editor : addgeninfo.php