File Manager

✏️ Edit File: /home/u229881858/domains/sataksa.com/public_html/admin/manage_messages.php

<?php
session_start();
include '../db.php';
if(!isset($_SESSION['admin'])) { header("Location: index.php"); exit();}
$msg = "";
// 1. ADD MESSAGE లాజిక్[span_1](end_span)
if(isset($_POST['add_msg'])) {
    $name = mysqli_real_escape_string($conn, $_POST['name']);
    $role = mysqli_real_escape_string($conn, $_POST['role']);
    $message = mysqli_real_escape_string($conn, $_POST['message']);
    $category = $_POST['category'];
    
    $db_photo = "";
    if(!empty($_FILES['photo']['name'])) {
        $target = "../images/uploads/" . time() . "_" . basename($_FILES['photo']['name']);
        if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) {
            $db_photo = "images/uploads/" . str_replace("../images/uploads/", "", $target);
        }
    }

$sql = "INSERT INTO leadership_messages (name, role, message, category, photo_path) VALUES ('$name', '$role', '$message', '$category', '$db_photo')";
    if($conn->query($sql)) { 
        $msg = "<div class='alert alert-success'>Message Added Successfully!</div>"; 
    }
}

// 2. UPDATE MESSAGE లాజిక్ (కొత్తగా జోడించింది)
if(isset($_POST['update_msg'])) {
    $id = $_POST['id'];
    $name = mysqli_real_escape_string($conn, $_POST['name']);
    $role = mysqli_real_escape_string($conn, $_POST['role']);
    $message = mysqli_real_escape_string($conn, $_POST['message']);
    $category = $_POST['category'];
    $old_photo = $_POST['old_photo'];

$db_photo = $old_photo; 
    if(!empty($_FILES['photo']['name'])) {
        $target = "../images/uploads/" . time() . "_" . basename($_FILES['photo']['name']);
        if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) {
            $db_photo = "images/uploads/" . str_replace("../images/uploads/", "", $target);
        }
    }

$update_sql = "UPDATE leadership_messages SET name='$name', role='$role', message='$message', category='$category', photo_path='$db_photo' WHERE id=$id";
    if($conn->query($update_sql)) {
        echo "<script>window.location.href='manage_messages.php?status=updated';</script>";
        exit();
    }
}

// 3. DELETE లాజిక్[span_2](end_span)
if(isset($_GET['del'])) {
    $id = $_GET['del'];
    $conn->query("DELETE FROM leadership_messages WHERE id=$id");
    header("Location: manage_messages.php");
    exit();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Manage Messages</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body class="bg-light">
<div class="container mt-5">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h2>Manage Leadership Messages</h2>
        <a href="dashboard.php" class="btn btn-secondary">&larr; Back to Dashboard</a>
    </div>
    
    <?php if(isset($_GET['status']) && $_GET['status'] == 'updated') echo "<div class='alert alert-info'>Message Updated Successfully!</div>"; ?>
    <?php echo $msg; ?>

<div class="row">
        <div class="col-md-4">
            <div class="card shadow-sm border-0">
                <div class="card-header bg-primary text-white fw-bold">Add New Message</div>
                <div class="card-body">
                    <form method="post" enctype="multipart/form-data">
                        <div class="mb-3"><label class="form-label">Name</label><input type="text" name="name" class="form-control" required></div>
                        <div class="mb-3"><label class="form-label">Role</label><input type="text" name="role" class="form-control" placeholder="e.g. Founder" required></div>
                        <div class="mb-3"><label class="form-label">Message</label><textarea name="message" class="form-control" rows="4" required></textarea></div>
                        <div class="mb-3">
                            <label class="form-label">Category</label>
                            <select name="category" class="form-select">
                                <option value="founder">Founder Message</option>
                                <option value="committee">Committee Message</option>
                            </select>
                        </div>
                        <div class="mb-3"><label class="form-label">Photo</label><input type="file" name="photo" class="form-control" required></div>
                        <button type="submit" name="add_msg" class="btn btn-success w-100">Add Message</button>
                    </form>
                </div>
            </div>
        </div>

<div class="col-md-8">
            <div class="card shadow-sm border-0">
                <div class="card-header bg-dark text-white fw-bold">Existing Messages</div>
                <div class="card-body p-0">
                    <div class="table-responsive">
                        <table class="table table-hover align-middle mb-0">
                            <thead class="table-light">
                                <tr>
                                    <th>Photo</th>
                                    <th>Info</th>
                                    <th>Category</th>
                                    <th class="text-center">Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $res = $conn->query("SELECT * FROM leadership_messages ORDER BY id DESC");
                                while($row = $res->fetch_assoc()) {
                                ?>
                                    <tr>
                                        <td><img src="../<?php echo $row['photo_path']; ?>" width="50" height="50" class="rounded-circle object-fit-cover"></td>
                                        <td>
                                            <strong><?php echo $row['name']; ?></strong><br>
                                            <small class="text-muted"><?php echo $row['role']; ?></small>
                                        </td>
                                        <td><span class="badge bg-info text-dark"><?php echo ucfirst($row['category']); ?></span></td>
                                        <td class="text-center">
                                            <button class="btn btn-sm btn-warning me-1" data-bs-toggle="modal" data-bs-target="#editModal<?php echo $row['id']; ?>">Edit</button>
                                            <a href="?del=<?php echo $row['id']; ?>" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure you want to delete this?')">Del</a>
                                        </td>
                                    </tr>

<div class="modal fade" id="editModal<?php echo $row['id']; ?>" tabindex="-1" aria-hidden="true">
                                        <div class="modal-dialog">
                                            <div class="modal-content">
                                                <form method="post" enctype="multipart/form-data">
                                                    <div class="modal-header">
                                                        <h5 class="modal-title">Edit Message Details</h5>
                                                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                                                    </div>
                                                    <div class="modal-body">
                                                        <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                                                        <input type="hidden" name="old_photo" value="<?php echo $row['photo_path']; ?>">
                                                        
                                                        <div class="mb-3"><label class="form-label">Name</label><input type="text" name="name" value="<?php echo htmlspecialchars($row['name']); ?>" class="form-control" required></div>
                                                        <div class="mb-3"><label class="form-label">Role</label><input type="text" name="role" value="<?php echo htmlspecialchars($row['role']); ?>" class="form-control" required></div>
                                                        <div class="mb-3"><label class="form-label">Message</label><textarea name="message" class="form-control" rows="5" required><?php echo htmlspecialchars($row['message']); ?></textarea></div>
                                                        <div class="mb-3">
                                                            <label class="form-label">Category</label>
                                                            <select name="category" class="form-select">
                                                                <option value="founder" <?php if($row['category']=='founder') echo 'selected'; ?>>Founder Message</option>
                                                                <option value="committee" <?php if($row['category']=='committee') echo 'selected'; ?>>Committee Message</option>
                                                            </select>
                                                        </div>
                                                        <div class="mb-3">
                                                            <label class="form-label">Photo (Leave blank to keep current)</label>
                                                            <input type="file" name="photo" class="form-control">
                                                            <small class="text-muted">Current: <?php echo $row['photo_path']; ?></small>
                                                        </div>
                                                    </div>
                                                    <div class="modal-footer">
                                                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                                                        <button type="submit" name="update_msg" class="btn btn-primary">Update Message</button>
                                                    </div>
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                <?php } ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

Batal

⬅ Naik ke public_html 13 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘dashboard.php	php	9.5 KB	2026-02-18 16:29	✏️ Edit 👁️ View
🐘event_manager.php	php	7.2 KB	2026-01-06 13:22	✏️ Edit 👁️ View
🐘index.php	php	1.4 KB	2026-01-04 14:46	✏️ Edit 👁️ View
🐘logout.php	php	383 B	2026-01-05 02:33	✏️ Edit 👁️ View
🐘manage_extras.php	php	12.4 KB	2026-01-05 02:22	✏️ Edit 👁️ View
🐘manage_medical.php	php	7.3 KB	2026-01-06 13:59	✏️ Edit 👁️ View
🐘manage_messages.php	php	10.7 KB	2026-02-22 17:53	✏️ Edit 👁️ View
🐘members.php	php	2.7 KB	2026-01-04 14:47	✏️ Edit 👁️ View
🐘news.php	php	6 KB	2026-01-06 09:50	✏️ Edit 👁️ View
🐘photos.php	php	8.1 KB	2026-02-18 15:57	✏️ Edit 👁️ View
🐘registrations.php	php	4.3 KB	2026-01-06 14:32	✏️ Edit 👁️ View
🐘settings.php	php	9.1 KB	2026-01-04 16:22	✏️ Edit 👁️ View
🐘slider.php	php	3 KB	2026-01-04 15:27	✏️ Edit 👁️ View