0

I am trying to get the data from database but it's coming back with an error: Unexpected end of JSON input

My server get route:

app.get("/auth/login", async (req, res) => {
  try {
    const { email, password } = req.body;
    const findUser = await pool.query(
      "SELECT * FROM users WHERE email = $1 AND password = $2",
      [email, password]
    );
    console.log(findUser, "findUSER");
    res.json(findUser.rows[0]);
  } catch (err) {
    console.error(err.message);
  }
});

And the component that is fetching the data:

const Login = () => {
  const [email, setEmail] = useState("");
  const [password, setPassword] = useState("");
  const [user, setUser] = useState([]);

  const login = async () => {
    try {
      const response = await fetch("http://localhost:5000/auth/login");
      const jsonData = await response.json();
      console.log(jsonData, "jsonData");

      setUser(jsonData);
    } catch (err) {
      console.error(err.message);
    }
  };

  return (
    <div>
      <h1>Login</h1>
      <label>Email</label>
      <input
        type="email"
        onChange={(e) => {
          setEmail(e.target.value);
        }}
      />
      <label>password</label>
      <input
        type="password"
        onChange={(e) => {
          setPassword(e.target.value);
        }}
      />
      <button onClick={login}>Log in</button>
    </div>
  );
};

Do you know what might be an issue?

Thanks

1 Answer 1

2

I am not sure what you are using to interact with your db but I believe that select all from will always return an array meaning find user is more semantically correct with a name of foundUsers. if findUsers is an array, you cannot access rows on an array. You would need to access findUsers[0]

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.