Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = '172.31.44.94';
- $dbuser = 'dbuser';
- $dbpass = 'DBuser';
- $db = 'DBFirst';
- $db = new mysqli($dbhost, $dbuser, $dbpass, $db);
- if($db->connect_errno > 0){
- die('Unable to connect to database [' . $db->connect_error . ']');
- }
- $sql = 'SELECT user_id, user_name, user_email, user_reg FROM user';
- if(!$result = $db->query($sql)){
- die('There was an error running the query [' . $db->error . ']');
- }
- while($row = $result->fetch_assoc()){
- echo "User ID :{$row['user_id']} <br> ".
- "Name: {$row['user_name']} <br> ".
- "Email: {$row['user_email']} <br> ".
- "Registration Date : {$row['user_reg']} <br> ".
- "--------------------------------<br>";
- }
- echo "Fetched data successfully\n";
- $db->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement