Advertisement
Guest User

Untitled

a guest
Mar 15th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. <?php
  2. $servername = "@#$%^&*-amazonaws.com";
  3. $username = "_usrname";
  4. $password = "_pswd";
  5. $dbname = "_databasedb";
  6.  
  7. $conn = mysqli_connect($servername, $username, $password, $dbname);
  8.  
  9. if (!$conn) {
  10. die("Connection failed: " . mysqli_connect_error());
  11. }
  12.  
  13. $sql = "SELECT * FROM tabl1";
  14.  
  15. $result = mysqli_query($conn, $sql);
  16.  
  17. $rows = array();
  18.  
  19. while($r = mysqli_fetch_assoc($result)) {
  20. $rows[] = $r;
  21. }
  22.  
  23. echo json_encode($rows, 128);
  24.  
  25. mysqli_close($conn);
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement