aquaballoon

PHP - MySQL

Apr 17th, 2014
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.46 KB | None | 0 0
  1. <?php
  2.  
  3. $host = 'localhost';
  4. $user = "root";
  5. $pass = 'abc123';
  6. $db = 'ITDB';
  7. $sql = 'SELECT * FROM GradeTB';
  8.  
  9. $conn = mysqli_connect($host, $user, $pass, $db);
  10.  
  11. // Check connection
  12. if (mysqli_connect_errno()) {
  13.     echo "Failed to connect to MySQL: " . mysqli_connect_error();
  14. }
  15.  
  16. $result = mysqli_query($conn, $sql);
  17.  
  18. while($row = mysqli_fetch_array($result)){
  19.     echo "Name: {$row['name']} <br> Email: {$row['email']} <br>";
  20. }
  21. mysqli_close($conn);
  22.  
  23. ?>
Advertisement
Add Comment
Please, Sign In to add comment