Preview: footer-changes.php
Size: 3.14 KB
/home/serveshikshafoundation/htdocs/serveshikshafoundation.org.in/admin/html/footer-changes.php
<?php
// ---------- PHP SECTION ----------
include 'auth.php';
include 'connection.php';
/* ---------------------------------
1. FETCH EXISTING ROW (id = 1)
----------------------------------*/
$id = 1;
$selectSql = "SELECT * FROM footer_content WHERE id = ?";
$selectStmt = mysqli_prepare($conn, $selectSql);
mysqli_stmt_bind_param($selectStmt, "i", $id);
mysqli_stmt_execute($selectStmt);
$result = mysqli_stmt_get_result($selectStmt);
$data = mysqli_fetch_assoc($result) ?: ['about_us' => '', 'branch1' => '']; // fallback
/* ---------------------------------
2. HANDLE FORM SUBMISSION
----------------------------------*/
if ($_SERVER["REQUEST_METHOD"] === "POST") {
$about_us = $_POST['about_us'] ?? '';
$branch1 = $_POST['branch1'] ?? '';
$updateSql = "UPDATE footer_content
SET about_us = ?, branch1 = ?
WHERE id = 1";
$updateStmt = mysqli_prepare($conn, $updateSql);
mysqli_stmt_bind_param($updateStmt, "ss", $about_us, $branch1);
if (mysqli_stmt_execute($updateStmt)) {
echo "<script>alert('Content updated successfully!');
window.location.href='footer-changes.php';</script>";
exit;
} else {
echo "<script>alert('Error updating content!');</script>";
}
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Admin</title>
<link rel="shortcut icon" type="image/png" href="../assets/images/logos/favicon.png">
<link rel="stylesheet" href="../assets/css/styles.min.css">
</head>
<body>
<div class="page-wrapper" id="main-wrapper" data-layout="vertical"
data-navbarbg="skin6" data-sidebartype="full"
data-sidebar-position="fixed" data-header-position="fixed">
<!-- Sidebar -->
<?php include 'aside.php'; ?>
<div class="body-wrapper">
<!-- Header -->
<?php include 'header.php'; ?>
<div class="container-fluid mt-5">
<h2 class="mb-4">Update Website Content</h2>
<!-- ---------- FORM ---------- -->
<form action="" method="post">
<!-- About Us -->
<div class="mb-3">
<label class="form-label">About Us</label>
<textarea class="form-control" name="about_us" rows="3"
required><?= htmlspecialchars($data['about_us']) ?></textarea>
</div>
<!-- Branch 1 Address -->
<div class="mb-3">
<label class="form-label">Branch 1 Address</label>
<input type="text" class="form-control" name="branch1"
value="<?= htmlspecialchars($data['branch1']) ?>" required>
</div>
<button type="submit" class="btn btn-primary">Update Content</button>
</form>
</div>
</div>
</div>
<script src="../assets/libs/jquery/dist/jquery.min.js"></script>
<script src="../assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
<script src="../assets/js/sidebarmenu.js"></script>
<script src="../assets/js/app.min.js"></script>
<script src="../assets/libs/simplebar/dist/simplebar.js"></script>
</body>
</html>
Directory Contents
Dirs: 11 × Files: 30