Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2014
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.08 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head><style>
  4. </style></head>
  5. <body>
  6. <form>
  7. <select name="teams">
  8. <option value="Atlanta Hawks ">Atlanta Hawks</option>
  9. <option value="Boston Celtics ">Boston Celtics</option>
  10. <option value="Charlotte Bobcats ">Charlotte Bobcats</option>
  11. <option value="Chicago Bulls ">Chicago Bulls</option>
  12. <option value="Cleveland Cavaliers ">Cleveland Cavaliers</option>
  13. <option value="Dallas Mavericks ">Dallas Mavericks</option>
  14. <option value="Denver Nuggets">Denver Nuggets</option>
  15. <option value="Detroit Pistons ">Detroit Pistons</option>
  16. <option value="Golden State Warriors">Golden State Warriors</option>
  17. <option value="Houston Rockets ">Houston Rockets </option>
  18. <option value="Indiana Pacers ">Indiana Pacers </option>
  19. <option value="LA Clippers ">LA Clippers</option>
  20. <option value="LA Lakers ">LA Lakers</option>
  21. <option value="Memphis Grizzlies ">Memphis Grizzlies</option>
  22. <option value="Miami Heat">Miami Heat</option>
  23. <option value="Milwaukee Bucks ">Milwaukee Bucks</option>
  24. <option value="Minnesota Timberwolves ">Minnesota Timberwolves</option>
  25. <option value="New Jersey Nets">New Jersey Nets</option>
  26. <option value="New Orleans Hornets ">New Orleans Hornets</option>
  27. <option value="New York Knicks ">New York Knicks</option>
  28. <option value="Oklahoma City Thunder ">Oklahoma City Thunder</option>
  29. <option value="Orlando Magic ">Orlando Magic</option>
  30. <option value="Philadelphia Sixers ">Philadelphia Sixers </option>
  31. <option value="Phoenix Suns ">Phoenix Suns</option>
  32. <option value="Portland Trail Blazers ">Portland Trail Blazers</option>
  33. <option value="Sacramento Kings ">Sacramento Kings</option>
  34. <option value="San Antonio Spurs ">San Antonio Spurs</option>
  35. <option value="Toronto Raptors ">Toronto Raptors</option>
  36. <option value="Utah Jazz">Utah Jazz</option>
  37. <option value="Washington Wizards ">Washington Wizards</option>
  38.  
  39.  
  40. </select>
  41. <input type="text" name="team">
  42. <?php
  43.  
  44. $con=mysqli_connect("localhost","nbastakm_josh","ateam","nbastakm_Stats");
  45. if (mysqli_connect_errno()) {
  46. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  47. }
  48. $sql = "SELECT fname, lname FROM PlayerRegSeason WHERE team='NYK' and year='2009'";
  49.  
  50. $result = mysqli_query($con,$sql);
  51. if (!$result) {
  52. printf("Error: %sn", mysqli_error($con));
  53. exit();
  54. }
  55. $playermenu = "
  56. <p><label>Players</label></p>
  57. <select name='players' id='players'>";
  58.  
  59. while($row=mysqli_fetch_array($result)){
  60. $playermenu = "<option>".$row['lname']."</option>";
  61. }
  62. $playermenu = "</select>";
  63. echo $playermenu;
  64. mysqli_close($con);
  65.  
  66. ?>
  67.  
  68. </form>
  69.  
  70.  
  71. </body>
  72. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement