Advertisement
Guest User

GOGO

a guest
Dec 25th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. <?php
  2. $username = "root";
  3. $password = "";
  4. $hostname = "localhost";
  5.  
  6. $konekcija = mysqli_connect($hostname, $username, $password) or die("Neuspesna konekcija so MySQL");
  7.  
  8. echo "Uspesno povrzan so MySQL<br>";
  9.  
  10. $db = mysqli_select_db("Organization", $konekcija) or die("Neuspesno selektiranje na databaza");
  11.  
  12. $result = mysqli_query("SELECT * FROM EMPLOYEES");
  13.  
  14. while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
  15. echo 'EMPLOYEE_ID: '. $row['EMPLOYEE_ID'] .'<br/>'.
  16. 'FIRST_NAME: '. $row['FIRST_NAME'] .'<br/>'.
  17. 'LAST_NAME: '. $row['LAST_NAME'] .'<br/>'.
  18. 'EMAIL: '. $row['EMAIL'] .'<br/>'.
  19. 'HIRE_DATE: '. $row['HIRE_DATE'] .'<br/>'.
  20. 'JOB_ID: '. $row['JOB_ID'] .'<br/>'.
  21. 'SALARY: ' . $row['SALARY'] .'<br/>';
  22. }
  23.  
  24. mysql_close($konekcija);
  25.  
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement