<?php $server = "localhost"; $user = "root"; $password = ""; $db = "sakila"; try { $conn = new PDO("mysql:host=$server;dbname=$db", $user, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); print_r($_GET); $address = filter_input(INPUT_GET, "address"); $district = filter_input(INPUT_GET, "district"); $city_id = filter_input(INPUT_GET, "city_id"); $postal_code = filter_input(INPUT_GET, "postal_code"); $phone = filter_input(INPUT_GET, "phone"); if(!empty($address) && !empty($district) &&!empty($city_id) && !empty($phone)){ $sql="insert into address (address,district,city_id,postal_code,phone) values "; $sql.="('$address','$district',$city_id,'$postal_code','$phone')"; $conn->exec($sql); } $sql = "select city_id,city from city order by city"; $resul = $conn->query($sql); $ciudades = $resul->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $ex) { echo $ex->getMessage(); } ?> <form> Dirección: <input type="text" name="address"><br/> Distrito: <input type="text" name="district"><br/> Ciudad: <select name="city_id"> <option value="0">Seleccione la ciudad</option> <?php foreach ($ciudades as $ciudad) { ?> <option value="<?= $ciudad['city_id'] ?>"><?= $ciudad['city'] ?></option> <?php } ?> </select><br/> Código postal: <input type="text" name="postal_code"><br/> Teléfono: <input type="text" name="phone"><br/> <input type="submit"> </form>