Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. <select id="progcode" name="progcode">
  2. <option value="0">-none-</option>
  3. <option value="1" <?php if($progcode == '1') echo 'selected="selected"' ?>>PreS1-AB</option>
  4. <option value="2" <?php if($progcode == '2') echo 'selected="selected"' ?> >PreS1-MM</option>
  5. <option value="3" <?php if($progcode == '3') echo 'selected="selected"' ?> >TutEng</option>
  6. </select>
  7.  
  8. <select id="progcode" name="progcode">
  9. <option value="0">-none-</option>
  10. <option value="1" <?php if($row["progcode"]==1) echo 'selected'; ?>>PreS1-AB</option>
  11. <option value="2" <?php if($row["progcode"]==2) echo 'selected'; ?> >PreS1-MM</option>
  12. <option value="3" <?php if($row["progcode"]==3) echo 'selected'; ?>>TutEng</option>
  13. </select>
  14.  
  15. <?php
  16. $servername = "localhost";
  17. $user = "root";
  18. $password = "";
  19. $db = "ajaxcall";
  20.  
  21. $con = mysqli_connect($servername, $user, $password, $db);
  22. if (!$con) {
  23. die("Connection failed: " . mysqli_connect_error());
  24. }
  25. ?>
  26. <html>
  27. <head>
  28. <meta charset="UTF-8">
  29. <title></title>
  30. </head>
  31. <body>
  32. <select name="name">
  33. <option value=""> -----------ALL----------- </option>
  34. <?php
  35. $query = "select DISTINCT id from crud";
  36. $result = mysqli_query($con, $query);
  37. while ($rows = mysqli_fetch_array($result)) {
  38. echo "<option value='$rows[0]'> $rows[0] </option>";
  39. }
  40. ?>
  41. </select>
  42. </body>
  43. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement