<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Edit address</title>
</head>
<body>
<form action="edit-address.php" method="post">
<fieldset>
<label for="id">
Id
</label>
<input type="text" name="id" id="id" />
</fieldset>
<fieldset>
<label for="street">
Rue
</label>
<input type="text" name="street" id="street" />
</fieldset>
<fieldset>
<label for="zipcode">
Code postal
</label>
<input type="text" name="zipcode" id="zipcode" />
</fieldset>
<fieldset>
<label for="city">
Ville
</label>
<input type="text" name="city" id="city" />
</fieldset>
<fieldset>
<button type="submit">Envoyer</button>
</fieldset>
</form>
</body>
</html>
require "connexion.php";
$id = $_POST['id'];
$street = $_POST['street'];
$city = $_POST['city'];
$zipcode = $_POST['zipcode'];
$query = $db->prepare("UPDATE address
SET street = :street,
city = :city,
zipcode = :zipcode
WHERE id = :id
");
$parameters = [
'id' => $id,
'street' => $street,
'zipcode' => $zipcode,
'city' => $city
];
$query->execute($parameters);