Advertisement
Guest User

php script

a guest
Feb 14th, 2015
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.43 KB | None | 0 0
  1. <div id="wrapper">
  2.     <div id="title">Change Character Race</div>
  3.     <form action="functions/race.php" method="POST">
  4.         Select a character<br>
  5.         <select name="selectacc">
  6.         <option value="" disabled selected>Select Account</option>
  7. <?php
  8. $conn = new mysqli($host, $dbuser, $dbpass, $authdb);
  9. if ($conn->connect_error) {
  10.     die("Connection failed: " . $conn->connect_error);
  11. }
  12.  
  13. $sql = "SELECT id, username FROM account";
  14.  
  15. $result = $conn->query($sql);
  16.  
  17. if ($result->num_rows > 0) {
  18.     while($row = $result->fetch_assoc()) {
  19.         echo "<option value='" . $row["id"]. "'>" . $row['username'] . "</option>";
  20.     }
  21. } else {
  22.     echo "<option value='' disabled>No characters avalible</option>";
  23. }
  24. $conn->close();
  25. ?>
  26.         </select><br>
  27.         <select name="selectchar">
  28.             <option value="">Select Char</option>
  29.             <!-- Här behövs en jQuery som ska selecta name från characters där account id = resultat från <select name="selectacc"> -->
  30.         </select>
  31.         <select name="race">
  32.             <option value="1">Human</option>
  33.             <option value="2">Orc</option>
  34.             <option value="3">Dwarf</option>
  35.             <option value="4">Night Elf</option>
  36.             <option value="5">Undead</option>
  37.             <option value="6">Tauren</option>
  38.             <option value="7">Gnome</option>
  39.             <option value="8">Troll</option>
  40.             <option value="10">Blood Elf</option>
  41.             <option value="11">Draenei</option>
  42.         </select>
  43.         <br>
  44.         <input type="submit" value="Change Race">
  45.     </form>
  46. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement