Help with NodeJS and PostgreSQL. Send JSON data from NodeJS to Browser.

I will pay only for helping and not doing it for me.

You tell me what to do and I'm doing it.

I have a NodeJS server that uses PostgreSQL as a database.

I'm able to connect to the database and get data from it using NodeJS but I failed to send the data from NodeJS back to the client(frontend).

[login to view URL](nodejs)

const router = (req, res) => {

[login to view URL]([login to view URL]);

let result = [login to view URL]("SELECT * FROM members");

[login to view URL](result);

}

[login to view URL](nodejs)

const {Client} = require('pg');

const connData = { ... };

[login to view URL] = {

async select( sql ){

const db = new Client(connData);

try{

await [login to view URL]();

[login to view URL]("Connected to DB");

const result = await [login to view URL]( sql );

[login to view URL]([login to view URL]); // <--- Shows the data in the NodeJS console.

let str = [login to view URL]([login to view URL]);

return str;

}

catch(ex){

[login to view URL]("We messed up! " + ex);

}

finally{

await [login to view URL]();

[login to view URL]("DB connection closed");

}

}

};

[login to view URL](frontend)

"use strict";

var btn = [login to view URL]('button');

function ajax(){

let req = new XMLHttpRequest();

[login to view URL] = function(){

if( [login to view URL] === 4 && [login to view URL] === 200){

let data = [login to view URL]( [login to view URL] );

[login to view URL](data);

}

};

[login to view URL]("GET", "/ajax/", true);

[login to view URL]();

};

[login to view URL]("click", (e)=>{

[login to view URL]();

ajax();

});

The console in my browser returns a empty string.

JavaScript JSON Node.js PostgreSQL

Numer ID Projektu: #19943245

O projekcie