Javascript function keeps returning undefined [duplicate]

Question

I am trying to get image name from database but the function keeps returning undefined

const returnOldFileName = (id) => {
  let imageName;
  const getQuery = `SELECT image from products WHERE id=${id}`;
  db.query(getQuery, (err, result) => {
    console.log(result.rows[0].image);  // getting result here
    if (result) return result.rows[0].image;
  });
};

const image=returnOldFileName(2)
console.log(image) // undefined

Ank i zle · Accepted Answer · 2022-11-26 03:04:15Z

0

db.query(getQuery, (err, result) => {
    console.log(result.rows[0].image);  // getting result here
    if (result) return result.rows[0].image;
});

has a function within it:

(err, result) => {
    console.log(result.rows[0].image);  // getting result here
    if (result) return result.rows[0].image;
});

You are really returning to this function.

The easiest solution would be to make this syrchronous---but this is not recommended, which you can find a method for here.

You can also forgo the return statement, and include the query wherever you need it.

answered Nov 26, 2022 at 3:04

Ank i zle

2,3873 gold badges20 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Javascript function keeps returning undefined [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related