$app->get('/users', function() use($app, $db_postgres){
$sql = "SELECT * FROM tbl_users WHERE type='USER' ORDER BY name";
$rs = pg_query( $db_postgres, $sql );
$users = array();
while($user = pg_fetch_object($rs)){
$users[] = $user;
};
$result = array(
'status' => 'success',
'code' => 200,
'data' => $users
);
echo json_encode($result);
});
router.get('/users', (req, res) => {
client_pg.connect()
client_pg.query("SELECT * FROM tbl_users WHERE type='USER' ORDER BY name", (err, rows, fields) => {
if(!err) {
res.json(rows);
} else {
console.log(err);
}
});
});
if (!err) {
var result = { Status : 'Sucess", Code: 200, Data : rows }
res.json(result);
}
...
res.json({
status: 'success',
code: 200,
data: rows
})
*ngFor="let row of response.data"
getUsers(){
return this._http.get(this.url + 'users').map(res => res.json());
}
@Component({
selector: 'user-list',
templateUrl: '../views/users-list.html',
providers: [UserService]
})
export class UserListComponent {
public titulo: string;
public users: User [];
constructor(
private _route: ActivatedRoute,
private _router: Router,
private _userService: UserService
) {
this.titulo = 'User List';
}
ngOnInit() {
console.log('Load user-rms-list.component.ts successfully');
this._userService.getUsers().subscribe(
result => {
if (result.code !== 200) {
console.log(result);
}else{
this.users = result.data;
}
},
error => {
console.log(<any>error);
}
);
}