<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Create address</title>
</head>
<body>
<form action="create-address.php" method="post">
<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";
$street = $_POST['street'];
$city = $_POST['city'];
$zipcode = $_POST['zipcode'];
$query = $db->prepare("INSERT INTO address (id, street, zipcode, city) VALUES (NULL, :street, :zipcode, :city)");
$parameters = [
'street' => $street,
'zipcode' => $zipcode,
'city' => $city
];
$query->execute($parameters);