Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head><style>
- </style></head>
- <body>
- <form>
- <select name="teams">
- <option value="Atlanta Hawks ">Atlanta Hawks</option>
- <option value="Boston Celtics ">Boston Celtics</option>
- <option value="Charlotte Bobcats ">Charlotte Bobcats</option>
- <option value="Chicago Bulls ">Chicago Bulls</option>
- <option value="Cleveland Cavaliers ">Cleveland Cavaliers</option>
- <option value="Dallas Mavericks ">Dallas Mavericks</option>
- <option value="Denver Nuggets">Denver Nuggets</option>
- <option value="Detroit Pistons ">Detroit Pistons</option>
- <option value="Golden State Warriors">Golden State Warriors</option>
- <option value="Houston Rockets ">Houston Rockets </option>
- <option value="Indiana Pacers ">Indiana Pacers </option>
- <option value="LA Clippers ">LA Clippers</option>
- <option value="LA Lakers ">LA Lakers</option>
- <option value="Memphis Grizzlies ">Memphis Grizzlies</option>
- <option value="Miami Heat">Miami Heat</option>
- <option value="Milwaukee Bucks ">Milwaukee Bucks</option>
- <option value="Minnesota Timberwolves ">Minnesota Timberwolves</option>
- <option value="New Jersey Nets">New Jersey Nets</option>
- <option value="New Orleans Hornets ">New Orleans Hornets</option>
- <option value="New York Knicks ">New York Knicks</option>
- <option value="Oklahoma City Thunder ">Oklahoma City Thunder</option>
- <option value="Orlando Magic ">Orlando Magic</option>
- <option value="Philadelphia Sixers ">Philadelphia Sixers </option>
- <option value="Phoenix Suns ">Phoenix Suns</option>
- <option value="Portland Trail Blazers ">Portland Trail Blazers</option>
- <option value="Sacramento Kings ">Sacramento Kings</option>
- <option value="San Antonio Spurs ">San Antonio Spurs</option>
- <option value="Toronto Raptors ">Toronto Raptors</option>
- <option value="Utah Jazz">Utah Jazz</option>
- <option value="Washington Wizards ">Washington Wizards</option>
- </select>
- <input type="text" name="team">
- <?php
- $con=mysqli_connect("localhost","nbastakm_josh","ateam","nbastakm_Stats");
- if (mysqli_connect_errno()) {
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- }
- $sql = "SELECT fname, lname FROM PlayerRegSeason WHERE team='NYK' and year='2009'";
- $result = mysqli_query($con,$sql);
- if (!$result) {
- printf("Error: %sn", mysqli_error($con));
- exit();
- }
- $playermenu = "
- <p><label>Players</label></p>
- <select name='players' id='players'>";
- while($row=mysqli_fetch_array($result)){
- $playermenu = "<option>".$row['lname']."</option>";
- }
- $playermenu = "</select>";
- echo $playermenu;
- mysqli_close($con);
- ?>
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement