Guest User

Untitled

a guest
Nov 5th, 2017
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "test";
  6. $dbname = "test";
  7.  
  8. // Create Connection
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10.  
  11. //check Connection
  12. if ($conn->connect_error) {
  13. die("Connection failed: ". $conn->connect_error);
  14. }
  15.  
  16. $conn->close();
  17. ?>
  18.  
  19. <!DOCTYPE html>
  20. <html>
  21. <head>
  22. <title>Dropdown AJAX</title>
  23. </head>
  24. <body>
  25. <div class="city">
  26. <label>Stadt</label>
  27. <select name="city">
  28. <option value="">Wähle eine Stadt</option>
  29. <!-- populate using php -->
  30. <?php
  31. $query = "SELECT ort FROM test2";
  32. $result = mysqli_query($conn, $query);
  33. //loop
  34. foreach ($result as $city) {
  35. ?>
  36. <option value="<?php echo $city["ort"]; ?>"></option>
  37. <?php
  38. }
  39. ?>
  40. </select>
  41. </div>
  42. </body>
  43. </html>
Add Comment
Please, Sign In to add comment