Use React Hooks to fetch data from MySQL with Axios

Question

I have this problem and I hope that you'll be able to help me. So, I've created a React Hook to fetch data from my MySQL database. The code written for the hook is presented below:

const useMySQLToView = (table) => {
    const [rows, setRows] = useState([])

    useEffect(() => {
        async function fetchData() {
            const result = await axios.get("http://localhost:4999/get"+table)
            setRows(result)
        }
        fetchData()
    }, [table])

    return rows
}

Then I tried to get data using the hook on my component:

function ViewEmployees() {
    const {employees} = useMySQLToView('Employees')
    console.log(employees)
    return (
        <div>
            View employees
        </div>
    )
}

The problem is that this console.log(employees) returns undefined. Do you know why? How can I fix this? Thank you!

your employees state should update when data is available from the api — Shubham Khatri
– Shubham Khatri, Commented Mar 28, 2021 at 19:21

thedude · Accepted Answer · 2021-03-28 19:28:31Z

1

Replace const {employees} = useMySQLToView('Employees') with

const employees = useMySQLToView('Employees')

Since your hook is simply returning rows and not an object you can destructure

edited Mar 28, 2021 at 19:28

answered Mar 28, 2021 at 19:21

thedude

9,8371 gold badge34 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Use React Hooks to fetch data from MySQL with Axios

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related