Guest User

Untitled

a guest
Apr 4th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.18 KB | None | 0 0
  1. <div class="container">
  2. <div class="panel panel-default">
  3. <div class="panel-body">
  4. <div id="addroles" class="hide" role="alert">
  5. <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  6. <div id="resultActivityContent"></div>
  7. </div>
  8. <form class="cmxform" id="addroles">
  9. <legend>Add Roles</legend>
  10. <label for="names">Select Name</label>
  11. <select class="form-control" name="names" id="names">
  12. <option selected disabled></option>
  13. <?php
  14. $dbUser = "";
  15. $dbPass = "";
  16. $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST= )(PORT= ))(CONNECT_DATA=(SID= )))";
  17. $conn = oci_connect($dbUser, $dbPass, $dbConn);
  18. $sql = oci_parse($conn, "SELECT PERSON.FNAME, PERSON.LNAME FROM PERSON");
  19. oci_execute($sql, OCI_DEFAULT);
  20. ?>
  21. <?php
  22. while (oci_fetch($sql))
  23. { ?>
  24. echo '<option value="<?php echo oci_result($sql, 'FNAME', 'LNAME')?>"><?=oci_result($sql,'FNAME') ?><?=oci_result($sql,'LNAME') ?></option>
  25. <?php
  26. }?>
  27. </select>
  28. <br>
  29. <br>
  30. <label for="role">Select Role</label>
  31. <select class="form-control" name="role" id="role">
  32. <option selected disabled></option>
  33. <?php
  34. $dbUser = " ";
  35. $dbPass = " ";
  36. $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST= )(PORT= ))(CONNECT_DATA=(SID= )))";
  37. $conn = oci_connect($dbUser, $dbPass, $dbConn);
  38. $sql = oci_parse($conn, "SELECT ROLE.ROLEDESC FROM ROLE");
  39. oci_execute($sql, OCI_DEFAULT);
  40. ?>
  41. <?php
  42. while (oci_fetch($sql))
  43. { ?>
  44. echo '<option value="<?php echo oci_result($sql, 'ROLEDESC')?>"><?=oci_result($sql,'ROLEDESC') ?></option>
  45. <?php
  46. }?>
  47.  
  48. </select>
  49. <br>
  50. <button class="btn btn-info btn-primary" type="submit">Add Role</button>
  51. <br>
  52. <br>
  53. </form>
  54. </div>
  55. </div>
  56. </div>
Add Comment
Please, Sign In to add comment