📁 File Manager

Dosya Düzenle: hs_personal_details.php

<?php
session_start();
require 'connect.php';

if (!isset($_SESSION['c_roll'])) {
    header("Location: hs_student_login.php");
    exit;
}

$message = "";

// Fetch existing data if any
$stmt = $con->prepare("SELECT * FROM hs_personal_details WHERE collegeroll = ?");
$stmt->bind_param("s", $_SESSION['c_roll']);
$stmt->execute();
$result = $stmt->get_result();
$existing = $result->fetch_assoc();
$stmt->close();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $mobile = $_POST['mobile'];
    $email = $_POST['email'];
    $fathername = $_POST['fathername'];
    $mothername = $_POST['mothername'];
    $guardian = $_POST['guardian'];
    $gender = $_POST['gender'];
    $caste = $_POST['caste'];

// Combine address fields into one string
    $address = "Vill: " . $_POST['village'] .
               ", PO: " . $_POST['po'] .
               ", PS: " . $_POST['ps'] .
               ", Dist: " . $_POST['district'];

if ($existing) {
        // Update existing record
        $stmt = $con->prepare("UPDATE hs_personal_details 
            SET Mobile=?, email=?, fathername=?, mothername=?, guardian=?, gender=?, caste=?, address=? 
            WHERE collegeroll=?");
        $stmt->bind_param("sssssssss", $mobile, $email, $fathername, $mothername, $guardian, $gender, $caste, $address, $_SESSION['c_roll']);
        if ($stmt->execute()) {
            $message = "✅ Details updated successfully!";
        } else {
            $message = "❌ Error: " . $stmt->error;
        }
        $stmt->close();
    } else {
        // Insert new record
        $stmt = $con->prepare("INSERT INTO hs_personal_details (Mobile, email, collegeroll, fathername, mothername, guardian, gender, caste, address) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("sssssssss", $mobile, $email, $_SESSION['c_roll'], $fathername, $mothername, $guardian, $gender, $caste, $address);
        if ($stmt->execute()) {
            $message = "✅ Details submitted successfully!";
        } else {
            $message = "❌ Error: " . $stmt->error;
        }
        $stmt->close();
    }

// Refresh existing data after save
    $stmt = $con->prepare("SELECT * FROM hs_personal_details WHERE collegeroll = ?");
    $stmt->bind_param("s", $_SESSION['c_roll']);
    $stmt->execute();
    $existing = $stmt->get_result()->fetch_assoc();
    $stmt->close();
}
?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>Enter Personal Details</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
    <style>
        body {
            background: linear-gradient(135deg, #6dd5ed, #2193b0);
            min-height: 100vh;
            display: flex;
            align-items: flex-start;
            padding-top: 40px;
            font-family: 'Segoe UI', sans-serif;
        }
        .card {
            border-radius: 15px;
            overflow: hidden;
            box-shadow: 0 8px 25px rgba(0,0,0,0.2);
        }
        .card-header {
            font-size: 1.4rem;
            font-weight: bold;
            text-align: center;
        }
        .form-control {
            border-radius: 25px;
        }
        textarea.form-control {
            border-radius: 15px;
        }
        .btn-success {
            border-radius: 25px;
            background: linear-gradient(45deg, #28a745, #218838);
            border: none;
        }
        .btn-success:hover {
            background: linear-gradient(45deg, #218838, #1e7e34);
        }
    </style>
</head>
<body>

<div class="container">
    <h4 class="text-white mb-4">Welcome, <?= htmlspecialchars($_SESSION['student_name']) ?></h4>

<?php if ($message): ?>
        <div class="alert alert-info"><?= htmlspecialchars($message) ?></div>
    <?php endif; ?>

<div class="card">
        <div class="card-header bg-success text-white">📋  HS students Personal Details Form</div>
        <div class="card-body p-4">
            <form method="POST">
                <div class="form-row">
                    <div class="form-group col-md-6">
                        <label>Mobile (Active)</label>
                        <input type="text" name="mobile" class="form-control" value="<?= htmlspecialchars($existing['Mobile'] ?? '') ?>" required>
                    </div>
                    <div class="form-group col-md-6">
                        <label>Email</label>
                        <input type="email" name="email" class="form-control" value="<?= htmlspecialchars($existing['email'] ?? '') ?>">
                    </div>
                </div>
                <div class="form-row">
                    <div class="form-group col-md-4">
                        <label>Father's Name</label>
                        <input type="text" name="fathername" class="form-control" value="<?= htmlspecialchars($existing['fathername'] ?? '') ?>">
                    </div>
                    <div class="form-group col-md-4">
                        <label>Mother's Name</label>
                        <input type="text" name="mothername" class="form-control" value="<?= htmlspecialchars($existing['mothername'] ?? '') ?>">
                    </div>
                    <div class="form-group col-md-4">
                        <label>Guardian</label>
                        <input type="text" name="guardian" class="form-control" value="<?= htmlspecialchars($existing['guardian'] ?? '') ?>">
                    </div>
                </div>
                <div class="form-row">
                    <div class="form-group col-md-4">
                        <label>Gender</label>
                        <select name="gender" class="form-control">
                            <option value="">-- Select --</option>
                            <option <?= (isset($existing['gender']) && $existing['gender'] == 'Male') ? 'selected' : '' ?>>Male</option>
                            <option <?= (isset($existing['gender']) && $existing['gender'] == 'Female') ? 'selected' : '' ?>>Female</option>
                            <option <?= (isset($existing['gender']) && $existing['gender'] == 'Other') ? 'selected' : '' ?>>Other</option>
                        </select>
                    </div>
                    <div class="form-group col-md-4">
                        <label>Caste</label>
                        <input type="text" name="caste" class="form-control" value="<?= htmlspecialchars($existing['caste'] ?? '') ?>">
                    </div>
                </div>
                <hr>
                <h5>🏠 Address</h5>
                <?php
                // Extract address parts if exists
                $village = $po = $ps = $district = '';
                if (!empty($existing['address'])) {
                    preg_match('/Vill:\s*(.*?),\s*PO:\s*(.*?),\s*PS:\s*(.*?),\s*Dist:\s*(.*)/', $existing['address'], $matches);
                    if ($matches) {
                        $village = $matches[1] ?? '';
                        $po = $matches[2] ?? '';
                        $ps = $matches[3] ?? '';
                        $district = $matches[4] ?? '';
                    }
                }
                ?>
                <div class="form-row">
                    <div class="form-group col-md-3">
                        <label>Village</label>
                        <input type="text" name="village" class="form-control" value="<?= htmlspecialchars($village) ?>">
                    </div>
                    <div class="form-group col-md-3">
                        <label>Post Office (PO)</label>
                        <input type="text" name="po" class="form-control" value="<?= htmlspecialchars($po) ?>">
                    </div>
                    <div class="form-group col-md-3">
                        <label>Police Station (PS)</label>
                        <input type="text" name="ps" class="form-control" value="<?= htmlspecialchars($ps) ?>">
                    </div>
                    <div class="form-group col-md-3">
                        <label>District</label>
                        <input type="text" name="district" class="form-control" value="<?= htmlspecialchars($district) ?>">
                    </div>
                </div>
                <button type="submit" class="btn btn-success btn-block mt-3"><?= $existing ? 'Update Details' : 'Submit Details' ?></button>
            </form>
        </div>
    </div>
</div>

</body>
</html>

İptal