php-data-management/edit_type.php at main · jadofils/php-data-management · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
<?php
include('includes/config.php');

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

$response = array('success' => false, 'message' => '');

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $membershipType = $_POST['membershipType'];
    $membershipAmount = $_POST['membershipAmount'];

    $id = $_POST['edit_id'];

    $updateQuery = "UPDATE membership_types SET type = '$membershipType', amount = $membershipAmount WHERE id = $id";

    if ($conn->query($updateQuery) === TRUE) {
        $response['success'] = true;
        $response['message'] = 'Membership type updated successfully!';
    } else {
        $response['message'] = 'Error: ' . $conn->error;
    }
}

$edit_id = $_GET['id'] ?? null;
$editQuery = "SELECT * FROM membership_types WHERE id = $edit_id";
$result = $conn->query($editQuery);
$editData = $result->fetch_assoc();
?>

<?php include('includes/header.php');?>

<body class="hold-transition sidebar-mini layout-fixed layout-navbar-fixed layout-footer-fixed">
<div class="wrapper">
  <?php include('includes/nav.php');?>

 <?php include('includes/sidebar.php');?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">

  <?php include('includes/pagetitle.php');?>

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <div class="row">
          <div class="col-md-12">

            <?php if ($response['success']): ?>
                <div class="alert alert-success alert-dismissible">
                    <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                    <h5><i class="icon fas fa-check"></i> Success</h5>
                    <?php echo $response['message']; ?>
                </div>
            <?php elseif (!empty($response['message'])): ?>
                <div class="alert alert-danger alert-dismissible">
                    <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
                    <h5><i class="icon fas fa-ban"></i> Error</h5>
                    <?php echo $response['message']; ?>
                </div>
            <?php endif; ?>

            <div class="card card-primary">
              <div class="card-header">
                <h3 class="card-title"><i class="fas fa-keyboard"></i> Edit Membership Type</h3>
              </div>

              <form method="post" action="">
                <input type="hidden" name="edit_id" value="<?php echo $edit_id; ?>">

                <div class="card-body">
                  <div class="row">
                    <div class="col-sm-6">
                      <label for="membershipType">Membership Type</label>
                      <input type="text" class="form-control" id="membershipType" name="membershipType" placeholder="Enter membership type" value="<?php echo $editData['type']; ?>" required>
                    </div>
                    <div class="col-sm-6">
                      <label for="membershipAmount">Amount</label>
                      <input type="number" class="form-control" id="membershipAmount" name="membershipAmount" placeholder="Enter membership type amount" value="<?php echo $editData['amount']; ?>" required>
                    </div>
                  </div><!-- Visit codeastro.com for more projects -->
                </div>

                <div class="card-footer">
                  <button type="submit" class="btn btn-primary">Update</button>
                </div>
              </form>
            </div>
          </div>
        </div>
      </div>
    </section>
  </div>
  <!-- /.content-wrapper -->

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->

  <!-- Main Footer -->
  <footer class="main-footer">
    <strong> &copy; <?php echo date('Y');?> codeastro.com</a> -</strong>
    All rights reserved.
    <div class="float-right d-none d-sm-inline-block">
      <b>Developed By</b> <a href="https://codeastro.com/">CodeAstro</a>
    </div>
  </footer>
</div>
<!-- ./wrapper -->

<?php include('includes/footer.php');?>
</body>
</html>