Guest User

PHP - MySQL

a guest
Jul 23rd, 2017
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. /// connect.php ///
  2.  
  3. <?php
  4.  
  5. // Credentials
  6. $mysql_host = 'localhost';
  7. $mysql_user = 'root';
  8. $mysql_pass = '';
  9.  
  10. //Database to use
  11. $mysql_db = 'a_database';
  12.  
  13. //Errors
  14. $conn_error = 'Couldn\'t connect to mysql.';
  15. $db_conn_error = "Couldn't connect to '$mysql_db'";
  16.  
  17.  
  18. $connection = @mysqli_connect($mysql_host, $mysql_user, $mysql_pass) or die($conn_error);
  19. // echo 'Connected to mysql<br>';
  20.  
  21. @mysqli_select_db($connection, $mysql_db) or die($db_conn_error);
  22. // echo 'Connected to db';
  23.  
  24. ?>
  25.  
  26. /// index.php ///
  27.  
  28. <?php
  29. require 'connect.php';
  30.  
  31. $query = "SELECT food, calories FROM `food`; ";
  32.  
  33. if($result = $connection->query($query)) {
  34.     echo 'Query success';
  35.    
  36.     foreach ($result as $result_row) {
  37.         $food = $result_row['food'];
  38.         $calories = $result_row['calories'];
  39.  
  40.         echo $food.' has '.$calories.' calories ';
  41.     }
  42.  
  43. } else {
  44.     echo 'Query failed';
  45. }
  46.  
  47. ?>
Add Comment
Please, Sign In to add comment