Advertisement
khirulnizam

Listing PHP & MySQL database

Feb 4th, 2018
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. <?php
  2. //try connect to database
  3. $db=mysqli_connect("localhost","root","",
  4. "mycompanyhr");
  5.  
  6. //if db setting incorrect
  7. if (mysqli_connect_errno($db)) {
  8. echo "Connect failed: ". mysqli_connect_error($db);
  9. exit();
  10. }
  11. else{//if db no problems
  12. echo "Database connected<br>";
  13. //sql query
  14. $sql="select EMPNO, FIRSTNAME, LASTNAME, PHONENO
  15. from employee";
  16. //execute sql query
  17. $qr=mysqli_query($db, $sql);
  18. //fetch one record
  19. while ($record=mysqli_fetch_array($qr)){
  20. //display record content
  21. echo "Employe ID ".$record['EMPNO']."<br>";
  22. echo "Firstname ".$record['FIRSTNAME']."<hr>";
  23. }//display all using while loop
  24.  
  25. }
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement