function updateTable() {
global $connection;
$username = $_POST['username'];
$password = $_POST['password'];
$id = $_POST['id'];
$query = "UPDATE users SET ";
$query .= "username = '$username', ";
$query .= "password = '$password' ";
$query .= "WHERE id = $id ";
$result = mysqli_query($connection, $query);
if (!$result) {
die("Query Failed" . mysqli_error($connection));
}
}
// HTML FILE
<?php
if(isset($_POST['submit'])){
updateTable();
}
?>
<form action="update.php" method="post">
<select name="id" id="">
<?php
showAllData();
?>
</select>
<input type="text" name="username">
<input type="password" name="password">
<button type="submit" name="submit">Update</button>
</form>