Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.41 KB | None | 0 0
  1. <?php  
  2.     function printResult($result_set,$dbh){
  3.         $array = array();
  4.         while(($row = $result_set->fetch_assoc()) != false){
  5.             $array[] = $row;
  6.         }
  7.         echo json_encode($array);
  8.     }
  9.     $user = 'root';
  10.     $pass = '';
  11.     $dbh = new mysqli('127.0.0.1', $user, $pass, 'users');
  12.     $result_set = $result_set = $dbh->query("SELECT * FROM `messages`");
  13.     printResult($result_set, $dbh);
  14.     $dbh -> close();
  15. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement