Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $server = 'localhost';
- $username = '';
- $password = '';
- $dbname = '';
- $dbconn = pg_connect("dbname=$dbname port=5432 host=localhost user=$username password=$password");
- $query = pg_query($dbconn, "SELECT id, last_name, first_name, middle_name FROM db_lab_persondata LIMIT $count");
- if ($query) {
- while ($row = pg_fetch_assoc($query)) {
- $json[] = array('id' => $row['id'], 'first_name' => $row['first_name'], 'last_name' => $row['last_name'], 'middle_name' => $row['middle_name']);
- }
- }
- header('Content-type: application/json');
- echo json_encode($json);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement