Advertisement
Guest User

Account Page php

a guest
Dec 3rd, 2016
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. -------------------------------
  2. Account Page info
  3. -----------------------------------
  4.  
  5. #!/usr/local/bin/php
  6. <?php
  7. $connection = oci_connect($username = '---------',
  8. $password = '--------',
  9. $connection_string = '//oracle.cise.ufl.edu/orcl');
  10.  
  11.  
  12. $loginpls = oci_parse($connection, "SELECT * FROM currentUser");
  13. oci_execute($loginpls);
  14. $row = oci_fetch_array($loginpls);
  15. $uname = $row[0];
  16. oci_free_statement($loginpls);
  17.  
  18. //logged in username references the user from member list
  19. $selectMember = oci_parse($connection, "SELECT * FROM member WHERE username = '$uname'");
  20. oci_execute($selectMember);
  21.  
  22. $row = oci_fetch_array($selectMember);
  23. echo'<pre>';
  24. echo"Username:\t$row[0]\n";
  25. echo"Password:\t$row[3]\n";
  26. echo"Name:\t\t$row[2]\n";
  27. echo"Email:\t\t$row[1]\n";
  28. echo"D.O.B.:\t\t$row[4]\n";
  29. echo'</pre>';
  30.  
  31.  
  32. oci_close($connection);
  33. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement