Fnetstech

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