Guest User

Untitled

a guest
Oct 21st, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "testuser";
  4. $password = "dbpassword";
  5. $dbname = "testDB";
  6.  
  7. // Create connection
  8.  
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10.  
  11. // Check connection
  12.  
  13. if ($conn->connect_error)
  14. {
  15. die("Connection failed: " . $conn->connect_error);
  16. }
  17.  
  18. $query = "SELECT DISTINCT BANK FROM BANK_MASTER";
  19.  
  20.  
  21. $response = array();
  22. $result = mysqli_query($conn, $query);
  23.  
  24. while ($row = mysqli_fetch_array($result))
  25. {
  26. $response[] = $row;
  27. }
  28.  
  29. header('Content-Type: application/json');
  30. echo json_encode($response);
  31. $conn->close();
  32. ?>
Add Comment
Please, Sign In to add comment