Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.69 KB | None | 0 0
  1. $servername = "host:port";
  2. $username = "username";
  3. $password = "password";
  4. $dbname = "db name";
  5.  
  6. // Create connection
  7. $conn = new mysqli($servername, $username, $password, $dbname);
  8. mysqli_select_db($conn, $dbname) or die(mysql_error());
  9.  
  10. // Check connection
  11. if ($conn->connect_error) {
  12.     die("Connection failed: " . $conn->connect_error);
  13. } else {
  14.     echo "Connected successfully";
  15. }
  16.  
  17. $sql = "SELECT * FROM $dbname.myide_users";
  18.    
  19. $result = mysql_query($sql) or die(mysql_error());
  20.    
  21. if (!$result) {
  22.     echo "No results found";
  23. } else {
  24.     while ($row = mysql_fetch_assoc($result)) {
  25.         foreach ($row as $cname => $cvalue) {
  26.             echo "$cname: $cvalue\t";
  27.         }
  28.         echo "\r\n";
  29.     }
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement