Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Dropdown</title>
- </head>
- <body>
- <form action="<?= $PHP_SELF ?>" method="post">
- Stadt:
- <select name="stadt">
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "tagebuch1";
- $mysqli = new mysqli($servername, $username, $password, $dbname);
- if ($mysqli->connect_errno) {
- echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
- }
- // SQL-Query erzeugen
- $sql = "SELECT * FROM privnahrungsmittel ORDER BY privnmName";
- $result = mysql_query($sql);
- // für jeden Eintrag ein Option-Tag erstellen
- while ($row = mysql_fetch_array($result)) {
- echo '<option value="'.$row['idprivNahrungsmittel'].'"'.($_POST['idprivNahrungsmittel'] == $row['idprivNahrungsmittel'] ? " selected": "").'>'.$row['privnmName'].'</option>';
- }
- ?>
- </select>
- <input type="submit" value="Senden" />
- </form>
- </body>
- </html>
Add Comment
Please, Sign In to add comment