Advertisement
Guest User

Untitled

a guest
Mar 30th, 2016
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1. <?php
  2.  
  3. $server = 'localhost';
  4. $username = '';
  5. $password = '';
  6.  
  7. $dbname = '';
  8.  
  9. $dbconn = pg_connect("dbname=$dbname port=5432 host=localhost user=$username password=$password");
  10.  
  11. $query = pg_query($dbconn, "SELECT id, last_name, first_name, middle_name FROM db_lab_persondata LIMIT $count");
  12. if ($query) {
  13.     while ($row = pg_fetch_assoc($query)) {
  14.         $json[] = array('id' => $row['id'], 'first_name' => $row['first_name'], 'last_name' => $row['last_name'], 'middle_name' => $row['middle_name']);
  15.     }
  16. }
  17.  
  18. header('Content-type: application/json');
  19. echo json_encode($json);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement