Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username = "root";
- $password = "";
- $hostname = "localhost";
- $konekcija = mysqli_connect($hostname, $username, $password) or die("Neuspesna konekcija so MySQL");
- echo "Uspesno povrzan so MySQL<br>";
- $db = mysqli_select_db("Organization", $konekcija) or die("Neuspesno selektiranje na databaza");
- $result = mysqli_query("SELECT * FROM EMPLOYEES");
- while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
- echo 'EMPLOYEE_ID: '. $row['EMPLOYEE_ID'] .'<br/>'.
- 'FIRST_NAME: '. $row['FIRST_NAME'] .'<br/>'.
- 'LAST_NAME: '. $row['LAST_NAME'] .'<br/>'.
- 'EMAIL: '. $row['EMAIL'] .'<br/>'.
- 'HIRE_DATE: '. $row['HIRE_DATE'] .'<br/>'.
- 'JOB_ID: '. $row['JOB_ID'] .'<br/>'.
- 'SALARY: ' . $row['SALARY'] .'<br/>';
- }
- mysql_close($konekcija);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement