Guest User

Untitled

a guest
Mar 29th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. <label for="department">Department</label>
  2. <select class="form-control" name="deptname" id="deptname">
  3. <option selected disabled></option>
  4. <?php
  5. $dbUser = "...";
  6. $dbPass = "...";
  7. $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=...)(PORT=1521))(CONNECT_DATA=(SID=...)))";
  8. $conn = oci_connect($dbUser, $dbPass, $dbConn);
  9. $sql = "SELECT NAME FROM Department";
  10. $stid = oci_parse($conn, $sql);
  11. echo '<select>';
  12. while ($row = oci_fetch_array(oci_execute($stid, OCI_DEFAULT)))
  13. {
  14. echo '<option value="' . $row['NAME'] . '">' . '</option>';
  15. }
  16. ?>
  17. </select>
Add Comment
Please, Sign In to add comment