Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <label for="department">Department</label>
- <select class="form-control" name="deptname" id="deptname">
- <option selected disabled></option>
- <?php
- $dbUser = "...";
- $dbPass = "...";
- $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=...)(PORT=1521))(CONNECT_DATA=(SID=...)))";
- $conn = oci_connect($dbUser, $dbPass, $dbConn);
- $sql = "SELECT NAME FROM Department";
- $stid = oci_parse($conn, $sql);
- echo '<select>';
- while ($row = oci_fetch_array(oci_execute($stid, OCI_DEFAULT)))
- {
- echo '<option value="' . $row['NAME'] . '">' . '</option>';
- }
- ?>
- </select>
Add Comment
Please, Sign In to add comment