Guest User

Untitled

a guest
Feb 12th, 2018
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. <?php
  2. $hostname = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $databaseName = "coits";
  6.  
  7. $connect = mysqli_connect ($hostname, $username, $password, $databaseName);
  8. $query = "SELECT * FROM `department`";
  9.  
  10. $result1 = mysqli_query ($connect, $query);
  11. ?>
  12. <select>
  13. <?php while ($row1 = mysqli_fetch_array($result1)):; ?>
  14. <option value="<?php echo $row1['departments']; ?>"><?php echo $row1['departments']; ?></option>
  15. <?php endwhile; ?>
  16. </select>
  17.  
  18. <select name="demo">
  19.  
  20. <?php
  21.  
  22. for($i=1; $i<=4; $i++)
  23. {
  24.  
  25. echo "<option value=".$i.">".$i."</option>";
  26. }
  27. ?>
  28. <option name="demo"> </option>
  29. </select>
  30.  
  31. <input type="submit" name="submit" value="insert" />
  32.  
  33. if($_POST['submit'])
  34. {
  35. echo $_POST['demo'];
  36. //then your insert query
  37. }
Add Comment
Please, Sign In to add comment