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

<?php

require('include/header.php');

// Handle status change and deletion
if (isset($_GET['type']) && $_GET['type'] != '') {
    $type = get_safe_value($con, $_GET['type']);

if ($type == 'status') {
        $operation = get_safe_value($con, $_GET['operation']);
        $id = get_safe_value($con, $_GET['id']);
        $status = ($operation == 'active') ? 1 : 0;
        $update_status_sql = "UPDATE geninfo SET status='$status' WHERE id='$id'";
        mysqli_query($con, $update_status_sql);
    }

if ($type == 'delete') {
        $id = get_safe_value($con, $_GET['id']);
        $delete_sql = "DELETE FROM geninfo WHERE id='$id'";
        mysqli_query($con, $delete_sql);
        mysqli_query($con, "DELETE FROM geninfo_items WHERE geninfo_id='$id'");
    }
}

// Fetch all records from geninfo table with corresponding items
$sql = "
    SELECT g.id, g.status, g.date_created, i.title AS item_title, i.description AS item_description
    FROM geninfo g
    LEFT JOIN geninfo_items i ON g.id = i.geninfo_id
    ORDER BY g.id ASC
";
$res = mysqli_query($con, $sql);

<div class="breadcrumbs">
    <div class="col-sm-4">
        <div class="page-header float-left">
            <div class="page-title">
                <h1>Geninfo List</h1>
            </div>
        </div>
    </div>
    <div class="col-sm-8">
        <div class="page-header float-right">
            <div class="page-title">
                <ol class="breadcrumb text-right">
                    <li><a href="addgeninfo.php">Add Geninfo</a></li>
                </ol>
            </div>
        </div>
    </div>
</div>

<div class="content mt-3">
    <div class="animated fadeIn">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header">
                        <strong class="card-title">Geninfo List</strong>
                    </div>
                    <div class="card-body">
                        <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th class="serial">#</th>
                                    <th>Status</th>
                                    <th>Date Created</th>
                                    <th>Item Title</th>
                                    <th>Item Description</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $current_geninfo_id = null;
                                $i = 1;

while ($row = mysqli_fetch_assoc($res)) {
                                    if ($current_geninfo_id != $row['id']) {
                                        if ($current_geninfo_id !== null) {
                                            echo "</tr>";
                                        }
                                        $current_geninfo_id = $row['id'];
                                        echo "<tr>";
                                        echo "<td class='serial'>{$i}</td>";
                                        echo "<td>" . ($row['status'] == 1 ? "Active" : "Inactive") . "</td>";
                                        echo "<td>{$row['date_created']}</td>";
                                        echo "<td>{$row['item_title']}</td>";
                                        echo "<td>{$row['item_description']}</td>";
                                        echo "<td>";
                                        echo "<span class='badge badge-edit'><a href='addgeninfo.php?id={$row['id']}'>Edit</a></span> ";
                                        echo "<span class='badge badge-delete'><a href='?type=delete&id={$row['id']}'>Delete</a></span>";
                                        echo "</td>";
                                        echo "</tr>";
                                        $i++;
                                    } else {
                                        echo "<tr>";
                                        echo "<td></td>";
                                        echo "<td></td>";
                                        echo "<td></td>";
                                        echo "<td>{$row['item_title']}</td>";
                                        echo "<td>{$row['item_description']}</td>";
                                        echo "<td></td>";
                                        echo "</tr>";
                                    }
                                }

if ($current_geninfo_id !== null) {
                                    echo "</tr>";
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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

${this.title}

Code Editor : geninfo.php