Online PHP editor | output for SaDv4

<?php error_reporting(-1); ini_set('display_errors', 'On'); ?> <?php $servername = "xxxx"; $username = "xxxx"; $password = "xxxx"; $dbname= "xxxx"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected successfully"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } ?> <?php <html> <head> <title>Form</title> </head> <body> <form action="req.php" method="post"> <table> <tr> <td>Nome</td> <td><input type="text" name="nome"/></td> </tr><tr> <td>Cognome</td> <td><select name="cognome"> <?php $stmt = $conn->prepare("SELECT id, cognome FROM req_table"); $stmt->execute(); // set the resulting array to associative while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { foreach($row as $value) { echo '<option value="' . $row['id'] . '">'; echo '<option value="' . $row['cognome'] . '</option>'; } } </select></td> </tr><tr> <td>Indirizzo</td> <td><select name="indirizzo"> <?php $stmt = $conn->prepare("SELECT id, indirizzo FROM req_table"); $stmt->execute(); // set the resulting array to associative while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { foreach($row as $value) { echo '<option value="' . $row['id'] . '">'; echo '<option value="' . $row['indirizzo'] . '</option>'; } } </select></td> </tr><tr> <td colspan="2" style="text-align: center;"> <input type="submit" name="Invia" value="Submit" /> </td> </tr> </table> </form> </body> </html> ?>