React + Node js + MySQL - CRUD Operations | CRUD Rest API with Node and Express

[MrDunamis]

Yousaf thanks for this CRUD operation tutorial.

[chadchampion]

Thanks for the video Yousaf, very helpful!

[SmailBAHMIDA]

Perfect tutorial Youcef thnx, just i have question, how to make using server.js more secure, something like API Key or..., to prevent external using of server data ?

[rehankhan]

Yousaf sir please make a video to show the frontend package.json command line and how you install all the packages in front end you have only showed axios and bootstraps but not shows how you install all Dev depencies please help 😊

[opsjbip]

can you please share the database data and github repo

[danielkovacs]

good video!
could you show how to take the app to a live server?

[ujjwalchauhan]

Thanks buddy for the video
very usefull

[supermerolul]

Hey Yousaf i need Help. everything works good but when i put on return res.json(result); on app.delete and app.put server.js,
i get error. if i remove both everything works fine but i have to refresh any edit and delete to see the results.

[fdctitansc]

I love your code. I've learned a great deal. One major flaw in the UPDATE section. Where I can update a new name and email, but if I leave it blank, then it updates the name and email on the table with blank. I don't know how to check whether the user entered anything. Thanks in advance.

[xmatfun]

Sir if i use navigate instead of location.reload. Does it work? pls tell me

[fdctitansc]

Hopefully, this is my last question. I thought it would be useful to pass the name and email from "<td>{data.name}</td>
<td>{data.email}</td> from Student.js to Update.js for the placeholders in Update.js., but I can't figure out how. Please help!

[zoherkhomosi]

hi Mr Yousaf, can you pls show what is terminal command line for frontEnd?

[ayushgautam]

sir plz make a complete log in signup using same mysql nodejs and react .... u gained a sub

[jenobellido]

what about image in database. upload and display.

[fdctitansc]

Can you help me with this error?: 'BrouserRouter' is not defined react/jsx-no-undef

[fdctitansc]

I have .js files instead of .jsx. Did I install something wrong?

[fdctitansc]

Sorry to bother you again, but I'm always getting "Error inside server". How can I debug what's wrong?
const db = mysql.createConnection({

host: "localhost",
user: "root",
password: "",
database: 'webapp_nsquared'
})

app.get('/', (req, res) => {
const sql = "SELECT * FROM names";
db.query(sql, (err, result)=> {
if(err) return res.json({Message: "Error inside server"});
return res.json(result);
})
})

[akrockz]

Bro u didn't show front end code in video pls provide it

[fdctitansc]

But why is it returning an error and not res.json(result)? Could it be my connection to database?

[vihangaavishla]

when I click update button update interface not shows, console shows No routes matched location "/nameupdate/22/313/15"
warning @ history.ts:487