bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg

hjkhhrterwefdgdfgdfgdfgdgdfgdfgdsvstertrt bnmbertsdfsdfgdfgdfgfffdgdfgdfgrtdfg

<?php
session_start();
if (!isset($_SESSION['loginid']) && !isset($_SESSION['UserName'])) {
    header("Location:index.php");
    exit;
}
include("leftmenu.php");
include("db.php");

// Initialize variables
$id = $name = $gender = $dob = $fname = $bloodgroup = $edu = $aadhar = $mobile = $email = $address = $town = $pincode = $taluk = $amount = $district = "";
$edit = false;

// Fetch existing data for edit
if (isset($_GET['id']) && $_GET['action'] == 'Edit') {
    $id = intval($_GET['id']);
    $sql = "SELECT * FROM users WHERE id=$id LIMIT 1";
    $res = mysqli_query($db, $sql);
    if ($res && mysqli_num_rows($res) > 0) {
        $row = mysqli_fetch_assoc($res);
        extract($row); // assigns variables from array keys
        $edit = true;
    }
}

// Handle form submission
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Get and sanitize inputs
    $id = intval($_POST['id']);
    $name = mysqli_real_escape_string($db, $_POST['name']);
    $gender = $_POST['gender'];
    $dob = $_POST['dob'];
    $fname = mysqli_real_escape_string($db, $_POST['fname']);
    $bloodgroup = $_POST['bloodgroup'];
    $edu = mysqli_real_escape_string($db, $_POST['edu']);
    $aadhar = mysqli_real_escape_string($db, $_POST['aadhar']);
    $mobile = mysqli_real_escape_string($db, $_POST['mobile']);
    $email = mysqli_real_escape_string($db, $_POST['email']);
    $address = mysqli_real_escape_string($db, $_POST['address']);
    $town = mysqli_real_escape_string($db, $_POST['town']);
    $pincode = mysqli_real_escape_string($db, $_POST['pincode']);
    $taluk = mysqli_real_escape_string($db, $_POST['taluk']);
    $amount = mysqli_real_escape_string($db, $_POST['amount']);
    $district = mysqli_real_escape_string($db, $_POST['district']);

if ($id > 0) {
        // Update existing user
        $sql = "UPDATE users SET 
                  name='$name', gender='$gender', dob='$dob', fname='$fname',
                  bloodgroup='$bloodgroup', edu='$edu', aadhar='$aadhar',
                  mobile='$mobile', email='$email', address='$address',
                  town='$town', pincode='$pincode', taluk='$taluk',
                  amount='$amount', district='$district'
                WHERE id=$id";
    } else {
        // Insert new user
        $sql = "INSERT INTO users (
                  name, gender, dob, fname, bloodgroup, edu, aadhar,
                  mobile, email, address, town, pincode, taluk,
                  amount, district, status
                ) VALUES (
                  '$name', '$gender', '$dob', '$fname', '$bloodgroup', '$edu', '$aadhar',
                  '$mobile', '$email', '$address', '$town', '$pincode', '$taluk',
                  '$amount', '$district', 1
                )";
    }

if (mysqli_query($db, $sql)) {
        echo "<script>alert('User saved successfully');window.location='view-members.php';</script>";
        exit;
    } else {
        echo "<script>alert('Database error');</script>";
    }
}
?>

<div class="content-wrapper">
  <section class="content-header">
    <div class="container-fluid">
      <h1><?php echo $edit ? 'Edit' : 'Add'; ?> User</h1>
    </div>
  </section>

<div class="form-group col-lg-6 col-md-6">
              <label for="name">Name</label>
              <input type="text" name="name" id="name" class="form-control" value="<?php echo $name; ?>" required>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="gender">Gender</label>
              <select name="gender" id="gender" class="form-control" required>
                <option value="">Select Gender</option>
                <option value="ஆண்" <?php if ($gender == 'ஆண்') echo 'selected'; ?>>ஆண்</option>
                <option value="பெண்" <?php if ($gender == 'பெண்') echo 'selected'; ?>>பெண்</option>
                <option value="மூன்றாம் பாலினம்" <?php if ($gender == 'மூன்றாம் பாலினம்') echo 'selected'; ?>>மூன்றாம் பாலினம்</option>
              </select>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="dob">Date of Birth</label>
              <input type="date" name="dob" id="dob" class="form-control" value="<?php echo $dob; ?>" required>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="fname">Father's Name</label>
              <input type="text" name="fname" id="fname" class="form-control" value="<?php echo $fname; ?>" required>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="aadhar">Aadhar</label>
              <input type="text" name="aadhar" id="aadhar" class="form-control" value="<?php echo $aadhar; ?>" required>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="mobile">Mobile</label>
              <input type="text" name="mobile" id="mobile" class="form-control" value="<?php echo $mobile; ?>" required>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="email">Email</label>
              <input type="email" name="email" id="email" class="form-control" value="<?php echo $email; ?>">
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="bloodgroup">Blood Group</label>
              <select name="bloodgroup" id="bloodgroup" class="form-control">
                <option value="">Select</option>
                <?php 
                  $groups = ['A+','A-','B+','B-','O+','O-','AB+','AB-'];
                  foreach ($groups as $group) {
                    $selected = ($bloodgroup == $group) ? 'selected' : '';
                    echo "<option value=\"$group\" $selected>$group</option>";
                  }
                ?>
              </select>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="edu">Education</label>
              <input type="text" name="edu" id="edu" class="form-control" value="<?php echo $edu; ?>">
            </div>

<div class="form-group col-lg-12">
              <label for="address">Address</label>
              <textarea name="address" id="address" class="form-control"><?php echo $address; ?></textarea>
            </div>

<div class="form-group col-lg-4 col-md-6">
              <label for="pincode">Pincode</label>
              <input type="text" name="pincode" id="pincode" class="form-control" value="<?php echo $pincode; ?>">
            </div>

<div class="form-group col-lg-4 col-md-6">
              <label for="taluk">Taluk</label>
              <input type="text" name="taluk" id="taluk" class="form-control" value="<?php echo $taluk; ?>">
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="district">District</label>
              <input type="text" name="district" id="district" class="form-control" value="<?php echo $district; ?>" required>
            </div>

<div class="form-group col-lg-6 col-md-6">
              <label for="amount">Amount</label>
              <input type="text" name="amount" id="amount" class="form-control" value="<?php echo $amount; ?>" required>
            </div>
          </div>
        </div>
        <div class="card-footer">
          <button type="submit" class="btn btn-primary">Save</button>
          <a href="users.php" class="btn btn-secondary">Cancel</a>
        </div>
      </div>
    </form>
  </section>
</div>
<?php
include("footer.php");
?>
<script>
$('#success_message').fadeIn().html();
    setTimeout(function() {
  $('#success_message').fadeOut("slow");
}, 3000 );
</script>