Advertisement
Guest User

Untitled

a guest
Mar 6th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. <?php
  2. $dbhost = '172.31.44.94';
  3. $dbuser = 'dbuser';
  4. $dbpass = 'DBuser';
  5. $db = 'DBFirst';
  6.  
  7. $db = new mysqli($dbhost, $dbuser, $dbpass, $db);
  8.  
  9. if($db->connect_errno > 0){
  10. die('Unable to connect to database [' . $db->connect_error . ']');
  11. }
  12. $sql = 'SELECT user_id, user_name, user_email, user_reg FROM user';
  13.  
  14.  
  15. if(!$result = $db->query($sql)){
  16. die('There was an error running the query [' . $db->error . ']');
  17. }
  18.  
  19. while($row = $result->fetch_assoc()){
  20. echo "User ID :{$row['user_id']} <br> ".
  21. "Name: {$row['user_name']} <br> ".
  22. "Email: {$row['user_email']} <br> ".
  23. "Registration Date : {$row['user_reg']} <br> ".
  24. "--------------------------------<br>";
  25. }
  26. echo "Fetched data successfully\n";
  27. $db->close();
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement