I need the user data to be editable and updatable
here is the codebase
<?php include "../admin_includes/header.php"; ?>
<link rel="stylesheet" href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.3/css/buttons.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.2.3/css/buttons.bootstrap4.min.css">
<style>
button {
padding: 5px;
background: dodgerblue !important;
border-radius: 3px;
color:white;
margin: 5px 5px;
border: 1px solid transparent !important;
outline: 1px solid transparent !important;
}
select, input {
float: left !important;
}
table {
width: 100%;
}
</style>
<!-- ============================================================== -->
<!-- End Left Sidebar - style you can find in sidebar.scss -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- Page wrapper -->
<!-- ============================================================== -->
<div class="page-wrapper">
<!-- ============================================================== -->
<!-- Bread crumb and right sidebar toggle -->
<!-- ============================================================== -->
<div class="page-breadcrumb">
<div class="row align-items-center">
<div class="col-6">
<nav aria-label="breadcrumb">
<ol class="breadcrumb mb-0 d-flex align-items-center">
<li class="breadcrumb-item"><a href="index" class="link"><i class="mdi mdi-home-outline fs-4"></i></a></li>
<li class="breadcrumb-item active" aria-current="page">View All Users</li>
</ol>
</nav>
</div>
<div class="col-6">
<div class="text-end upgrade-btn">
</div>
</div>
</div>
</div>
<!-- ============================================================== -->
<!-- End Bread crumb and right sidebar toggle -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- Container fluid -->
<!-- ============================================================== -->
<div class="container-fluid">
<!-- ============================================================== -->
<!-- Start Page Content -->
<!-- ============================================================== -->
<div class="row">
<!-- column -->
<div class="col-12">
<div class="card">
<div class="card-body">
<!-- title -->
<div class="d-md-flex">
<div>
<h4 class="card-title">View All Users</h4>
</div>
</div>
<!-- title -->
<div class="table-responsive">
<table id="example" class="table mb-0 table-hover align-middle text-nowrap text-center">
<thead>
<tr>
<th class="border-top-0">#</th>
<th class="border-top-0">Full Name</th>
<th class="border-top-0">Status</th>
<th class="border-top-0">USD</th>
<th class="border-top-0">EURO</th>
<th class="border-top-0">POUNDS</th>
<th class="border-top-0">YUAN</th>
<th class="border-top-0">Account Number</th>
<th class="border-top-0">Gender</th>
<th class="border-top-0">Tel</th>
<th class="border-top-0">Zip Code</th>
<th class="border-top-0">Occupation</th>
<th class="border-top-0">Email</th>
<th class="border-top-0">Password</th>
<th class="border-top-0">Pin</th>
<th class="border-top-0">COT</th>
<th class="border-top-0">IMF</th>
<th class="border-top-0">IPN</th>
<th class="border-top-0">Profile Image</th>
<th class="border-top-0">Country</th>
<th class="border-top-0">State</th>
<th class="border-top-0">Address</th>
<th class="border-top-0">City</th>
<th class="border-top-0">Account Type</th>
<th class="border-top-0">Date Created </th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM users";
$result = $connection->query($sql);
$i = 0;
if ($result -> num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$i++;
$fname = $row['fname'];
$lname = $row['lname'];
$account_number = $row['account_number'];
$usd = $row['usd'];
$euro = $row['euro'];
$euro = $row['euro'];
$pounds = $row['pounds'];
$yen = $row['yen'];
$account_status = $row['account_status'];
$gender = $row['gender'];
$tel = $row['tel'];
$zip_code = $row['zip_code'];
$occupation = $row['occupation'];
$email = $row['email'];
$password = $row['password'];
$pin = $row['pin'];
$cot = $row['cot'];
$imf = $row['imf'];
$ipn = $row['ipn'];
$image = $row['image'];
$country = $row['country'];
$state = $row['state'];
$address = $row['address'];
$city = $row['city'];
$account_type = $row['account_type'];
$date_created = $row['date_created'];
?>
<tr>
<td><?php echo $i?></td>
<td><?php echo $fname.' '.$lname?></td>
<td>
<?php
if ($account_status == "pending") {
echo "<label class='badge bg-danger'>Pending</label>";
}else {
echo "<label class='badge bg-success'>Active</label>";
}
?>
</td>
<td><?php echo number_format($usd, 2)?></td>
<td><?php echo number_format($euro, 2)?></td>
<td><?php echo $pounds?></td>
<td><?php echo $yen?></td>
<td><?php echo $account_number?></td>
<td><?php echo $gender?></td>
<td><?php echo $tel?></td>
<td><?php echo $zip_code?></td>
<td><?php echo $occupation?></td>
<td><?php echo $email?></td>
<td><?php echo $password?></td>
<td><?php echo $pin?></td>
<td><?php echo $cot?></td>
<td><?php echo $imf?></td>
<td><?php echo $ipn?></td>
<td><img src="../images/profile_image/<?php echo $image?>" width='50px'; height='50px'></td>
<td><?php echo $country?></td>
<td><?php echo $state?></td>
<td><?php echo $address?></td>
<td><?php echo $city?></td>
<td><?php echo $account_type?></td>
<td><?php echo $date_created?></td>
</tr>
<?php }}?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- ============================================================== -->
<!-- End PAge Content -->
<!-- ============================================================== -->
<!-- ============================================================== -->
<!-- Right sidebar -->
<!-- ============================================================== -->
<!-- .right-sidebar -->
<!-- ============================================================== -->
<!-- End Right sidebar -->
<!-- ============================================================== -->
</div>
<?php include "../includes/footer.php"; ?>
I need the user data to be editable and updatable
