aquaballoon

PHP - mysqli / mysql

Apr 22nd, 2014
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.84 KB | None | 0 0
  1. //mysqli
  2. <?php
  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. {
  14.     echo "Failed to connect to MySQL: " . mysqli_connect_error();
  15. }
  16.  
  17. $result = mysqli_query($conn, $sql);
  18.  
  19. while($row = mysqli_fetch_array($result)){
  20. echo $row['name'].' '.$row['email'].'<br>';
  21. }
  22. mysqli_close($conn);
  23.  
  24. ?>
  25.  
  26.  
  27. //mysql
  28. <?php
  29. $host = 'localhost';
  30. $user = "root";
  31. $pass = 'abc123';
  32. $db = 'ITDB';
  33. $sql = 'SELECT * FROM GradeTB';
  34.  
  35. $conn = mysql_connect($host, $user, $pass) or die('could not connect to database');
  36. mysql_select_db($db, $conn);
  37.  
  38. $result = mysql_query($sql);
  39.  
  40. while($row = mysql_fetch_array($result)){
  41. echo $row['name'].' '.$row['email'].'<br>';
  42. }
  43. mysql_close($conn);
  44.  
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment