Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head lang="en">
  4. <meta charset="UTF-8">
  5. <title>Select Network</title>
  6. </head>
  7. <body>
  8. <form action="shows.php">
  9. <label for ="networks">Networks</label>
  10. <select name="network_name" id="networks" required>
  11.  
  12. <?php
  13. $conn = new PDO('mysql:host=sql.computerstudi.es;dbname=gc200339389', 'gc200339389', 'dFqU^s25');
  14.  
  15. $sql = "SELECT * FROM networks";
  16.  
  17. $cmd = $conn->prepare($sql);
  18. $cmd->execute();
  19. $bnetworks = $cmd->fetchAll();
  20.  
  21. foreach ($bnetworks as $net){
  22. echo '<option>' . $net['network_name'] . '</option>';
  23. }
  24. $conn = null;
  25. ?>
  26. </select>
  27. <button id="button" type="submit">Get Shows</button>
  28. </form>
  29. </body>
  30. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement